ubuntu18.04 初始化mysql

/ 默认分类 / 0 条评论 / 2334浏览

同时解决:ERROR 1698 (28000): Access denied for user 'root'@'localhost'

  1. sudo cat /etc/mysql/debian.cnf

记住password 项的值 是初始密码

  1. mysql -u debian-sys-maint -p
  2. 输入初始密码
  3. use mysql;
  4. update mysql.user set authentication_string=password('') where user='root' and Host ='localhost';
  5. update user set plugin="mysql_native_password";
  6. flush privileges;
  7. quit;
  8. sudo service mysql restart

此时mysql初始化密码为空 后期自己修改即可

mysql -u root -p 回车即可