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

Today I will talk to you about how to install mysql 8.0.13 decompression version in windows. Many people may not know much about it. In order to let everyone know more, Xiaobian summarized the following contents for everyone. I hope everyone can gain something according to this article.

1.1. Download:

1.2. Configure environment variables:

Name: MYSQL_HOME

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

path: %MYSQL_HOME%\bin;

1.3. Generate data file:

Run cmd as administrator

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

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

Create the data directory under C:\Program Files\Java\mysql-8.0.13-winx64

1.4. Startup Services:

Execute command: net start mysql Start mysql service, if prompt: service name invalid... (The solution follows: Step 1.5);

1.5. Resolve service startup failure (error):

Tip: Invalid service name

Solution:

Execute the command: mysqld -install (do not need my.ini configuration file Note: many online writing needs my.ini configuration file, in fact, do not need my.ini configuration file can also be, I placed my.ini file before, but prompted that the service can not start, delete my.ini after the start successfully)

If the following figure appears, you need to go to the resource manager to finish the mysql process and restart it.

1.6. Login to mysql:

Login mysql:(Because the password was not set before, so the password is blank, do not enter the password, just enter)

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

Enter password: ******

1.7. User password:

mysql> select host,user,authentication_string from mysql.user;

1.8. Set (or modify) root password:

Set (or modify) root password:

mysql> ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY '123456';#'123456', where the content in quotes is the password, you can set Query OK, 1 row affected, 1 warning (0.00 sec)Rows matched: 1 Changed: 1 Warnings: 1mysql> flush privileges; #Effect: equivalent to save, after executing this command, the settings will take effect, if not executed, the previous password remains unchanged Query OK, 0 rows affected (0.01 sec)

1.9. Exit mysql:

mysql> quitBye After reading the above, do you have any further understanding of how to install mysql 8.0.13 unzipped version in windows? If you still want to know more knowledge or related content, please pay attention to the industry information channel, thank you for your support.

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.