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

This article mainly introduces the "detailed installation tutorial of MySQL8.0". In daily operation, I believe many people have doubts about the detailed installation tutorial of MySQL8.0. The editor consulted all kinds of materials and sorted out simple and easy-to-use methods of operation. I hope it will be helpful to answer the doubts of "detailed installation tutorial of MySQL8.0". Next, please follow the editor to study!

Download the MySQL installation package and unpack the D disk.

This data directory is generated later.

Configure environment variables

Configure the my.ini file

Create a new my.ini file

And then write the configuration in it.

[mysqld] # set port 3306 port=3306# set mysql installation directory basedir=E:D:\\ mysql-8 # remember to use double slash\\, single slash I will make mistakes here, but look at other people's tutorials, there are plenty of single slashes. Try it yourself # set the directory where the data of the mysql database is stored datadir=D:\\ mysql-8\\ Data # here is the same as above # maximum number of connections max_connections=200# allows the number of connection failures. This is to prevent anyone from attempting to attack the character set used by the max_connect_errors=10# server of the database system from this host. By default, the default storage engine default-storage-engine=INNODB# that UTF8character-set-server=utf8# will use when creating a new table uses the "mysql_native_password" plug-in authentication default_authentication_plugin=mysql_native_ password [MySQL] # to set the mysql client default character set default-character-set=utf8 [client] # setting. Set the port port=3306default-character-set=utf8 used by default when the mysql client connects to the server

Generate data directory

Open cmd as an administrator

Cd to bin directory execution

Mysqld-initialize-console

Then there will be a data directory

Get the default password

Where root@localhost: the "rI5rvf5x5G,E" after it is the initial password (without the first space). You need to remember this password before you change it, and you need to use it for subsequent logins.

If you accidentally close quickly, or don't remember, that's okay, delete the initialized datadir directory, execute the initialization command again, and it will be regenerated. Of course, you can also use security tools to force you to change your password, and you can do whatever you want.

2019-07-31T03:42:04.587829Z 0 [System] [MY-013169] [Server] D:\ mysql-8\ bin\ mysqld.exe (mysqld 8.0.11) initializing of server in progress as process 86642019-07-31T03:42:04.587940Z 0 [ERROR] [MY-010338] [Server] Can't find error-message file'E:\ D:\ mysql-8\ share\ errmsg.sys'. Check error-message file location and 'lc-messages-dir' configuration directive.2019-07-31T03:42:08.360074Z 5 [Note] [MY-010454] [Server] A temporary password is generated for root@localhost: -) Yh+Lgk:1Fx2019-07-31T03:42:09.750256Z 0 [System] [MY-013170] [Server] D:\ mysql-8\ bin\ mysqld.exe (mysqld 8.0.11) initializing of server has completed

Installation service

Execute a command

Mysqld-install 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

Start MySQL and connect

The password here is the default password. We need to change it.

Modify the password

You need to log in with the previous default password before you can change the password directly

Command

ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY' root'

At this point, the study on the "detailed installation tutorial of MySQL8.0" is over. I hope to be able to solve your doubts. The collocation of theory and practice can better help you learn, go and try it! If you want to continue to learn more related knowledge, please continue to follow the website, the editor will continue to work hard to bring you more practical articles!

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.