When we do the virtual host, many need to open an account in the PHP myadmin for a customer to manage the database of the customer's own website, but do not want the customer to see another database. There are many said on the Internet to modify the configuration of the phpMyAdmin, all kinds of people confused.
In fact, the method is very simple.
1. Log in first with root phpMyAdmin
2. The right side of the phpMyAdmin home page to the left of the navigation department to find permission column.
3. Open the right column, add a user, enter the user name, host write localhost, and then enter the password, remember not to click the next generation password.
4.Database for user can choose to establish a database with the same name as the user name, if you want to open a database with the same name as the user name to the user.
5. The following permissions can not be selected, the direct point of execution, the database will be set by default permissions.
6. Exit, login with the new username and password phpMyAdmin, everything is OK.
Source: http://www.bizeway.net/read.php?571
