Demo of MySQL5.1 installation-free version

The following articles mainly describe the actual installation of the MySQL installation-free version. We first download the MySQL database and decompress it to D: \ MySQL51, and then D: \ MySQL51 \ bin is added to the related system environment variable Path.

Then you need to configure the MySQL database, change the my-small.ini TO my. ini, other files can also be taken directly to modify the name), edit the file my. ini

 
 

  
  
[client]  
  
  
#password = your_password 
  
  
port = 3306 
  
  
socket = /tmp/MySQL.sock  
  
  
default-character-set = utf8 
  
  
[MySQLd]  
  
  
port = 3306 
  
  
socket = /tmp/MySQL.sock  
  
  
default-character-set = utf8 
  
  
basedir=D:/MySQL51  
  
  
datadir=D:/MySQL51/data  
  
  
default-storage-engine = MyISAM 
 
 

Other configurations in MySQL5.1 installation without installation will not change. The default character encoding for clients and servers is utf8default-character-set = utf8); the MySQL installation directory and database save directory are configured, and the default database engine is MyISAM.

Run CMD to start the command line tool.

Input: MySQLd to start the service. Input MySQLd -- console to view the log output on the console ).

CMS starts the command line tool.

Enter MySQL-u root to log on to the database server. The password is blank by default. You can also set it in the configuration file. If the password is set, enter MySQL-u root-p, the next step is to enter the password. If the database runs on another server, enter MySQL-h ***. ***-u root-p. * **. ** Is the IP address or domain name of the database server.

The above content is an introduction to the installation of the free installation version of MySQL5.1. I hope you will have some gains.