Can’t change user options in MySQL Administrator

May be you installed MySQL 5 and you are not able to change user information, schema privileges and resources for your MySQL users using the MySQL Administrator. You select “User Administration” then a “User Account” but it keeps saying “No user selected” like in this capture:

It may be caused because your mysql database doesn’t have the user_info table. Run this in MySQL Query Browser or in the MySQL terminal to create the user_info table and the problem should be fixed.

DROP TABLE IF EXISTS `mysql`.`user_info`;
CREATE TABLE  `mysql`.`user_info` (
  `User` varchar(16) COLLATE utf8_bin NOT NULL,
  `Full_name` varchar(60) COLLATE utf8_bin DEFAULT NULL,
  `Description` varchar(255) COLLATE utf8_bin DEFAULT NULL,
  `Email` varchar(80) COLLATE utf8_bin DEFAULT NULL,
  `Contact_information` text COLLATE utf8_bin,
  `Icon` blob,
  PRIMARY KEY (`User`),
  KEY `user_info_Full_name` (`Full_name`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_bin COMMENT='Stores additional user information';

People upgrading to MySQL 5 from other versions have solved this problem by executing the following command inside bin folder of MySQL installation directory:

mysqlcheck --check-upgrade --all-databases --auto-repair

And then running the mysql_fix_privilege_tables.sql script. You have to login to MySQL as root on the mysql database running this command from the bin folder of MySQL installation directory:

mysql -u root -p mysql

Type root’s password when asked and then run this in the MySQL terminal:

SOURCE ../scripts/mysql_fix_privilege_tables.sql;

If you don’t have the mysql_fix_privilege_tables.sql file in the scripts folder (or you don’t have that folder at all), download a zip archive noinstall version of MySQL, extract it and search that file. Or you can just download the file from here: mysql_fix_privilege_tables.sql.zip. Don’t forget unzipping it and copying it to your scripts folder inside the MySQL installation directory.

Once the script is completed restart your MySQL server.

Source: http://bugs.mysql.com/bug.php?id=25515

You might also like

Change root password in MySQL
In GNU/Linux:$ sudo mysqld_safe --skip-grant-tables & $ mysql -u root -p #press enter to use a...

Connect to MySQL over SSH with MySQL Workbench
If you don't have phpMyAdmin installed on your server or you don't feel comfortable using it there's...

Run shell commands in Mac OS X executing a normal application
Once I installed Apache2+MySQL5+PHP5.3 using MacPorts I wanted to start and stop the services without...

Change password for postgres user in PostgreSQL
In order to change the password for the postgres user you should NEVER do this:$ sudo passwd postgresBy...

Leave a comment ?

13 Comments.

  1. I can’t believe no body say thank you to such a helpful piece of information. Thanks, you save me time today.

  2. Thank you for sharing this info!

  3. Gracias, me funcionó la primera solución!

  4. WOW. Thanks for the post. Very Helpful. 🙂

  5. I didn’t find “mysql_fix_privilege_tables.sql” in the mysql installation package. However, your script did the job perfectly.
    i had the same problem with a fresh install of MySQL 5.5… very strange…
    The problem stays on MySQL bug reports from nearly 1 year.
    Thanks a lot!

  6. Merci
    very helpful

  7. Thank you, the user_info SQL statement also worked for me! I have never had this problem before with MySQL Administrator until now. I first thought there was a problem with Windows file permissions/UAC or something.

  8. I LOVE YOU! I’ve been trying to figure this out for 3 hours now.

  9. Thank you!!!!

  10. Very very very thank you!

  11. thanks you, here work Perfect!

  12. Thanks alot…. perfect

Leave a Comment

This site uses Akismet to reduce spam. Learn how your comment data is processed.