Open phpMyAdmin Show advanced features not yet fully set some features not activated

Problem: Teacher, open phpMyAdmin show advanced features not yet fully set some features are not activated, how should I resolve?

650) this.width=650; "src=" Https://s4.51cto.com/wyfs02/M01/8D/76/wKioL1idQ0jgOLVSAABa_QkrZfE407.png "title=" 0.png "alt=" Wkiol1idq0jgolvsaaba_qkrzfe407.png "/>

This is a question that a student asked me a while ago, today I will answer your question in the blog.

Three steps to get it done.

1. Import related files to the database

2. Change the configuration file config.inc.php

3, to the root user-related permissions

The detailed procedure is as follows:

First find PhpMyAdmin directory, in the PhpMyAdmin directory has a examples folder, the folder has a Create_tables.sql database file. (If your phpMyAdmin is an older version, it's not the examples folder, but the script folder)

After logging in to the database, click Import,

650) this.width=650; "Src=" https://s4.51cto.com/wyfs02/M02/8D/79/wKiom1idQWGzY8tGAAB7pkdYsyY657.png-wh_500x0-wm_ 3-wmp_4-s_2958245091.png "title=" 1.png "alt=" Wkiom1idqwgzy8tgaab7pkdysyy657.png-wh_50 "/>

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

After execution can be found on this side of the database, more than a database named "PhpMyAdmin", as shown in:

650) this.width=650; "src=" Https://s4.51cto.com/wyfs02/M00/8D/76/wKioL1idQXiS_I8vAAFk3jnGKhQ959.png "title=" 2.png "alt=" Wkiol1idqxis_i8vaafk3jngkhq959.png "/>

We can find the following table in this database, look at the table name, familiar.

(Compare the new version, the PMA to the right is two _ is pma__ (the old version is a single _,pma_)

650) this.width=650; "src=" Https://s5.51cto.com/wyfs02/M02/8D/76/wKioL1idQZThwTMMAABRVsx8H5g139.png "title=" 3.png "alt=" Wkiol1idqzthwtmmaabrvsx8h5g139.png "/>

Next we change the parameters in the configuration file (config.inc.php). The old version of the phpMyAdmin, config.inc.php file is under the phpMyAdmin directory, and then compare the new version, without this file, a lot of people in a moment to be forced to do it. Cannot find the config.inc.php file then look for config.sample.inc.php, after you find the config.sample.inc.php file, rename it to config.inc.php, and then modify it

For security purposes, do not use Notepad to directly modify the PHP file, you can pull into the DW to edit, because if you directly with Notepad to edit PHP files, you may be affected by the BOM! For a detailed example of the impact of the BOM, you can look at my previous related videos. (Of course, 99% of PHP files with Notepad Direct editing is basically no problem, because the novice is not familiar with PHP code, all suggestions for beginners to modify PHP files, do not use Notepad, with the relevant PHP editor, otherwise it may be affected by the BOM, If you edit the PHP file later by the BOM effect, you can open with the DW, a button to clear the BOM. )

Open the config.inc.php file, soon we find the following code, see double Slash no, there//words, this line is no use, we have to remove//, let it take effect. , to remove 13 \ \

650) this.width=650; "src=" Https://s3.51cto.com/wyfs02/M00/8D/79/wKiom1idQceQziP4AAHG40IHcV8962.png "title=" 4.png "alt=" Wkiom1idqceqzip4aahg40ihcv8962.png "/>

Remove 13//After, find these names familiar, such as this line of code $cfg [' Servers '] [$i] [' bookmarktable '] = ' pma__bookmark '; inside the ' Pma__bookmark ', is not and database " PhpMyAdmin "One of the table names is the same (notice the third picture above).

650) this.width=650; "src=" Https://s1.51cto.com/wyfs02/M00/8D/76/wKioL1idQd3RtqZ8AAEs9_cYbWk880.png "title=" 5.png "alt=" Wkiol1idqd3rtqz8aaes9_cybwk880.png "/>

Now don't forget, You modified the config.inc.php file is copied from the config.sample.inc.php, that is to say that the two files grow the same, now you modify the config.inc.php file, the config.sample.inc.php also modified. All two are modified to be the same as the picture above.

