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

问题描述

我不知道我的 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

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