mysql contains 3 root accounts without password

sleife
Posts: 79
Joined: Tue Nov 02, 2010 2:56 am

mysql contains 3 root accounts without password

Postby sleife » Fri Mar 08, 2013 1:28 pm

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.

User avatar
bigfoot65
Project Manager
Posts: 11924
Joined: Mon May 25, 2009 4:31 pm

Re: mysql contains 3 root accounts without password

Postby bigfoot65 » Fri Mar 08, 2013 3:08 pm

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.
ßîgƒσστ65
Applications Manager

My HDA: Intel(R) Core(TM) i5-3570K CPU @ 3.40GHz on MSI board, 16GB RAM, 1TBx1+2TBx2+4TBx2

Who is online

Users browsing this forum: No registered users and 50 guests