After restarting the database service, it is found that the "phpMyAdmin show advanced features not yet fully set some features are not activated" click to view, as

650) this.width=650; "src=" Https://s1.51cto.com/wyfs02/M01/8D/79/wKiom1idQe2iiRNnAABW0Mgp2jA507.png "title=" 6.png "alt=" Wkiom1idqe2iirnnaabw0mgp2ja507.png "/>

Click the link to find a hint like

650) this.width=650; "Src=" https://s3.51cto.com/wyfs02/M01/8D/76/wKioL1idQfnh9fxxAAFKZ1SXrh8991.png-wh_500x0-wm_ 3-wmp_4-s_2766973046.png "title=" 7.png "alt=" Wkiol1idqfnh9fxxaafkz1sxrh8991.png-wh_50 "/>

See this hint, make the front I seem to have nothing to do, all because of permission!

Okay, so we're going to end up with the right thing.

650) this.width=650; "Src=" https://s2.51cto.com/wyfs02/M01/8D/79/wKiom1idQg_hVgOQAAEqoh2SWKs328.png-wh_500x0-wm_ 3-wmp_4-s_2933488129.png "title=" 8.png "alt=" Wkiom1idqg_hvgoqaaeqoh2swks328.png-wh_50 "/>

Click Edit permissions, such as

650) this.width=650; "src=" Https://s4.51cto.com/wyfs02/M02/8D/79/wKiom1idQh_RjomjAAEp7oQRr8w033.png "title=" 9.png "alt=" Wkiom1idqh_rjomjaaep7oqrr8w033.png "/>

Pull to the following, such as "phpMyAdmin" the database is selected.

650) this.width=650; "src=" Https://s5.51cto.com/wyfs02/M02/8D/76/wKioL1idQjKxR4AaAADYEEpHCdg940.png "title=" 10. PNG "alt=" Wkiol1idqjkxr4aaaadyeephcdg940.png "/>

Note, or in the same page, if selected, scroll bar up, then click Select All

650) this.width=650; "src=" Https://s5.51cto.com/wyfs02/M00/8D/79/wKiom1idQkXQAfMHAAFSjeZDK6k882.png "title=" 11. PNG "alt=" Wkiom1idqkxqafmhaafsjezdk6k882.png "/>

After the selection, such as the point of "execution", the point of execution after the display is successful!

650) this.width=650; "src=" Https://s2.51cto.com/wyfs02/M00/8D/76/wKioL1idQlTRbc_pAAFly4wHHPs620.png "title=" 12. PNG "alt=" Wkiol1idqltrbc_paafly4whhps620.png "/>

OK, finally restart the service, there is no such a hint

Usually you configure these components may also 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 a USB stick can be used, Can quickly switch between different PHP versions, to meet the requirements of the PHP version of the various open source programs. Currently phpwamp default integrated PHP version has php5.2 (perfect running old version encryption program), php5.3, php5.4, php5.5, php5.6, php7.0, where the PHP customization features also 700 different PHP versions are available for you to switch!

Baidu Search "Phpwamp" can download the latest version Phpwamp (True pure green, support 700 PHP version of wayward switch)

Welcome to Lccee Blog to see more blog posts: http://lccee.blog.51cto.com/

51CTO Related articles recommended:

custom settings for any PHP version tutorial: http://lccee.blog.51cto.com/10514884/1886154

PHP Connection MSSQL database case: http://lccee.blog.51cto.com/10514884/1889722

Phpwamp applications on cloud servers: http://lccee.blog.51cto.com/10514884/1887604

Web page encryption and Web page garbled most detailed analysis: http://lccee.blog.51cto.com/10514884/1886461

Virtual Hosting website full video case : http://lccee.blog.51cto.com/10514884/1886460

Force modification of all MySQL database passwords: http://lccee.blog.51cto.com/10514884/1886402

Forced removal of domain name Port number (exclusive feature): http://lccee.blog.51cto.com/10514884/1886424

700 PHP versions at any time switch, symbiosis mode and multi-opening: http://lccee.blog.51cto.com/10514884/1890945

This article is from the "Lccee" blog, make sure to keep this source http://lccee.blog.51cto.com/10514884/1896643

Open phpMyAdmin Show advanced features not yet fully set some features not activated