I still did not manually configure the config file when installing phpMyAdmin, but used its setup function.
The default value is used except for the server name and authentication method.
The server name is entered at will, and the authentication method is changed to HTTP.
In addition, on the PMA database page, click the pen next to the text box and fill in the default value.
(At this time, I have created a control user and entered the user name and password. I will talk about the creation method later)
After saving the settings, enter the root user name and password of MySQL and open the main screen of phpMyAdmin. the following error occurs:
Click here to see the following figure.
Note the following to solve this problem.
1. Delete and copy the config file
This may not be the key to the problem, but I read the official documents after the problem occurs and then handled it.
After saving the settings on the Setup screen, copy./config. Inc. php to the./root directory and 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 to MySQL and create the corresponding table.
Although the additional functions still have problems, you can use phpMyAdmin to manage mysql. Therefore, the create_tables. SQL file is displayed in the following figure.
3. Create a control user
I have created this before the problem occurs.
I used the MySQL command line tool to execute the SQL command.
CopyCode The Code is as follows: 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 ';
Grant select, insert, update, delete on <pma_db>. * To 'pma' @ 'localhost ';
4. Modify the config. Inc. php file.
Because tracking is not set on the Setup screen, the other items in the second figure become green after the above processing, but the last project is still red.
So I append the object to the config. Inc. php file.
$ Cfg ['servers'] [$ I] ['tracking'] = 'pma _ tracking ';
Such a line.
5. The configuration. Inc. php file does not work.
After completing the settings from 1 to 3, when accessing the main screen, the settings of the second image are not immediately green.
To verify whether the modification to the config. Inc. php file is effective, I changed one of the most important settings 'host' in the file and added a few.
Then, an error occurred while accessing phpMyAdmin. Then remove those A and access them again, except for the last tracking, the others are green.
Probably because of browser or Apache cache problems. I haven't figured it out yet.