The problem that the additional functions of phpMyAdmin linked table have not been activated

The problem that the additional functions of phpMyAdmin linked table have not been activated_PHP Tutorial

WBOY

Release： 2016-07-21 15:34:39

Original

1148 people have browsed it

When installing phpMyAdmin, I still did not manually configure the config file, but used its setup function.
Default values are used except for server name and authentication method.
I entered the server name randomly and changed the authentication method to http.
In addition, on the PMA database page, click the pen behind the text box and fill in the default value.
(At this time, I have created the control user and entered the user name and password. I will talk about the creation method later)
After saving the settings, enter the MySQL root user name and password, and open the main page of phpMyAdmin After the screen, the following error appears
The problem that the additional functions of phpMyAdmin linked table have not been activated_PHP Tutorial
After clicking here, the screen you see is as follows

The things to pay attention to when solving this problem are as follows.
1. Deletion and copying of the .config file
This may not be the key to the problem, but after the problem occurred, I read the official documentation and then dealt with it.
After saving the settings on the setup screen, copy ./config/config.inc.php to ./ which is the root directory, and then delete the ./config directory
2. Create databases and tables required for additional functions
There is a create_tables.sql file in the ./scripts folder. Import it into MySQL and create the corresponding table.
Although there are still problems with the additional functions, you can already use phpMyAdmin to manage MySQL, so I poured the create_tables.sql file through the following screen
The problem that the additional functions of phpMyAdmin linked table have not been activated_PHP Tutorial
3. Create a control user
I had already created this before the problem arose.
I used the MySQL command line tool to execute the SQL command.

Copy code The code is as follows:

 
GRANT USAGE ON mysql.* TO 'pma'@'localhost' IDENTIFIED BY 'pmapass '; 🎜>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'; 
GRANT SELECT, INSERT, UPDATE, DELETE ON .* TO 'pma'@'localhost'; 

 
4. Modify the config.inc.php file . 
Because tracking is not set on the setup screen, after the above processing, the other items in the second picture all turned green, but the last item was still red. 
So I added the line 
$cfg['Servers'][$i]['tracking'] = 'pma_tracking'; 

to the config.inc.php file.
5. There are cases where the modification of the config.inc.php file does not take effect
After completing the settings 1 to 3, when accessing the main screen, the setting of the second picture does not immediately turn green.
In order to verify whether the modification of the config.inc.php file has any effect, I changed a very important setting 'host' in the file and randomly added a few a's at the end.
An error occurred when accessing phpMyAdmin later. Then remove those a's, and when you visit again, except for the last item tracking, everything else is green.
Maybe it’s because of the browser or apache cache problem. I haven’t figured it out yet.

http://www.bkjia.com/PHPjc/322369.htmlwww.bkjia.com