https://www.cnblogs.com/williamjie/p/11126486.html
sudo cat /etc/mysql/debian.cnf
user 是临时登录名
password 是临时密码
设置 root 密码:
use mysql;
update mysql.user set authentication_string=password('123456') where user='root' and Host ='localhost'; #修改密码123456是密码
update user set plugin="mysql_native_password";
flush privileges;
quit;
重启 mysql
启动mysql:
方式一:sudo /etc/init.d/mysql start
方式二:sudo service mysql start
停止mysql:
方式一:sudo /etc/init.d/mysql stop
方式二:sudo service mysql stop
重启mysql:
方式一:sudo/etc/init.d/mysql restart
方式二:sudo service mysql restart