Home  >  Article  >  Backend Development  >  Solution to the problem that the additional functions of the linked table in phpMyAdmin have not been activated yet (tested)_PHP Tutorial

Solution to the problem that the additional functions of the linked table in phpMyAdmin have not been activated yet (tested)_PHP Tutorial

WBOY
WBOYOriginal
2016-07-21 15:19:48896browse

Finding resources from multiple sources and testing finally solved the problem, which is recorded here.
In fact, if you install it correctly during installation, the following message will not appear.
Solution to the problem that the additional functions of the linked table in phpMyAdmin have not been activated yet (tested)_PHP Tutorial

Solution to the problem that the additional functions of the linked table in phpMyAdmin have not been activated yet (tested)_PHP Tutorial
If you install under Linux, you will be prompted for a password. When you enter the password of the Root account, this problem will not occur!

phpmyadmin has always had the problem of "Additional functions of the link table have not been activated". After logging in to phpmyadmin, "Additional functions of the link table have not been activated" will be displayed at the bottom. Not activated yet. To find out why, click here. I have never started to solve this problem. Until today, it is probably because of boredom!

If you are careful enough, I believe you can also find such a problem in your phpmyadmin. With the attitude of giving it a try, I went to Baidu and found a solution. I have to say that Baidu is great. ! My habit is to find a solution, then experiment, summarize, and finally tell all 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, then click "Import", then click " Click the "Browse" button and find a file named create_tables.sql in the scripts folder under the phpmyadmin folder. Just import it and it's OK.

Step 2: Open the libraries folder under the phpmyadmin folder, find the file named config.default.php, and use a text editing tool (notepad is not recommended, it is recommended to use tools such as Dreamweaver) Open the file. Modify it.

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

Content before modification:

Copy code 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_pages'] = ”;

$cfg['Servers'] [$i]['column_info'] = ”;

$cfg['Servers'][$i]['history'] = ”;

$cfg['Servers'] [$i]['designer_coords'] = ”;

$cfg['Servers'][$i]['tracking'] = ”;

Modified content :
Copy code 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_pages'] = '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 in again. You're done!

www.bkjia.comtruehttp: //www.bkjia.com/PHPjc/325200.htmlTechArticleFinding resources from multiple sources and testing finally solved the problem, which is recorded here. In fact, if you install it correctly during installation, the following message will not appear. If you install under Linux, you will be prompted for a password...
Statement:
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn