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

Mysql service 8.0.14 installation (general), for your reference, the details are as follows

Installation environment: windows

Installation steps:

1. Download the zip installation package

2. Extract the zip installation package

3. Configure environment variables

4. Add a profile

5. Cmd install mysql

6. Change the database password

6.1. Login bypasses database permission verification

Restart the mysql service

6.3. Log in to the database and change the password

7. Log in to the database with a new password

8. Log in to the database using navicate

9. Wrap up the work

1. Download the zip installation package:

MySQL8.0.13 For Windows zip package download address: mysql-8.0.14-winx64.zip, you can enter the page without logging in.

Then click on the bottom "No thanks, just start my download." You can start downloading.

2. Extract the zip installation package:

Local decompression path: d:\ Program Files\ mysql-8.0.13-winx64 (path can be modified)

3. Configure environment variables:

In the system environment variable-PATH, add D:\ Program Files\ mysql-8.0.13-winx64/bin; (the bin directory corresponding to the decompression path, ending with a semicolon)

4. Add a configuration file:

Add a file to the extracted directory: my.ini

The contents are as follows:

Configure paths and ports here

Be sure to pay attention

[mysqld] # set port 3306 port=3306# set mysql installation directory basedir=D:\\ mysql-8.0.14-winx64 # 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.0.14-winx64\\ 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

Note: the data directory does not need to be created. It will be created automatically in the next initialization.

5. Cmd install mysql

Note: cmd must be run as an administrator during installation, otherwise an error will be reported during installation

5.1 initialize the database

Execute the command under the bin directory of the MySQL installation directory: mysqld-- initialize-- console will print the initial default password of the root user after execution is complete, such as:

C:\ Windows\ system32 > cd D:\ Program Files\ mysql-8.0.13-winx64\ binC:\ Windows\ system32 > DVR D:\ Program Files\ mysql-8.0.13-winx64\ bin > mysqld-- initialize-- console2019-01-08T03:28:14.777283Z 0 [System] [Server] D:\ Program Files\ mysql-8.0.13-winx64\ bin\ mysqld.exe (mysqld 8.0.13) initializing of server in progress as process 94602019-01-08T03:28: 14.839683Z 0 [Warning] [MY-013242] [Server]-- character-set-server: 'utf8' is currently an alias for the character set UTF8MB3 But will be an alias for UTF8MB4 in a future release. Please consider using UTF8MB4 in order to be unambiguous.2019-01-08T03:28:30.391333Z 5 [Note] [MY-010454] [Server] A temporary password is generated for root@localhost: > wdD) Jf85:932019-01-08T03:28:47.786591Z 0 [System] [MY-013170] [Server] D:\ Program Files\ mysql-8.0.13-winx64\ bin\ mysqld.exe (mysqld 8.0.13) initializing of server has completedD:\ Program Files\ mysql-8.0.13-winx64\ bin >

Remember root@localhost: > wdD) Jf85:93 (this is the initial password generated by the system, without the first space, and will be used for login later)

5.2 installation Services

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. If you need to install multiple MySQL services on your computer, you can distinguish them with different names, such as mysql5 and mysql8.

If it is already installed, repeat installation is prompted.

5.3 start the service

Start it in two ways:

1. Start the MySQL service net start mysql by command. Stop the service by commanding net stop mysql. Uninstall the MySQL service by sc delete MySQL/mysqld-remove command

/ p >

2. Start the MySQL service through computer management-service

6. Change the database password

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

Mysql-u root-p

At this time, you will be prompted to enter the password, remember the password of the installation in step 1.3 above, and enter it to log in successfully and enter the MySQL command mode.

Before MySQL8.0.4, execute

SET PASSWORD=PASSWORD ('[modified password]')

You can change the password, but starting with MySQL8.0.4, it doesn't work by default. Because before, the password authentication plug-in for MySQL was "mysql_native_password", but now it is "caching_sha2_password".

Because there are many database tools and link packages that do not support "caching_sha2_password", for convenience, I temporarily changed back to the "mysql_native_password" authentication plug-in.

Change the user's password and execute the command in MySQL:

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

Wonderful topic sharing:

Installation tutorials for different versions of mysql

Installation tutorials for each version of mysql5.7

Installation tutorials for each version of mysql5.6

Installation tutorials for each version of mysql8.0

The above is the whole content of this article, I hope it will be helpful to your study, and I also hope that you will support it.

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.