Detailed tutorial on installation and configuration of compressed version of MySQL database

1. Download MySQL

Download address:

https://dev.mysql.com/downloads/mysql/
https://dev.mysql.com/downloads/mysql/5.7.html#downloads (MySQL Community Server 5.7.34)

2. Unzip the compressed package

After the download is complete, decompress the compressed package directly.

3. Initialize mysql

Create a new data file and a new my.ini configuration file

Create an empty folder called data under the unzipped mysql directory, and then create a new configuration file called my.ini under D:\Program Files\mysql-8.0.25-winx64. Write the following code in the file:

[mysqld]
#Set the character set used by the server to utf-8
character-set-server=UTF8MB4
#Bind IPv4 address bind-address=0.0.0.0
#Set the mysql port number port = 3306
#Set the installation directory of mysql basedir=F:/mysql-5.7.23
#Set the storage directory of mysql database data datadir=C:/mysql-5.7.23/data
#Maximum number of connections allowed max_connections=2000
#The default storage engine that will be used when creating a new table default-storage-engine=INNODB
#Set the default encoding of mysql and database [mysql]
default-character-set=utf8
[mysql.server]
default-character-set=utf8
#Set the client default character set [client]
default-character-set=utf8

The # sign and the Chinese characters behind it must be deleted. The final effect is as shown below: 

One thing to note here is that if the data file is not empty, an error will be reported: The designated data directory D:\Program Files\mysql-8.0.25-winx64\data\ is unusable. You can remove all files that the server added to it.

Solution: Delete the files in the data folder.

Run cmd as an administrator and enter the bin directory of mysql

4. Install MySQL service

Execute the command: mysqld --install

If you need to uninstall, use the command mysqld --remove

Execute the command: mysqld --initialize --user=root --console

Here I encountered an error:

The reason is that the encoding format in my my.ini file is incorrect. Just modify it according to the error prompts.

Start the mysql service. Use the command: net start mysql

Log in to mysql and execute the command: mysql -uroot -p: The random password just initialized encountered an error:

Change password command: set password = password('new password') Stop service

Use the command: net stop mysql

This is the end of this article about the detailed tutorial on MySQL database installation and configuration. For more relevant MySQL installation and configuration content, please search for previous articles on 123WORDPRESS.COM or continue to browse the related articles below. I hope everyone will support 123WORDPRESS.COM in the future!