Make your WINDOWS support MYSQL4, MYSQL4.1, and MYSQL5X at the same time

Source: Internet
Author: User
Tags windows support
Let your WINDOWS support MYSQL4, MYSQL4.1, and MYSQL5X as a PHP + MYSQL (other databases) programmer, you may want to meet different needs, however, tests must be performed in different database versions.
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.








Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.