The append function of the phpMyAdmin link table has not been activated.

Source: Internet
Author: User
Tags mysql command line

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.

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.