Page 1 of 1

mysql contains 3 root accounts without password

Posted: Fri Mar 08, 2013 1:28 pm
by sleife
Hi everybody

How can i check, which users are that and how can i open this File "/usr/bin/mysqlcheck" ?
Mar 8 21:04:35 hda-desktop /etc/mysql/debian-start[21606]: Triggering myisam-recover for all MyISAM tables
Mar 8 21:04:35 hda-desktop /etc/mysql/debian-start[21604]: WARNING: mysql.user contains 3 root accounts without password!
Mar 8 21:04:35 hda-desktop /etc/mysql/debian-start[21598]: Checking for insecure root accounts.
Mar 8 21:04:35 hda-desktop /etc/mysql/debian-start[21587]: This installation of MySQL is already upgraded to 5.5.29, use --force if you still need to run mysql_upgrade
Mar 8 21:04:35 hda-desktop /etc/mysql/debian-start[21587]: Looking for 'mysqlcheck' as: /usr/bin/mysqlcheck
Mar 8 21:04:35 hda-desktop /etc/mysql/debian-start[21587]: Looking for 'mysql' as: /usr/bin/mysql
Mar 8 21:04:35 hda-desktop /etc/mysql/debian-start[21587]: /usr/bin/mysql_upgrade: the '--basedir' option is always ignored
Mar 8 21:04:35 hda-desktop /etc/mysql/debian-start[21584]: Upgrading MySQL tables if necessary.

Re: mysql contains 3 root accounts without password

Posted: Fri Mar 08, 2013 3:08 pm
by bigfoot65
You can install an app like:

Adminer
http://www.amahi.org/apps/adminer

phpMyAdmin
http://www.amahi.org/apps/phpmyadmin

Chive
http://www.amahi.org/apps/chive

or the documentation for MySQL:
http://dev.mysql.com/doc/

The apps will let you see users and you can remove any that are not needed. Unless you added any new ones, there should be only one root user by default.