On Debian/Ubuntu MySQL root user can only login using socket. This is done with Plugin.
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.
update mysql.user set Plugin='' where User="root"; flush privileges;
Leave a Reply