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

The following content mainly brings you the new version of PHPWAMP rapid customization arbitrary Mysql detailed explanation, the knowledge mentioned here, slightly different from the books, are professional and technical personnel in contact with users, summed up, has a certain experience sharing value, hope to bring help to the majority of readers.

Before I explain, I will answer a small question. Some users asked me: Can PHPWAMP start certain services separately? Actually, it's okay.

Maybe you haven't noticed the "Service Manager" function. If you want to start a service separately, just operate in the "Service Manager"

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

To start customizing our Mysql version tutorial, open the software, select "Related Settings" and then select "Mysql Version"

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

If you want to switch Mysql versions, you can switch directly here. By default, Mysql 5.5, Mysql 5.6 and Mysql 5.7 are integrated.

Let's add a Mysql version, you can download any Mysql version from Mysql official website.

You can also click here to download the Mysql version provided by PHPWAMP.

I downloaded the latest version of Mysql8, as shown in the figure.

Once the download is complete, we click here to add a new version of Mysql to the software

Click to pop up the input box, you can define a version name for your newly added database, for example, I define Mysql8

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

After clicking Add, click Yes to open Mysql version directory after seeing the prompt in the figure below.

In the new folder opened, we just downloaded a good compressed package decompression, into this can be,

Regardless of whether there is a my.ini file, it will be automatically generated later, of course, it is best to modify the configuration according to your needs later.

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

Then you can see Mysql8, the latest Mysql database version that we just defined, in the Mysql version list.

Finally, you can select the latest version of Mysql8 and click Switch.

After clicking switch, the higher version Mysql will prompt initialization. If initialization prompt appears, click "Yes", as shown in the figure.

It'll be a quick success. It'll take less than a second.

After successful initialization, select Mysql8, and then click Switch to start normally.

(Some Mysql versions do not need to be initialized, and the program will automatically judge whether they need to be initialized)

Click switch, prompt switch success, switch will also start Mysql

We return to the main interface and find that the newly defined Mysql is successfully started. Move the mouse here and Mysql8 and the current port number 3306 will be displayed.

At this time we found that although the newly defined Mysql database started normally, the database password was not known!

At this point, we can change the password you want using the "force change database password" function of the common tool.

This is divided into two parts, the above is to modify the current Mysql password, the following is to modify other environments

Mysql database password, and we are now to modify the latest version of Mysql database password currently started,

So just fill in the above can, I entered the password is 168168, after entering the click to modify

After the password is successfully modified, click Manage Database in the main interface, or right-click Site Management List to open the site.

Use the built-in phpmyadmin database management tool to log in Mysql database and enter the database password you just modified.

Log in successfully, you can see that the current Mysql version is the latest, as shown in the following figure

Note: Every time you switch Mysql version, the interface below must clear the browser cache to display the current Mysql version correctly.

About Mysql8 How to use phpmyadmin

Recently, many people commented on the website: When using PHPWAMP to customize Mysql8, changing passwords can also be changed normally, and the latest version of Mysql8 can also be used normally. Navicat can also operate Mysql8 database normally, but it is impossible to log in with phpmyadmin! In fact, encounter this situation we can also add a site in the site management, and then reduce the php version of phpmyadmin program to php5.3, then phpmyadmin can normally log in and operate the latest Mysql8 database, Mysql8 database currently with a high version of PHP will appear unable to log in phenomenon, it is recommended to reduce to php5.3, php version here does not matter, just phpmyadmin php version only. Your own website program can still use a higher version of PHP and a higher version of Mysql, as I said earlier, phpmyadmin and Mysql8 actually have nothing to do with it, not because phpmyadmin can not operate Mysql8, you think it is Mysql8 problem, in fact Mysql8 is completely normal, but also completely usable. (The latest Mysql customization, you must use the latest PHPWAMP version, you can go to the official website to update the PHPWAMP version)

digression:

Go back to the Mysql folder just now. If you can't find it, click the menu,"Edit File-Directory of Mysql Version Folders."

As shown below, we see that the new version Mysql8 folder generates two new files, one is mysql configuration and the other is data file.

Note: In order to be compatible with all systems, my.ini generated by default can support systems with very small memory and can be adjusted by itself.

Other advice: if you are using another php integration environment, your database may not start when the server memory is low,

This can be done by adding virtual memory or overwriting the database configuration of your original environment with my.ini generated by PHPWAMP.

Other benefits of Mysql customization:

If you were using another integration environment and now want to switch to PHPWAMP, the migration is simple,

Click to switch PHP version, free to switch a PHP version belonging to Apache 2.4, as indicated in the figure apache2.4 can be

These three PHP versions are marked as Apache 2.4, so start these three PHP versions at will and switch to Apache 2.4.

As shown in the figure, as long as Apache 2.4 is displayed here, it means that Apache 2.4 site management can be used.

Switch to Apache 2.4 to use Apache 2.4 site management, we open Apache 2.4 site management

As shown in the figure, site management is powerful, add site can be arbitrarily specified any PHP version and custom

When we add a site, just set the root directory to your original site source folder

(Click on the picture to view the high-definition big picture)

Website source code relocation completed, it is the turn of the website database, database can be directly sql export import, if trouble can be used custom Mysql function, the original Mysql database of your environment can be integrated into PHPWAMP inside, the method and I explained before the custom Mysql version is the same, just need to pay attention to setting my.ini on it, if you do not want to modify the original environment my.ini, directly delete it, the difference is as follows.

Differences between MySQL databases that absorb other integrated environments and custom MySQL:

Difference: Most of the steps are the same, just delete my.ini in the MySQL directory of the original integration environment (it will be automatically generated)

Tip: If you do not want to delete the original environment my.ini configuration, just modify the path in the my.ini configuration, and the path will be correct to start normally.

For the above on PHPWAMP new version of rapid customization of any Mysql detailed explanation, if you still need to know more can continue to pay attention to our industry push new, if you need to get professional answers, you can contact the official website pre-sales after-sales, hope this article can bring you a certain knowledge update.

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.