Shulou(Shulou.com)05/31 Report--

This article will explain in detail how to install mysql in the Win system, the content of the article is of high quality, so the editor will share it for you as a reference. I hope you will have a certain understanding of the relevant knowledge after reading this article.

Mysql download directory

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

After decompression, create a my.ini under the directory where mysql is decompressed, as shown in the example below:

# Database server configuration item [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 item [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 then write the above.

Installation:

Register mysql as a windows system service

1) go to the bin directory under the directory of MySQL decompression from the console:

2) enter the service installation command:

Mysqld install MySQL-- defaults-file= "MySQL extract directory\ my.ini"

When the installation is successful, you will be prompted that the service installation is successful.

# remove service command: mysqld remove

Start the service:

Net start mysql

If you cannot start and execute the following command:

Mysqld-initialize-insecure-user=mysql

Stop the service: stop the mysql before removing the mysql service:

Stop mysql: net stop mysql

Remove Service: mysqld remove

On how to install mysql in the Win system to share here, I hope the above content can be of some help to you, can learn more knowledge. If you think the article is good, you can share it for more people to see.

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.