[Warning] 'user' entry 'root@xxx' has both a password and an authentication plugin specified. 的解决方案

如题,在树莓派上安装mariadb 10时遇到了这个错误。具体错误如下:

May 02 10:39:01 xxx mysqld[1148]: 200502 10:39:01 [Note] InnoDB: Waiting for purge to start
May 02 10:39:01 xxx mysqld[1148]: 200502 10:39:01 [Note] InnoDB: Percona XtraDB (http://www.percona.com) 5.6.32-79.0 started; log sequence number 1628926
May 02 10:39:01 xxx mysqld[1148]: 200502 10:39:01 [Note] Plugin 'FEEDBACK' is disabled.
May 02 10:39:01 xxx mysqld[1148]: 200502 10:39:01 [Note] Server socket created on IP: '127.0.0.1'.
May 02 10:39:01 xxx mysqld[1148]: 200502 10:39:01 [Warning] 'user' entry 'root@localhost' has both a password and an authentication plugin specified. The password will be ignored.
May 02 10:39:01 xxx mysqld[1148]: 200502 10:39:01 [Note] /usr/sbin/mysqld: ready for connections.
May 02 10:39:01 xxx mysqld[1148]: Version: '10.0.28-MariaDB-2+b1' socket: '/var/run/mysqld/mysqld.sock' port: 3306 Raspbian testing-staging

这个问题是Mysql的部分插件与密码验证冲突,mysql服务器默认抛弃密码验证导致的,并会导致php程序(如phpmyadmin)无法访问该mysql数据库服务器。经过搜索与测试,可行的解决方法为在mysql命令行控制台下运行:

UPDATE mysql.user SET plugin = '' WHERE plugin = 'unix_socket';
FLUSH PRIVILEGES;

Enjoy~

点赞

发表评论

电子邮件地址不会被公开。 必填项已用*标注

You must enable javascript to see captcha here!