安装 mysql 时,我没有在 root 密码字段中输入任何内容,但是当我运行 mysql -u root
时,我仍然收到 Access denied for user 'root'@'localhost'
.
When installing mysql, I didn't put anything in the root password fields, but when I ran mysql -u root
I still got Access denied for user 'root'@'localhost'
.
我在没有授权表的情况下以安全模式启动 mysql,sudo mysql_safe --skip-grant-tables &
,然后使用 mysql -u root
跳转,没有一个问题.
I started mysql up in safe mode without the grant tables, sudo mysql_safe --skip-grant-tables &
, then jumped in with mysql -u root
without a problem.
然后我做了使用mysql;更新用户集 authentication_string=null where user='root';
和我得到:
Then I did use mysql; update user set authentication_string=null where user='root';
and I got:
Query OK, 0 rows affected (0.00 sec)
Rows matched: 1 Changed: 0 Warnings: 0
有人知道为什么密码没有更新吗?
Anyone have any insight on why the password isn't updating?
我不得不将插件设置为mysql_native_password
,所以密码重置部分看起来像这样:
I had to set the plugin to mysql_native_password
, so the password reset part looks like this:
update user set authentication_string=password(''), plugin='mysql_native_password' where user='root'; FLUSH PRIVILEGES;
这篇关于无法将 root MySQL 密码设置为 null的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持跟版网!