Pine Blog

Ubuntu 18.04 MySQL 8.0.20为root用户设置密码

1、修改/etc/mysql/mysql.conf.d/mysqld.cnf文件
添加:skip-grant-tables=1

2、登录MySQL,并刷新
mysql>FLUSH PRIVILEGES;
3、修改root密码,并刷新
mysql>ALTER USER ‘root‘@‘localhost‘ IDENTIFIED WITH mysql_native_password BY ‘Password@123‘;
mysql>FLUSH PRIVILEGES;

4、设置远程登录并刷新
mysql>use mysql;
mysql>update user set host=‘%‘ where user=‘root‘;
mysql>FLUSH PRIVILEGES;

5、退出重新用新密码登陆
mysql -u root -p

未经允许不得转载:Pine Blog » Ubuntu 18.04 MySQL 8.0.20为root用户设置密码

评论 抢沙发

  • 昵称 (必填)
  • 邮箱 (必填)
  • 网址

Pine Blog
Anywhere, Anytime
E-mail:59054872@qq.com
苏ICP备15059480号-1