Solution to the problem that the function of the phpMyAdmin link table has not been activated (tested)

Today, phpmyadmin has been configured for the customer, and the "link table addition function is not activated" issue persists. after logging on to phpmyadmin, the "link table addition function is not activated" is displayed at the bottom. To identify the cause, click here ." . Searching for resources from multiple parties and testing finally solved the problem.
In fact, if the installation is correct during installation, the following information will not appear.



For example, if the password is prompted for installation in Linux, the problem will not occur if you enter the password of the Root account!

Phpmyadmin has always encountered the problem that "the chain table attaching function is not activated". after logging on to phpmyadmin, "the chain table attaching function is not activated" is displayed at the bottom. To identify the cause, click here ." . I have never been able to solve this problem until today. it is boring!

If you are careful enough, I believe you can find such a problem in your phpmyadmin and try it on Baidu. there is a solution, I have to say that Baidu is great! My habit is to find a solution, experiment and summarize it, and finally tell the netizens my experience!

My phpmyadmin version is v 3.3.7, which is a relatively new version,

Step 1: Use the Mysql administrator account to log in through phpmyadmin, click "import", and then click "browse" to find a file named create_tables. SQL in the scripts folder under The phpmyadmin folder. You can import it.

Step 2: Open the libraries folder under The phpmyadmin folder and find the file named config. default. php files are opened using text editing tools (Notepad is not recommended, and Dreamweaver is recommended. Modify it.

The modified content is not continuous. please modify it manually. do not copy it.

Before modification:

The code is as follows:

$ Cfg ['servers'] [$ I] ['pmadb'] = ";

$ Cfg ['servers'] [$ I] ['bookmarktable'] = ";

$ Cfg ['servers'] [$ I] ['relation'] = ";

$ Cfg ['servers'] [$ I] ['Table _ info'] = ";

$ Cfg ['servers'] [$ I] ['Table _ coords '] = ";

$ Cfg ['servers'] [$ I] ['PDF _ page'] = ";

$ Cfg ['servers'] [$ I] ['column _ info'] = ";

$ Cfg ['servers'] [$ I] ['History '] = ";

$ Cfg ['servers'] [$ I] ['designer _ coords '] = ";

$ Cfg ['servers'] [$ I] ['tracking'] = ";

Modified content:

The code is as follows:

$ 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 _ page'] = 'PMA _ pdf_pages ';

$ Cfg ['servers'] [$ I] ['column _ info'] = 'PMA _ column_info ';

$ Cfg ['servers'] [$ I] ['History '] = 'PMA _ history ';

$ Cfg ['servers'] [$ I] ['designer _ coords '] = 'PMA _ designer_coords ';

$ Cfg ['servers'] [$ I] ['tracking'] = 'PMA _ tracking ';

Step 3: log out of phpmyadmin and log on again. Success!