MySQL root can’t login to phpMyAdmin
On Debian/Ubuntu MySQL root user can only login using socket. This is done with Plugin.
1 2 3 4 5 6 7 8 9 10 |
MariaDB [(none)]> select User, Plugin from mysql.user; +-----------+-------------+ | User | Plugin | +-----------+-------------+ | root | unix_socket | | sserverok | | +-----------+-------------+ 2 rows in set (0.00 sec) MariaDB [(none)]> |
To fix this, first set a password for user root.
To disable plugin, run following commands in MySQL command prompt as user root.
1 2 |
update mysql.user set Plugin='' where User="root"; flush privileges; |