Detailed steps to install mysql in Win

This article shares the detailed steps of installing mysql in Win for your reference. The specific contents are as follows

mysql download directory

Select the free installation version "Windows (x86, 64-bit), ZIP Archive"

After decompression, create my.ini in the mysql decompression directory, the content is as follows:

# Database server configuration items [mysqld]
# Database path basedir=D:\\Program Files\\MySQL\\mysql-8.0.12-winx64
#Data path datadir=D:\\Program Files\\MySQL\\data
#Port number port=3306
# Default character set character-set-server=utf8mb4
# Storage engine default-storage-engine=INNODB
 
# Client configuration items [mysql]
#Default character set default-character-set=utf8mb4
 
#Connection client configuration item [client]
default-character-set=utf8mb4

If there is a my-default.ini, change the file to my.ini and write the above content.

Install:

Register MySQL as a Windows system service

1) From the console, go to the bin directory under the MySQL decompression directory:

2) Enter the service installation command:

mysqld install MySQL --defaults-file="MySQL unzip directory\my.ini"

After the installation is successful, a message will pop up saying that the service has been successfully installed.

#Remove service command: mysqld remove

Start the service:

net start mysql

If it fails to start, execute the following command:

mysqld --initialize-insecure --user=mysql

Stop service: Stop mysql first, then remove the mysql service:

Stop mysql: net stop mysql
Remove the service: mysqld remove

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.