MySQL5 Green Edition windows installation experience summary

Do you have a headache for installing MySQL5 in green windows? If this is the case, the following articles will provide you with corresponding solutions. The following articles mainly describe how to install MySQL 5 Green Edition windows, the following is a detailed description of the relevant content.

1. Download MySQL

Ii. Installation Process

1. Decompress mysql-noinstall-5.0.45-win32.zip to a directory.

Assume MYSQL_HOME = D: \ Dev \ mysql-5.0.45

2. Compile the mysql running configuration file my. ini.

 
 

  
  
my.ini   
  
  
[mysqld]   
 
 

MySQL5; set the installation directory of mysql

 
 

  
  
basedir=$MYSQL_HOME  
 
 

Set the data storage directory of the mysql database, which must be data or \ xxx \ data

 
 

  
  
datadir=$MYSQL_HOME\data  
 
 

Set the character set of the mysql server

 
 

  
  
default-character-set=utf8   
  
  
[client]  
 
 

Set the character set of the mysql client

 
 

  
  
default-character-set=gbk  
 
 

3. Install the mysql Service

Enter the directory E: \ myserver \ MS-DOS \ bin from the mysql-5.0.37-win32 window and run the following command:

 
 

  
  
mysqld --install MySQL5 --defaults-file=:\Dev\mysql-5.0.45\my.ini  
 
 

4. Start the mysql database

In the above command window, enter the command: net start MySQL5

In this way, the mysql service is started.

5. delete a service

Run mysqld -- remove MySQL5.