Enable phpmyadmin. The advanced function is not fully set. Some functions are not activated.

Enable phpmyadmin. The advanced function is not fully set. Some functions are not activated.

 

 

Q: How can I solve this problem if I enable phpmyadmin to display advanced functions that have not been fully set and some functions are not activated?

 

 

This is a question that students asked me a while ago. Today I will answer your questions in my blog.

 

 

 

Three steps in total.

1. Import related files to the database

2. Change the configuration file config. inc. php.

3. Grant related permissions to the root user

 

 

 

The detailed process is as follows:

Find the directory where phpMyAdmin is located. There is a examples folder under the phpMyAdmin Directory, which contains a create_tables. SQL database file. (If your phpMyAdmin is an old version, it is not the examples folder, but the script folder)

 

 

After logging on to the database, click Import,

Select the examples folder in the phpMyAdmin directory (the script folder in the old version), select the create_tables. SQL file, and click "execute "!!

 

 

After execution, you can find a database named "phpMyAdmin" in the database, as shown in:

 

 

We can find the following table in this database. Let's just look at the table name.

(To compare the new version, pma has two _ on the right and pma _ (the old version is a single _, pma _)

 

 

Next, we will change the parameters in the configuration file (config. inc. php. The phpMyAdmin and config. inc. php files of the old version are located under the phpMyAdmin directory, and the new version is compared. Without this file, many people will be overwhelmed in an instant, right. Config. Not found. inc. for the PHP file, find config. sample. inc. php, find config. sample. inc. after the PHP file is created, rename it config. inc. php, and then modify it

 

For the sake of security, do not use NotePad to directly modify the PHP file. You can drag it to DW to edit it, because if you directly use NotePad to edit the PHP file, it may be affected by bom! For more information about bom impact, see my previous related videos. (Of course, it is basically no problem to directly edit php files in 99% using notepad, because the new user is unfamiliar with php code. We recommend that you do not use Notepad when modifying php files, use the relevant php editor. Otherwise, the bom may be affected. If your edited php file is affected by the bom, you can use dw to open it and clear the bom with one click .)

Open config. inc. after the PHP file, we quickly found the following code. If there is no double slash (/), this line will no longer work. We need to remove the slash (/) to make it take effect ., Remove 13 \\

 

 

Remove 13 //, as shown in the following figure, for example, this line of code $ cfg ['servers'] [$ I] ['bookmarktable'] = 'pma _ bookmark'; inside 'pma _ bookmark ', is it the same as one of the table names in the database "phpMyAdmin" (note the first third image ).

Don't forget, the config you modified. inc. the PHP file uses config. sample. inc. php copied, that is, the two files are the same. Now you have modified the config. inc. PHP file, set config. sample. inc. php also needs to be modified. Both of them can be modified just like the image above.

 

 

 

After the database service is restarted, the system prompts "phpmyadmin shows that the advanced function has not been fully set and some functions are not activated". Click here, as shown in figure

 

 

Click the link and you will find the prompt as shown in.

 

 

Seeing this kind of prompt, I seem to have done nothing before, because of permissions!

Okay. Now we have finished the permissions. Why? Click here.

 

 

Click Edit permission, as shown in figure

 

 

To the following, for example, select the Database "phpmyadmin.

 

 

Note: It is still in the same page. If it is selected, the scroll bar is rolled up, and then all entries are selected.

 

 

After all the selections are selected, click "execute". After clicking "execute", if it is displayed, It will be successful!

OK. Restart the service and you will not be prompted for this prompt.

 

 

You may encounter more problems when configuring these components on your own. If you are bored, we recommend that you use the "PHPWAMP" in the green PHP integrated environment I have created. This software has been integrated with various PHP versions, the related components have been optimized. They are pure green (integrated with VC) and can be used with USB flash drives. Different PHP versions can be quickly switched to meet the PHP version requirements of various open-source programs. Currently, PHP versions integrated with PHPWAMP by default include php5.2 (which perfectly runs the encryption program of earlier versions), php5.3, php5.4, php5.5, php5.6, and php7.0, the PHP custom function also provides 700 different php versions for you to switch!

 

Baidu searches for "PHPWAMP" to download the latest version of PHPWAMP (truly pure green, supporting 700 PHP version willful switch)

 

 

 

Welcome to Lccee blog for more blog: http://blog.csdn.net/lccee

 

CSDN-related articles:

 

Custom settings any PHP version Tutorial: http://blog.csdn.net/lccee/article/details/53945468

Application of PHPWAMP on ECS: http://blog.csdn.net/lccee/article/details/53945196

The most detailed analysis of Web Page encryption and web page garbled: http://edu.csdn.net/course/detail/2613

Web hosting site construction Video Case: http://edu.csdn.net/course/detail/1846

Force all mysql database passwords to: http://blog.csdn.net/lccee/article/details/53955094

Force remove domain name port (exclusive): http://blog.csdn.net/lccee/article/details/53992304

 

700 PHP version switch at any time, symbiotic mode and multi-open gear: http://blog.csdn.net/lccee/article/details/54311552