如何找出MySQL的root密码 [英] How to find out the MySQL root password

问题描述

我无法找出我的MySQL root密码;我怎么能找到这个？是否有任何文件存储此密码？

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 query, after changing the password

UPDATE mysql.user SET Password=PASSWORD('password') WHERE User='root';
FLUSH PRIVILEGES;

退出mysql安全模式，并通过

quit the mysql safe mode and start mysql service by

mysqladmin shutdown
sudo service mysql start

这篇关于如何找出MySQL的root密码的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！