Phpwamp quickly customize MySQL history version to incorporate MySQL database from other integrated environments

I was able to add the MySQL customization feature because a lot of students suggested it to me, so I added this feature,

Next Release preview:

Phpwamp next version will be integrated PHP Packager , you can generate a single EXE file PHP , double-click to browse the site.

In the process of packaging PHP Web site can also choose any PHP version, MySQL version, and Web server, please look forward to the next version of it.

Current Phpwamp support, Nginx, IIS, Apache, support Unlimited add PHP and MySQL version running simultaneously.

Let's start with the current version of Phpwamp How to quickly customize any version of MySQL history

Before explaining the answer to a small question, a user asked me: Phpwamp can I start some services alone? Actually, it's possible.

Maybe you're not paying attention to the "Service Manager" feature, you want to start a service individually, you just need to do it in Service Manager.

650) this.width=650; "src=" Https://s1.51cto.com/wyfs02/M02/A3/9B/wKioL1mk5PXSXm0MAAFfCK3Pbhk700.png "title=" 1.png "alt=" Wkiol1mk5pxsxm0maaffck3pbhk700.png "/>

(Click on the image to view the large HD image)

Start customizing our MySQL version tutorial, open the software, select "Related Settings" and choose "MySQL version"

650) this.width=650; "src=" Https://s5.51cto.com/wyfs02/M00/04/F0/wKiom1mk5uqS3CzVAADDM--yKTA288.png "title=" 2.png "alt=" Wkiom1mk5uqs3czvaaddm--ykta288.png "/>

(Click on the image to view the large HD image)

If you want to switch MySQL version, you can switch directly here, the Mysql5.5, Mysql5.6, Mysql5.7 Three versions are integrated by default.

650) this.width=650; "src=" Https://s1.51cto.com/wyfs02/M01/A3/A4/wKioL1mk6C-z9eJwAABLpBJ_Grc626.png "title=" 3.png "alt=" Wkiol1mk6c-z9ejwaablpbj_grc626.png "/>

Let's add a MySQL version and go to MySQL official to download any MySQL version.

You can also click on the software here to access the MySQL version provided by Phpwamp for download.

650) this.width=650; "src=" Https://s5.51cto.com/wyfs02/M02/04/F5/wKiom1mk6JbzuDZSAABRJWK6PCc241.png "title=" 4.png "alt=" Wkiom1mk6jbzudzsaabrjwk6pcc241.png "/>

I downloaded the latest version of Mysql8,

650) this.width=650; "src=" Https://s5.51cto.com/wyfs02/M01/04/FE/wKiom1mk69rAUVELAAB4htiTjR4288.png "title=" 5.png "alt=" Wkiom1mk69rauvelaab4htitjr4288.png "/>

After the download is complete, we click here to add a new MySQL version to the software

650) this.width=650; "src=" Https://s3.51cto.com/wyfs02/M00/A3/A7/wKioL1mk6VzSt0tfAABRppsWA_s322.png "title=" 6.png "alt=" Wkiol1mk6vzst0tfaabrppswa_s322.png "/>

After clicking the pop-up box, you can define a version name for your newly added database, for example, I define it as Mysql8

650) this.width=650; "src=" Https://s4.51cto.com/wyfs02/M02/04/F9/wKiom1mk6iLAVu6RAAAxFfiW-Bw676.png "title=" 7.png "alt=" Wkiom1mk6ilavu6raaaxffiw-bw676.png "/>

After entering the name of the version you have defined (the name is optional), click the Add button

650) this.width=650; "src=" Https://s5.51cto.com/wyfs02/M01/04/FA/wKiom1mk6oHR8gR6AAAxMskH-i0636.png "title=" 8.png "alt=" Wkiom1mk6ohr8gr6aaaxmskh-i0636.png "/>

After clicking Add, click "Yes" when prompted to open the MySQL version directory,

650) this.width=650; "src=" Https://s5.51cto.com/wyfs02/M01/A3/AB/wKioL1mk6sLxVT3XAABVtnsXtCI184.png "title=" 9.png "alt=" Wkiol1mk6slxvt3xaabvtnsxtci184.png "/>

In the new folder opened, we have just downloaded the compressed package extracted, put in here,

