mysql启动命令

①安装服务：mysqld --install

②初始化：　mysqld --initialize --console

③开启服务：net start mysql

④关闭服务：net stop mysql

⑤登录mysql：mysql -u root -p

Enter PassWord：(密码)

⑥修改密码：alter user ‘root’@‘localhost’ identified by ‘root’;(by 接着的是密码)

⑦标记删除mysql服务：sc delete mysql

// 退出

exit

 

// 解决node.js第一次连接mysql的时候无法连接的问题

ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY '123456';