phpMyAdmin Common Errors

phpMyAdmin cannot log in with root (username and password are correct)

Solve:

See if the MySQL client can log in (I am not able to log in), if you can not log in to change the root password, changed to log on. phpMyAdmin log in after refreshing the page.

phpMyAdmin after entering the page can not browse the contents of the database, the left will appear error #1146-table ' phpmyadmin.pma_recent ' doesn ' t exist

Solve:

Find/-name create_tables.sql  ' finds the table's location, which is required to open phpMyAdmin advanced features

If you import this table in phpMyAdmin, you will not be able to report this error.

The "Control user connection failed using the profile defined in the configuration file"appears below the phpMyAdmin login page, and the access page also displays

Solve:

Find/-name config.inc.php   ' Locate the file cp/etc/phpmyadmin/config.inc.php./config.inc.php.bak  ' My file in that position, first put it , Vim config.in.php  ' edit the file to find $cfg [' Servers '] [$i] [' Controluser '] and $cfg[' Servers ' [$i] [' Controluser '] The values in front of these two settings are changed to the MySQL user name, followed by a corresponding password, as follows: $cfg [' Servers '] [$i] [' controluser '] = ' root '; $cfg [' Servers '] [$i] [' Controlpass '] = ' 123456789 ';

Refreshing the phpMyAdmin will not be displayed.