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

In this issue, the editor will bring you about how to install mysql 8.0.11 in the winx64 system. The article is rich in content and analyzes and describes it from a professional point of view. I hope you can get something after reading this article.

Installation: windows10

1. Download the mysql-8.0.11-winx64.zip package

two。 Decompression

Extract the file to the C:\ develop directory

3. Configuration

Create a data folder storage database under the root directory, create a new my.ini file, and write to the basic configuration:

[mysqld] # set the default port used by the mysql client to connect to the server port=3306# set the installation directory of mysql:\ develop\ mysql-8.0.11-winx64# set the directory where the data of the mysql database is stored datadir=C:\ develop\ mysql-8.0.11-winx64\ data# the character set used by the server defaults to UTF8character-set-server=utf8# and uses the "mysql_native_password" plug-in to authenticate default_authentication by default _ plugin=mysql_native_ password [client] # set mysql client default character set default-character-set=utf8

4. Configure environment variables

Add% MYSQL_HOME%\ bin; to path

5. Installation

Execute mysqld-- initialize-- console from the command line, and when the execution is complete, output the following result:

1 2018-07-23T09:58:22.892095Z 0 [System] [MY-013169] [Server] C:\ develop\ mysql-8.0.11-winx64\ bin\ mysqld.exe (mysqld 8.0.11) initializing of server in progress as process 4376

2 2018-07-23T09:58:26.255083Z 5 [Note] [MY-010454] [Server] A temporary password is generated for root@localhost: G&cs8smtzWaR

3 2018-07-23T09:58:27.503274Z 0 [System] [MY-013170] [Server] C:\ develop\ mysql-8.0.11-winx64\ bin\ mysqld.exe (mysqld 8.0.11) initializing of server has completed

There is the user and the initial password, which you need to remember before you change the password, which you need to use for subsequent logins.

If the shutdown is fast, or if you don't remember, it's okay. Delete the initialized datadir directory, execute the initialization command again, and it will be regenerated.

6. Installation service

Change to the bin directory of the mysql installation directory (required) and execute the command:

Mysqld-- install [service name]

The following service name can be left unwritten, and the default name is mysql. Of course, if you need to install multiple MySQL services on your computer, you can distinguish them with different names, such as mysql5 and mysql8.

After the installation is complete, you can start the MySQL service with the command net start mysql. Stop the service by commanding net stop mysql. Uninstall the MySQL service by sc delete MySQL/mysqld-remove command

7. Modify the password

Enter the command: mysql-u root-p, prompt for the password, fill in the initial password, login is successful.

Enter the command to change the password: alter user 'root'@'localhost' identified with mysql_native_password by' 1qaz2wsx'

Complete password modification

Above is the editor for you to share how to install mysql 8.0.11 in the winx64 system, if you happen to have similar doubts, you might as well refer to the above analysis to understand. If you want to know more about it, you are welcome to follow the industry information channel.

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.