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

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

1. Create my.ini

[mysqld]

# set port 3306

Port=3306

# set the installation directory of mysql

Basedir=D:\ app\ win\ mysql-8.0.11-winx64

# set the storage directory of the data in the mysql database

Datadir=D:\ app\ win\ mysql-8.0.11-winx64\ data

# maximum number of connections allowed

Max_connections=100

# the number of failed connections allowed. This is to prevent someone from trying to attack the database system from the host.

Max_connect_errors=10

# the character set used by the server defaults to UTF8

Character-set-server=utf8

# default storage engine to be used when creating new tables

Default-storage-engine=INNODB

# use "mysql_native_password" plug-in authentication by default

Default_authentication_plugin=mysql_native_password

[mysql]

# set mysql client default character set

Default-character-set=utf8

[client]

# set the default port for mysql clients to connect to the server

Port=3306

Default-character-set=utf8

two。 Execute the command in the bin directory of the MySQL installation directory:

Mysqld-initialize-console

3. Execute the command in the bin directory of the MySQL installation directory:

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 by different names, such as mysql5 and mysql8.

To uninstall, please use sc delete [service name]

4. After the installation is complete, you can start the service of MySQL with the command net start mysql.

5. Log in to mysql

Mysql-u root-p

6. Modify the password

ALTER USER 'root'@'localhost' IDENTIFIED BY' 123'

At this point, the study on "how to install mysql8.0 in win10 environment" 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.