Shulou(Shulou.com)06/01 Report--

This article mainly tells you how to install and configure winx64 in MySql-5.7.17. You can check the relevant professional terms on the Internet or find some related books to supplement them. We will not dabble here, so let's go straight to the topic. I hope this article on how to install and configure winx64 in MySql-5.7.17 can bring you some practical help.

Download the software

1. Go to the mysql official website, log in to your own Oracle account (if you don't have an account, sign up for one), download Mysql-5.7.17, download address: http://dev.mysql.com/downloads/mysql/

two。 Extract the downloaded file to the specified directory and unzip it in E:\ mysql-5.7.17-winx64

II. Installation process

1. First configure the environment variable path and configure E:\ mysql-5.7.17-winx64\ bin to your own path

Environment variable

MySql_HOME=E:\ mysql-5.7.17-winx64

Path =% MySql_HOME%\ bin

two。 Copy my-default.ini under the decompression path and change the name to my.ini as shown in the following figure

3. Open the file my.ini and add the following:

# # #

[client]

Default-character-set=utf8

[mysqld]

# decompress the directory

Basedir =% MySql_HOME%

# decompress the directory

Datadir =% MySql_HOME%\ data

Port = 3306

Default-character-set=utf8

# # #

4. Then put the my.ini file in the bin directory (I put it in the root directory at first, but I couldn't initialize it later when I initialized the data folder)

Initialize database and configure related information

1. Run the windows command line as an administrator (special reminder: WIN7 and WIN7 and above must be used as an administrator here, otherwise subsequent operations will make errors)

two。 Enter the unzipped directory D:\ mysql-5.7.15-winx64\ bin of mysql (reminder: you need to enter the bin directory here, otherwise errors will occur in subsequent operations)

3. Register for the Mysql service. Run the command: mysqld-- install MySQL

If it appears: "Service successfully installed." Prompt to prove that the mysql service was successfully installed

4. Initialize the data directory

Enter the command: mysqld-- initialize-insecure (generate root users without passwords)

At this point, a data folder with some folders and files will be generated under the mysql folder, which indicates that the initialization is successful.

5. Start the mysql service after initialization

Enter command: net start mysql

If the MYSQL service has been started successfully, it means OK.

6. Set password

Mysqladmin-u root password password

7. Start using mysql

Enter the command: mysql-u root-p

Then enter the password you just set

4. Remove

1. If you are removing the mysql that has been installed and in use, you need to go to the bin directory under the mysql directory in cmd, type net stop mysql on the command line to shut down the MySQL service, and then run the command mysqld-- remove.

This is the end of how to install and configure winx64 in MySql-5.7.17. If you want to know about other related issues, you can continue to follow our industry information. Our section will capture some industry news and professional knowledge to share with you every day.

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.