Regardless of whether there are my.ini files, the latter will be automatically generated, of course, the latter is best to modify the configuration according to your needs.

650) this.width=650; "src=" Https://s3.51cto.com/wyfs02/M02/A3/B8/wKioL1mk7rqhA4k7AADwFogV37s571.png "title=" 10. PNG "alt=" Wkiol1mk7rqha4k7aadwfogv37s571.png "/>

(Click on the image to view the large HD image)

You can then see the latest MySQL database version of Mysql8 that we just defined in the MySQL version list.

650) this.width=650; "src=" Https://s4.51cto.com/wyfs02/M02/A3/AC/wKioL1mk6ySAuK3XAAA2PYp3MLo417.png "title=" 11. PNG "alt=" Wkiol1mk6ysauk3xaaa2pyp3mlo417.png "/>

Finally, you can select the latest version of MYSQL8, then click Switch

650) this.width=650; "src=" Https://s3.51cto.com/wyfs02/M01/04/FD/wKiom1mk643w5uhRAABODgMSP0M959.png "title=" 12. PNG "alt=" Wkiom1mk643w5uhraabodgmsp0m959.png "/>

After clicking Switch, the high version of MySQL will prompt initialization, if prompted by the initialization, click "Yes",

650) this.width=650; "src=" Https://s5.51cto.com/wyfs02/M01/05/09/wKiom1mk75aCofTrAAAxiDVB3zE196.png "title=" 13. PNG "alt=" Wkiom1mk75acoftraaaxidvb3ze196.png "/>

Will soon prompt success, the whole process less than a second

650) this.width=650; "src=" Https://s5.51cto.com/wyfs02/M00/05/09/wKiom1mk787gMOvaAAAo9JIj9cA307.png "title=" 14. PNG "alt=" Wkiom1mk787gmovaaaao9jij9ca307.png "/>

After the initialization is successful, select MYSQL8 and click Switch to start normally (some versions do not need to be initialized)

650) this.width=650; "src=" Https://s3.51cto.com/wyfs02/M01/04/FD/wKiom1mk643w5uhRAABODgMSP0M959.png "title=" 12. PNG "alt=" Wkiom1mk643w5uhraabodgmsp0m959.png "/>

Click Switch, prompt to switch success, switch will also start MySQL

650) this.width=650; "src=" Https://s4.51cto.com/wyfs02/M01/05/0A/wKiom1mk8DPwJsP-AAA7gkuuvOE440.png "title=" 15. PNG "alt=" Wkiom1mk8dpwjsp-aaa7gkuuvoe440.png "/>

We went back to the main interface and found that the newly defined MySQL boot was successful and the mouse moved here will show Mysql8 and the current port number 3306

650) this.width=650; "src=" Https://s2.51cto.com/wyfs02/M02/A3/BC/wKioL1mk8L3SgfuoAACTzUZURBk724.png "title=" 16. PNG "alt=" Wkiol1mk8l3sgfuoaactzuzurbk724.png "/>

This time we found that although the newly defined MySQL database started normally, the database password is not known!

At this point, we can change the password you want using the "Force Change Database Password" function of the common tool.

650) this.width=650; "src=" Https://s1.51cto.com/wyfs02/M01/05/33/wKiom1mlAWTixeIAAAFYLplmoIs315.png "title=" 33. PNG "alt=" Wkiom1mlawtixeiaaafylplmois315.png "/>

This is divided into two parts, the above is to modify the current own MySQL password, the following is to modify the other environment

MySQL database password, and we are now going to modify the latest version of MySQL database password currently launched,

So just fill in the above, I entered the password is 168168, after the input is completed click on the changes can be

650) this.width=650; "src=" Https://s2.51cto.com/wyfs02/M00/05/33/wKiom1mlAXWR8E2WAABZrtFbku8539.png "title=" 44. PNG "alt=" Wkiom1mlaxwr8e2waabzrtfbku8539.png "/>

After the password has been modified successfully, click on the Management database in the main interface, or in the Site management list right click the site open can also

650) this.width=650; "src=" Https://s4.51cto.com/wyfs02/M01/05/39/wKiom1mlBJDy_bbVAACo6ZcXvdo821.png "title=" 88. PNG "alt=" Wkiom1mlbjdy_bbvaaco6zcxvdo821.png "/>

