Solve the problem of phpMyAdmin prompt table doesn ' t exit

phpMyAdmin the various "table does not exist" error messages that are prompted when you log in, open the database, and query the table:

Prompt phpmyadmin.pma_recent does not exist when logging on to phpMyAdmin

The prompt table Pma_table_uiprefs does not exist when you open the database

Table pma_tracking not present when querying table data

Online inquires a little, said is to perform phpmyadmin\examples\create_tables.sql import after the use of Navicat to see that the tables do exist, but the query and other operations are still the hint table does not exist, there is no impact And I am in the Query window directly input query statement SELECT * FROM student, still return this error page, and I entered the simple query will become the above image of the complex SQL, (guess this should be the advanced features of phpMyAdmin, What to verify before the query) this is a little dizzy. Fortunately, the author is still patient, continue to search for solutions in the ocean of the network, some say will be in the configuration file $cfg [' Servers '] [$i] [' table_uiprefs '] = ' pma_table_uiprefs '; modified to $cfg [' Servers '] [$i] [' table_uiprefs '] = ' pma__table_uiprefs '; At first glance, it doesn't make any difference. Carefully look at the original PMA and the slide between the length of the line is different, the following is in fact two underline, in accordance with this modification, the problem solved the problem is not enough, the author is an inquisitive person, always ask what, why is this. Looking back at the table in the Navicat, carefully look at the original table name is really an underscore, in order to verify this problem, open the previous import of the Crea_tables.sql file, sure enough. Configuration file part:/* User for Advanced features * * * $cfg [' Servers '] [$i] [' controluser '] = ' PMA '; $cfg [' Servers '] [$i] [' controlpass '] = ';
* Advanced phpMyAdmin Features * * * $cfg [' Servers '] [$i] [' pmadb '] = ' phpmyadmin '; $cfg [' Servers '] [$i] [' bookmarktable '] = ' pma_bookmark '; $cfg [' Servers '] [$i] [' relation '] = ' pma_relation '; $cfg [' Servers '] [$i] [' table_info '] = ' pma_table_info '; $cfg [' Servers '] [$i] [' table_coords '] = ' pma_table_coords '; $cfg [' Servers '] [$i] [' pdf_pages '] = ' pma_pdf_pages '; $cfg [' Servers '] [$i] [' column_info '] = ' pma_column_info '; $cfg [' Servers '] [$i] [' history '] = ' pma_history '; $cfg [' Servers '] [$i] [' designer_coords '] = ' pma_designer_coords '; $cfg [' Servers '] [$i] [' tracking '] = ' pma_tracking '; $cfg [' Servers '] [$i] [' userconfig '] = ' pma_userconfig '; $cfg [' Servers '] [$i] [' recent '] = '; $cfg [' Servers '] [$i] [' table_uiprefs '] = '; After the author experiment, in fact, the above configuration values are set to NULL characters or all of them can be commented out, so do not rely on the database. Just can not use the advanced features of phpMyAdmin, specific these advanced features, the author is not clear, also did not find the relevant information: To solve this problem there are two methods: 1, the Advanced configuration set to empty or comment out 2, import Create_ Tables.sql, and configures the values of these advanced attributes based on the table name (you can see the table name)