"PhpMyAdmin advanced performance is not all set, and some functions are unavailable. Click here to find out the cause ."

"Not all advanced phpMyAdmin functions are set, and some functions are unavailable. Click here to find out the cause ." After logging on to phpmyadmin & nbsp;, the message "phpMyAdmin & nbsp; advanced functions are not all set, and some functions are unavailable. Click here to find out the cause ." Follow the steps below to solve the problem by using the SQL file phpmyadmin/scrip "phpMyAdmin advanced features are not all set, some features are unavailable. Click here to find out the cause ."
After logging on to phpmyadmin, the system prompts "advanced phpMyAdmin functions are not all set, and some functions are unavailable. Click here to find out the cause ."




Follow the steps below to solve the problem

Use the SQL file phpmyadmin/script/create_tables. SQL to create the phpmyadmin data table. Directly use the phpmyadmin import function.

Create a username and enter the SQL code in the SQL query function box of phpmyadmin:
Grant usage on mysql. * TO 'PMA' @ 'localhost' identified by 'pmapass ';
Grant select (
Host, User, Select_priv, Insert_priv, Update_priv, Delete_priv,
Create_priv, Drop_priv, Reload_priv, Shutdown_priv, Process_priv,
File_priv, Grant_priv, References_priv, Index_priv, Alter_priv,
Show_db_priv, Super_priv, Create_tmp_table_priv, Lock_tables_priv,
Execute_priv, Repl_slave_priv, Repl_client_priv
) ON mysql. user TO 'PM' @ 'localhost ';
Grant select on mysql. db TO 'PM' @ 'localhost ';
Grant select on mysql. host TO 'PM' @ 'localhost ';
Grant select (Host, Db, User, Table_name, Table_priv, Column_priv)
ON mysql. tables_priv TO 'PMA' @ 'localhost ';


Add the following code to config. inc. php in the root directory of phpmyadmin:

$ Cfg ['servers'] [$ I] ['controluser'] = 'PMA ';
$ Cfg ['servers'] [$ I] ['controlpass'] = 'pmapass ';

$ 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 _ page'] = 'PMA _ pdf_pages ';
$ Cfg ['servers'] [$ I] ['column _ info'] = 'PMA _ column_info ';
$ Cfg ['servers'] [$ I] ['History '] = 'PMA _ history ';
$ Cfg ['servers'] [$ I] ['tracking'] = 'PMA _ tracking ';
$ Cfg ['servers'] [$ I] ['designer _ coords '] = 'PMA _ designer_coords ';
$ Cfg ['servers'] [$ I] ['userconfig'] = 'PMA _ userconfig ';




After the above configuration, why is the prompt "phpMyAdmin advanced functions are not all set, some functions are unavailable" still displayed ???


------ Solution --------------------
No. please click here to find out the cause. When you click it, the related settings are displayed. if you set all settings, no prompt is displayed.
------ Solution --------------------
I'm wondering where your full-width single quotes come from. change them to half-width ones and try again.