在项目中安装MySQL模块
cnpm install mysql ②.配置环境变量在环境变量中增加C:Program FilesMySQLMySQL Server 8.0yqdy
变量名称可以随便起,比方说mysql_home
变量值为C:Program FilesMySQLMySQL Server 8.0yqdy
Client does not support authentication protocol requested by server
1.通过命令行进入解压的mysql根目录(C:Program FilesMySQLMySQL Server 8.0yqdy)下。
2.登陆数据库
3.输入root的密码
Enter password: ******4.更改加密方式
mysql> ALTER USER 'root'@'localhost' IDENTIFIED BY 'password' PASSWORD EXPIRE NEVER;5.更改密码:该例子中 123456为新密码
mysql> ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY '123456';6.刷新:
mysql> FLUSH PRIVILEGES; ④.js文件格式 var mysql = require('mysql');//引用Mysql var connection = mysql.createConnection({//配置连接 host: 'localhost',//数据库地址 user : "xxx",//数据库用户 password: "xxx",//数据库密码 database : "world"//需要连接的数据库 }); connection.connect();//连接数据库 connection.query('select * from city',function(err,rows,fields){//执行sql语句 if(err) throw err ; console.log('thesolution is:' ,rows[0]); }); connection.end();//断开连接