As a PHP + MYSQL (other database) programmer, you may need to test in different database versions to meet different needs.
However, when MYSQL is installed normally, only one version of MYSQL database exists in windows. Therefore, you need to change the port and the service name in the system service to OK.
The installation sequence is as follows:
1. Install MYSQL4.0.X first. Because this version does not have the intelligence of MySQL 4.1 and 5.x, you can select the name of the installed Service. Therefore, you have to install MySQL 4.0.X first, or you can use the reverse sequence.
2. Install 4.1 or 5.xin no particular order, because you can select the name of the installed Service.
3. Download PHPMYADMIN and copy the three copies to change the port respectively.
$ Cfg ['servers'] [$ I] ['Port'] = ''; // MySQL port-leave blank for default port
My ports are:
MYSQL4.0.26 port: 3304
MYSQL4.1.20 port: 3305
MYSQL5.1.6 default port: 3306
In this way, you can use PHPMYADMIN to manage different versions of MYSQL.