The system defaults to the MySQL user name disappears the resolution method

Modify the default MySQL database under MySQL user table, delete all host for localhost record, add some other records, restart the MySQL server. Execute show databases, only INFORMATION_SCHEMA and test two databases, not MySQL.

Workaround:

The problem is actually that the user does not have permissions:

1. Close MySQL

2. Start Mysql:mysqld_safe--skip-grant-tables

In the user table under database name MySQL, modify the appropriate permissions, such as:

INSERT into ' user ' VALUES (' localhost ', ' root ', ', ', ' y ', ' y '), ' y ', ' y ', ' y ', ' y ', ' y ', ' y ', ' y ', ' y ', ' y ', ' y ', ' y ', ' y ', ' ', ', ' y ', ' y ', ' Y ', ' y ', ' y ', ' y ', ' y ', ' y '