您正在使用mariadb作为匿名用户

本文介绍了您正在使用mariadb作为匿名用户的处理方法，对大家解决问题具有一定的参考价值，需要的朋友们下面随着小编来一起学习吧！ 问题描述

所有特权都被拒绝，我的所有数据库似乎都已删除.尝试更改密码时，出现主题中提到的错误. 最初没有设置密码，并且在执行以下命令后开始此行为

All the privileges have been denied and all my databases seem to have been deleted. I get the error mentioned in the subject when I try to change the password. Initially there was no password set and this behaviour started after executing the following command

update mysql.user set password=password('newpass') where user='root';

我使用以下命令输入mysql

I enter mysql using:

mysql -u root

我尝试执行的每个命令都会给我访问被拒绝的错误.我曾尝试在Google上冲浪，但没有找到解决此问题的解决方案.

Every command I try to execute gives me access denied error. I tried surfing on google but did not get a solution to solve the issue.

推荐答案

您还必须设置用户的插件，并且每次都要刷新特权

You must set the plugin of the user too, and flush privileges everytime

> update mysql.user set password=password('newpass') where user='root'; > flush privileges; > update mysql.user set plugin='mysql_native_password' where user='root'; > flush privileges;

然后检查数据库实例启动时您是否未使用匿名用户:在您的/etc/myf中，删除/注释任何看起来像这样的行

Then check you are not using an anonymous user when the database instance starts: in your /etc/myf remove/comment any line which looks like this

skip-grant-tables #comment with #

然后重新启动数据库

service <db> restart