Basic installation tutorial of mysql decompression package

Since I have changed to a new computer, all the environments need to be configured on the new computer. Suddenly I realized that I had forgotten the configuration of MySQL, so I searched it again on Baidu.
I wrote an article specifically to record it so that I can remember it.

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 to default-character-set=utf8 
[mysqld]
#Set port 3306 port = 3306 
# Set the installation directory of mysql to basedir=F:\bianyi\mysql-5.6.24-win32
# Set the storage directory of mysql database data datadir=F:\bianyi\mysql-5.6.24-win32\data
# Maximum number of connections allowed max_connections=200
# The default character set used by the server is the 8-bit latin1 character set character-set-server=utf8
# The default storage engine that will be used when creating a new table default-storage-engine=INNODB

3. Installation service

After opening the cmd window as an administrator, switch the directory to the bin directory where you unzipped the file, and then enter vity/SouthEast)

4. Start service login verification

Continue to enter: net start mysql, after the service starts, enter: mysql -uroot -p

5. Change your password

Continue to enter: set password for root@localhost = password('12456');

In this process, the installation service failed because it was not run as an administrator:

The above is the full content of this article. I hope it will be helpful for everyone’s study. I also hope that everyone will support 123WORDPRESS.COM.