Basic installation tutorial for mysql decompression package and basic mysql decompression tutorial

Basic installation tutorial for mysql decompression package and basic mysql decompression tutorial

Because the new computer is changed, the environment must be configured on the new computer. I suddenly found that the mysql configuration was forgotten, and then Baidu again.
Write an article to record it, so that you can have a long memory.

1. Download the installation package
2. Configure the my. ini file

The configuration information is as follows:

[Mysql] # set the default character set of the mysql client default-character-set = utf8 [mysqld] # set port 3306 = 3306 # set the mysql installation directory basedir = F: \ bianyi \ mysql-5.6.24-win32 # Set the mysql database data storage directory datadir = F: \ bianyi \ mysql-5.6.24-win32 \ data # maximum number of connections max_connections = 200 # the character set used by the server defaults to the 8-bit latin1 character set character-set-server = utf8 # default storage engine default-storage-engine = INNODB

 

3. Install the service

Open the cmd window as an administrator, switch the directory to the bin directory of the decompressed file, and enter export/SouthEast)

4. Start Service login verification

Continue input: net start mysql. After the service is started, enter mysql-uroot-p.

5. Change Password

Continue input: set password for root @ localhost = password ('20140901 ');

During this process, the installation of the service fails because it is not run as an administrator:

The above is all the content of this article. I hope it will be helpful for your learning and support for helping customers.