The PhpMyAdmin advanced features are not all set and some features are not available. To find out why, please click here. ”
After configuring PhpMyAdmin login, the general prompt "PhpMyAdmin advanced features not all set, some features are not available." To find out why, please click here. ”
I'll fix it in the following way
Create a data table phpMyAdmin from the SQL file Phpmyadmin/script/create_tables.sql. Use the phpMyAdmin import function directly.
To create a corresponding user name, enter the SQL code in the SQL query function box in phpMyAdmin:
GRANT USAGE on mysql.*-' 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 ' PMA ' @ ' localhost ';
GRANT SELECT on mysql.db to ' PMA ' @ ' localhost ';
GRANT SELECT on Mysql.host to ' PMA ' @ ' localhost ';
GRANT SELECT (Host, DB, User, TABLE_NAME, TABLE_PRIV, COLUMN_PRIV)
On Mysql.tables_priv to ' PMA ' @ ' localhost ';
Add the following code to the config.inc.php of the phpMyAdmin root directory:
$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_pages '] = ' 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 configuring, why does the "PhpMyAdmin advanced feature not all set, some features not available" prompt???
------Solution--------------------
There's not going to be a reason to find out. Please click here. The point will have the relevant settings prompts are set up will not prompt should be.
------Solution--------------------
I wonder where your full-width single quotes come from, and then try to make half-corners.
