Ubuntu18.04(linux)安装MySQL的方法步骤

mysql> GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' WITH GRANT OPTION; Query OK, 0 rows affected (0,00 sec) mysql> FLUSH PRIVILEGES; Query OK, 0 rows affected (0,01 sec)

关于重置密码

host为%时允许远程登录

SET PASSWORD FOR root@'localhost' = PASSWORD('password');

or

UPDATE mysql.user SET Password=PASSWORD('newpwd') WHERE User='root';

or

USE mysql UPDATE user SET Password = PASSWORD('newpwd') WHERE Host = 'localhost' AND User = 'root';

允许任何地方登录

USE mysql UPDATE user SET Password = PASSWORD('newpwd') WHERE Host = '%' AND User = 'root';

参考
https://askubuntu.com/questions/766334/cant-login-as-mysql-user-root-from-normal-user-account-in-ubuntu-16-04
https://help.ubuntu.com/community/MysqlPasswordReset

以上就是本文的全部内容，希望对大家的学习有所帮助，也希望大家多多支持易采站长站。

您可能感兴趣的文章:

ubuntu系统中Mysql ERROR 1045 (28000): Access denied for user root@ localhost问题的解决方法Ubuntu下MySQL root密码忘记的解决方法解决ubuntu 16.04安装mysql5.7.17后,登录时出现ERROR 1045 (28000): Access denied for user ''root''@''localhost''问题Ubuntu手动安装mysql5.7.10ubuntu 16.04下mysql5.7.17开放远程3306端口Linux(Ubuntu)下mysql5.7.17安装配置方法图文教程mysql 5.7.17 安装配置方法图文教程（ubuntu 16.04）Ubuntu18.04 安装mysql8.0.11的图文教程