MySQL 8.0.13 decompression version installation graphic tutorial under Windows

This article shares with you the MySQL 8.0.13 installation graphic tutorial for your reference. The specific content is as follows

1.1. Download:

I downloaded the zip package for the 64-bit system:

Download

Download the zip package

1.2. Configure environment variables:

Variable Name: MYSQL_HOME

Variable value: C:\Program Files\Java\mysql-8.0.13-winx64

Add to path: %MYSQL_HOME%\bin;

1.3. Generate data file:

Run cmd as administrator

Enter C:\Program Files\Java\mysql-8.0.13-winx64\bin

Execute the command: mysqld --initialize-insecure --user=mysql

Generate the data directory in the C:\Program Files\Java\mysql-8.0.13-winx64 directory

1.4. Start the service:

Execute the command: net start mysql to start the MySQL service. If it prompts: The service name is invalid... (there is a solution later == step: 1.5);

1.5. Solve the problem of failure to start the service ( error ) :

Tip: The service name is invalid

Solution:

Execute the command: mysqld -install (no my.ini configuration file is required. Note: Many things written on the Internet require a my.ini configuration file. In fact, it is also possible without a my.ini configuration file. I placed a my.ini file before, but it prompted that the service could not be started. After deleting my.ini, it started successfully)

If the following picture appears, you need to end all MySQL processes in the resource manager and restart them.

1.6. Log in to mysql:

Log in to mysql: (Because no password was set before, the password is blank, no need to enter a password, just press Enter)

C:\Program Files\Java\mysql-8.0.13-winx64\bin>mysql -u root -p

Enter password: ******

1.7. Query user password :

Query user password command: mysql> select host,user,authentication_string from mysql.user;

1.8. Set (or modify) the root user password:

Set (or modify) the root user password:

mysql> ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY '123456';
#'123456', the content in quotation marks here is the password, you can set it at will Query OK, 1 row affected, 1 warning (0.00 sec)

Rows matched: 1 Changed: 1 Warnings: 1

mysql> flush privileges; #Function: Equivalent to saving. The setting will take effect only after executing this command. If not executed, the previous password will remain unchanged. Query OK, 0 rows affected (0.01 sec)

1.9. Exit mysql:

mysql> quit
Bye

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.