Problem with phpMyAdmin linking table additional functionality not yet enabled

  • 2020-03-31 21:01:05
  • OfStack

I still didn't manually configure the config file when I installed phpMyAdmin, but instead used its setup functionality.
Default values are used except for the server name and authentication method.
The name of the server itself was randomly entered, and the authentication method was changed to HTTP.
In addition, the PMA database page has the pen at the back of the text box to fill in the default values.
At this point I have created the control user and entered the username and password. I'll talk about it later.)
After saving the Settings, enter the root username and password of MySQL and open the main screen of phpMyAdmin. The following error occurs
< img border = 0 SRC = "http://files.jb51.net/upload/201008/20100801211257429.jpg" border = 0 >
Click here to see the following screen
< img border = 0 SRC = "http://files.jb51.net/upload/201008/20100801213457417.jpg" border = 0 >

The following points should be noted to solve this problem.
1. Config file deletion and copy processing
This may not be the problem, but I read the official documentation after the problem, and then dealt with it.
After the setup screen has saved the Settings, copy./config/config.inc. PHP to./, that is, the root directory, and then delete./config
2. Create the databases and tables needed for additional functionality
There is a create_tables. SQL file under the./scripts folder, import it into MySQL, and create the corresponding table.
The additional functionality is problematic, but you can already manage MySQL using phpMyAdmin, so I've poured the create_tables.sql file into the following screen
< img border = 0 SRC = "http://files.jb51.net/upload/201008/20100801213546981.jpg" border = 0 >
3. Create control users
I created this before I had any problems.
I used the MySQL command line tool, executed the following SQL command.

 
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 '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 <pma_db>.* TO 'pma'@'localhost'; 

4. Modify the config. Inc. PHP file.
Since tracking is not set on the setup screen, the other items in the second picture all turn green after the above processing, but the last item is still red.
So I append to the config. Inc. PHP file myself
The $CFG [' the Servers'] [$I] [' tracking '] = 'pma_tracking';
This row right here.
5. There is a case where the modification to the config. Inc. PHP file does not work
After setting 1 through 3, the Settings for the second image do not immediately turn green when accessing the main screen.
To verify the effect of the config. Inc. PHP file changes, I changed a very important setting in the file, 'host', followed by a few random a's.
Then there was an error accessing phpMyAdmin. And then I'm going to get rid of those a's, and when I go back, everything is green except for the last item, tracking.
Probably because of the browser or apache cache, which I haven't quite figured out yet.


Related articles: