如何找出MySQL root密码
我不知道我的 MySQL 根密码；我怎样才能找到这个?是否有任何文件存储此密码?
I cannot figure out my MySQL root password; how can I find this out? Is there any file where this password is stored?
我正在关注这个 link 但我关注本地没有directadmin目录.
I am following this link but I do not have directadmin directory in local.
推荐答案
感谢@thusharaK，我可以在不知道旧密码的情况下重置 root 密码.
thanks to @thusharaK I could reset the root password without knowing the old password.
在 ubuntu 上我做了以下事情:
On ubuntu I did the following:
sudo service mysql stop
sudo mysqld_safe --skip-grant-tables --skip-syslog --skip-networking
然后在新终端中运行mysql:
Then run mysql in a new terminal:
mysql -u root
并运行以下查询以更改密码:
And run the following queries to change the password:
UPDATE mysql.user SET authentication_string=PASSWORD('password') WHERE User='root';
FLUSH PRIVILEGES;
在 MySQL 5.7 中，mysql.user 表字段中的密码字段被删除，现在字段名称为authentication_string".
退出mysql安全模式，启动mysql服务:
Quit the mysql safe mode and start mysql service by:
mysqladmin shutdown
sudo service mysql start
相关文章