Thread: WARNING: mysql.user contains 2 root accounts without password! Uh-Oh, how do I fix!

solved

had lot of problems setting mysql , had reset password. there way see how many root accounts there in total. think have 1 root account password , 2 without. how go deleting 2 passwordless accounts or finding them?

if have phpmyadmin installed, click on "mysql" database, click "user" table, , click "x" (delete) icon next root accounts wish remove.

if don't have phpmyadmin installed, here command-line way:
(names , passwords have been altered protect innocent)

code:

% mysql -u root -p  enter password:   welcome mysql monitor.  commands end ; or \g.  mysql connection id 104  server version: 5.0.67-0ubuntu6 (ubuntu)    type 'help;' or '\h' help. type '\c' clear buffer.

code:

mysql> use mysql;  reading table information completion of table , column names  can turn off feature quicker startup -a    database changed

code:

mysql> select host,password user user='root';  +-----------+-------------------------------------------+  | host      | password                                  |  +-----------+-------------------------------------------+  | localhost | *xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx |   | hostname  | *xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx |   | 127.0.0.1 | *xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx |   +-----------+-------------------------------------------+  3 rows in set (0.00 sec)

code:

mysql> delete user user='root' , host='hostname';

Forum The Ubuntu Forum Community Ubuntu Specialised Support Security [SOLVED] WARNING: mysql.user contains 2 root accounts without password! Uh-Oh, how do I fix!

Ubuntu