Shulou(Shulou.com)06/01 Report--

Question: open phpmyadmin to show that advanced functions have not been fully set up and some functions are not activated. How should I solve this problem?

A total of three steps can be done.

1. Import related files into the database

2. Change the configuration file config.inc.php

3. Give relevant permissions to root users

The detailed process is as follows:

First find the directory where phpMyAdmin is located. There is an examples folder in the phpMyAdmin directory, and there is a create_tables.sql database file in this folder. (if your phpMyAdmin is an older version, it's not an examples folder, it's a script folder.)

After logging in to the database, click Import

Then select the examples folder of the phpMyAdmin directory (the old version is the script folder), select the create_tables.sql file, and click "execute"!

If you can't find the file I said above! It shows that you have the latest version of phpMyAdmin. The latest version suggests searching for create_tables.sql files in the phpMyAdmin directory.

Select Import and click "execute"! The current latest version of phpMyAdmin, the implementation of this step has solved the problem, if it is your old version, you can move on!

After execution, you can find an additional database named "phpMyAdmin" in this database, as shown in the following figure:

We can find the following table in this database. Look at the table name casually and look familiar.

(in the newer version, there are two _ to the right of pma, namely pma__ (the old version is a single _, pma_)

Then we change the parameters in the configuration file (config.inc.php). The old version of phpMyAdmin, the config.inc.php file is under the phpMyAdmin directory, and then the newer version, without this file, a lot of people are fooled instantly, right? If you can't find the config.inc.php file, find config.sample.inc.php, find the config.sample.inc.php file, rename it to config.inc.php, and then modify it.

For the sake of safety, do not use notepad to modify the php file directly, you can edit it in DW, because if you edit the php file directly with notepad, you may be affected by bom! For a detailed case of the impact of bom, take a look at my previous related videos. (of course, 99% of php files can be edited directly with notepad, because novices are not familiar with php code, so when it is recommended that novices modify php files, do not use notepad, use the relevant php editor, otherwise they may be affected by bom. If the php files you edit later are affected by bom, you can use dw to open them and click to clear bom. )

After opening the config.inc.php file, we soon found the following code, see if there is a double slash, if there is / /, this line will not work, we have to remove / / to make it effective. As shown in the picture, 13\\ are to be removed.

Remove the 13 / / characters as shown in the figure below, and find that these names look familiar, such as whether the 'pma__bookmark', in this line of code $cfg [' Servers'] [$I] ['bookmarktable'] =' pma__bookmark';'is the same as one of the tables in the database "phpMyAdmin" (notice the third image above).

At this time, don't forget that the config.inc.php file you modified is copied with config.sample.inc.php, that is, the two files look the same. Now you have modified the config.inc.php file and modified the config.sample.inc.php. Both of them can be modified to be the same as the picture above.

After restarting the database service, it is found that it still prompts "phpmyadmin shows that advanced functions have not been fully set and some functions are not activated." Click to view, as shown in the following figure

After clicking on the link, you will find the following hint

Seeing this kind of hint, it was as if I didn't do anything in front of me, all because of permission!

Okay, then we finally get the permission, and there's no problem at all. how to do it? click here for the user.

Click Edit permissions, as shown below

Pull it below and select the database "phpmyadmin" as shown in the following figure.

Note that it is still on the same page. After the above picture is selected, the scroll bar scrolls up, and then click Select all.

After selecting all, click "execute" on the following figure, and click on the following figure to show that it is a success!

OK, if you restart the service at last, there will be no such prompt.

Usually configure these components may encounter more problems, if you feel bored, it is recommended to use my PHP green integrated environment "PHPWAMP", this software I have integrated PHP versions, related components have been optimized, pure green (integrated VC), put U disk can be used, you can quickly switch between different PHP versions, to meet the requirements of various open source programs for the PHP version. At present, the default integrated PHP versions of PHPWAMP are php5.2 (running the old version of the encryption program perfectly), php5.3, php5.4, php5.5, php5.6, php7.0. The PHP custom feature also provides 700 different php versions for you to switch!

Baidu searches "PHPWAMP" to download the latest version of PHPWAMP (true pure green, supports wayward switching of 700PHP versions)

Lccee teacher video tutorial: edu.51cto.com/lecturer/10514884.html

Other PHPWAMP application articles can be viewed here: https://blog.51cto.com/lccee

Welcome to follow my blog for the latest information, if you have any suggestions, you can trust me privately.

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.