because the new and old Project database version number gap is too large. The encoding format is different. The engine is different, so it's only good to install two databases.
Install two MySQL databases this time. The version numbers are each 4.0.18,5.5.36. Both are executable files that are installed directly.
The 5.5.36 version number has been installed on this machine, and a single database is not a problem, and the installation is completed step by step.
There is also a version number also directly click on the next step to install, to note that the place is to find another folder. Example:
5.5.36:d:\mysql5.5.36\4.0.18:d:\mysql4.0.18\
The above experiments were passed in Windows7 and Windows Server 2008. Next is the configuration of the second database 4.0.18 version number:
1 Configuring My.ini
Go to the installation folder. Find several my***.cnf files and find one as the configuration originals.
The MY-MEDIUM.CNF is used here. Rename it to My.ini
Altogether change three places-1: Find for example the following configuration segments:
[Client]
#password =my_password
port=3306
#socket =mysql
Change it to:
[Client]
#password =my_password#5.5.36 version number is already 3306 this port number, so change to 3307
port=3307
#socket =mysql# Set the encoding format to see the project. Whether the default is used. Do not need to be able to directly add the # Shield
Default-character-set=utf8
-2:[MYSQLD]
port=3306
#socket =mysql
Change it to:
[Mysqld]
port=3307
#socket =mysql# The same, does the encoding format change to look at project requirements
#character-set-server=utf8
-3: Key Part # Uncomment the following rows if you move the MySQL distribution to another
# location
#basedir = d:/mysql/
#datadir = d:/mysql/data/
Change it to:
# Uncomment the following rows if you move the MySQL distribution to another
# location
Basedir = d:/mysql4.0.18/
DataDir = d:/mysql4.0.18/data/
2 Installation Services
-1: Go to Bin folder
Open cmd, enter command
D:CD Mysql4.0.18\bin
-2: Install the MySQL service before installing the 5.5.36 version number, using the default MySQL service name: MySQL can open the Task Manager--service. To view this service. The 4.0.18 version number needs to use a new service name, which is named this: mysql4.0.18
After entering the Bin folder, enter the following code to install the service: mysqld--install mysql4.0.18--defaults-file= ' D:\mysql4.0.18\my.ini '
Assume that execution succeeds. The service successfully installed is displayed. This is the time to open Task Manager--services. Be able to see a mysql4.0.18 service.
3 Setting password
-1: Keep in the bin folder, do not leave. Enter the following code: Mysql-u root-p 3307
3307 is the port number, assuming normal, connected to the database.
-2: This time, one more MySQL symbol. Enter the following command. Set Password:
Mysql>use MySQL;
Mysql>update user Set Password=password (' You want to set the password ') where user= ' root ';
Mysql>flush privileges;
mysql>quit;
To turn services on and off:
Method 1: Be able to find this two MySQL service in the Task Manager--Service, right click on the name, show start service and stop service.
Method 2: Open cmd, and use net start ***/net stop * * * To turn the service on and off.
net start MySQL//Turn on mysql5.5.36 service net stop MySQL//shutdown mysql5.5.36 Service
net start mysql4.0.18//Open mysql4.0.18 Service net stop mysql4.0.18//shutdown mysql4.0.18 Service
Windows installation of two MySQL database steps