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

1. Download mysql-8.0.17-winx64 on the official website and select Zip file format to download.

2. Extract to the destination path. Here is the root directory of E disk, that is, E:\ mysql8

3. Create a my.ini under the root directory, as follows:

[mysqld] # Port port = 3306#mysql installation directory basedir = E:/mysql8#mysql data storage directory datadir = E:/mysql8/data# maximum number of connections max_connections = 102 "by default the server uses the character set character-set-server = utf8# default storage engine default-storage-engine = INNODB# service unique identification server_id =" whether slow query slow_query_log = "specify slow query log files Path and name slow_query_log_file = E:/amp/mysql8/data/mysql-slow.log#SQL statement running time exceeding this value will be logged long_query_time = 1 error log log-error = E:/mysql8/data/mysql-err.log# enable binlog log log-bin = E:/mysql8/data/mysql-bin#sql mode sql_mode = NO_ENGINE_SUBSTITUTION STRICT_TRANS_TABLES#, pay attention here. The default password verification plug-in for mysql8 has been changed to caching_sha2_password# to be compatible with the previous one. Change back to mysql_native_passworddefault_authentication_plugin = mysql_native_ password [MySQL] default-character-set = UTF8 [client] port = 3306default-character-set = utf8

4. For the administrator to run CMD, first cd\ and then enter E: enter the E disk, and then enter the target bin directory, namely E:\ mysql8\ bin

5. Execute mysqld-initialize-insecure

6. Execute mysqld-install mysql

7. Execute net start mysql, indicating that the Mysql service OK has been started successfully.

8. Command line input:

Mysql-u root-p

You can log in successfully and prompt welcome to the mysql monitor! Indicates that the login is successful

9. Close the current command line and restart cmd.exe

Enter mysqladmin-u root-p password

Enter

When "Enter password:" appears, enter directly. If no password is set, there is no password by default.

Then "New password:" appears. Enter the new password and press enter.

Then "Confirm new password:" appears to confirm the password, and press enter.

After changing the password, the next time you log in is

Type mysql-u root-p, and then enter the set password to log in.

Summary

The above is the mysql-8.0.17-winx64 deployment method introduced by the editor to you. I hope it will be helpful to you. If you have any questions, please leave me a message and the editor will reply to you in time. Thank you very much for your support to the website!

If you think this article is helpful to you, you are welcome to reprint it, please indicate the source, thank you!

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.