Log in to the MySQL database using the built-in phpMyAdmin database management tool and enter the database password you just modified.

650) this.width=650; "src=" Https://s5.51cto.com/wyfs02/M02/A3/E4/wKioL1mlAW3CKa3AAABrTGG0fyk761.png "title=" 55. PNG "alt=" Wkiol1mlaw3cka3aaabrtgg0fyk761.png "/>

Login is successful and you can see that the current MySQL version is up to date as shown in

Note: Each time you switch MySQL version, this interface must clear the browser cache to correctly display the current MySQL version

650) this.width=650; "src=" Https://s1.51cto.com/wyfs02/M01/05/33/wKiom1mlAYyxEKqcAABg0NrMz2k542.png "title=" 66. PNG "alt=" Wkiom1mlayyxekqcaabg0nrmz2k542.png "/>

Off Topic:

Go back to the MySQL folder just now, and if you can't find the menu, "edit the file-mysql each version folder."

For example, we see a new version of the Mysql8 folder generated two new files, one is MySQL configuration, one is the data file

Friendly tips: to be compatible with all systems, the default generated My.ini is a system that can support very small memory and can be adjusted on its own.

Other suggestions: If you are using a different PHP integration Environment , when the server memory is very small, your database may not start,

This can be appropriate to increase the virtual memory or directly with Phpwamp generated My.ini overwrite the database configuration of your original environment.

650) this.width=650; "src=" Https://s5.51cto.com/wyfs02/M01/05/0C/wKiom1mk8TjSt1irAACSx3QX-T0987.png "title=" 17. PNG "alt=" Wkiom1mk8tjst1iraacsx3qx-t0987.png "/>

Other magical features of MySQL customization:

If you used a different integration environment, but now want to switch to Phpwamp, in fact, the transfer is very simple,

Click Switch PHP version, feel free to switch a PHP version belonging to Apache2.4, marked apache2.4 can

These three PHP versions are labeled apache2.4, so feel free to start these three PHP versions and switch to Apache2.4.

650) this.width=650; "src=" Https://s3.51cto.com/wyfs02/M00/05/12/wKiom1mk83mwWeTKAACwnndUSu0273.png "title=" 18. PNG "alt=" Wkiom1mk83mwwetkaacwnndusu0273.png "/>

, as long as the Apache2.4 is shown here, it means that you can use the Apache2.4 site to manage

650) this.width=650; "src=" Https://s1.51cto.com/wyfs02/M01/05/14/wKiom1mk9F_h-HERAACfzYor4hY884.png "title=" 20. PNG "alt=" Wkiom1mk9f_h-heraacfzyor4hy884.png "/>

Switch to Apache2.4 to use Apache2.4 site management, we open Apache2.4 site management

650) this.width=650; "src=" Https://s4.51cto.com/wyfs02/M02/05/13/wKiom1mk9AaxK7BwAAH3PA5WMu0983.png "title=" 19. PNG "alt=" Wkiom1mk9aaxk7bwaah3pa5wmu0983.png "/>

, site management is powerful, add site can arbitrarily specify any PHP version and custom

When we add the site, we just need to set the root directory to your original website source folder can be

650) this.width=650; "src=" Https://s2.51cto.com/wyfs02/M00/A3/C6/wKioL1mk9KDQtjmVAAB0AVsv_-0258.png "title=" 21. PNG "alt=" Wkiol1mk9kdqtjmvaab0avsv_-0258.png "/>

(Click on the image to view the large HD image)

The source of the site has been moved, the turn of the database, the database can be directly SQL export import, if the trouble can be used to customize the MySQL function, the original MySQL database of your environment integrated into the phpwamp inside can, method and the previous I explained the custom MySQL version is the same, Only need to pay attention to set My.ini, if you do not want to modify the original environment My.ini, directly deleted can be, the difference is as follows.

The differences between MySQL databases and custom MySQL that incorporate other integrated environments:

The difference: Most of the steps are the same, just need to my.ini the original integrated environment of the MySQL directory to delete (automatically generated)

Tips: If you do not want to delete the original environment My.ini configuration, only need to modify the My.ini configuration inside the path, the path is correct to start normally.

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

Phpwamp quickly customize MySQL history version to incorporate MySQL database from other integrated environments