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

This article is about how to install and configure mysql 8.0.11. The editor thinks it is very practical, so share it with you as a reference and follow the editor to have a look.

Installation environment: win7

1. Download the zip installation package:

Download address of MySQL8.0 For Windows zip package: https://dev.mysql.com/downloads/file/?id=476233, you can enter the page without logging in. Then click on the bottom "No thanks, just start my download." You can start downloading.

2. Installation

2.1 extract the zip package to the installation directory

My decompression is at E:\ software\ mysql\ mysql-8.0.11-winx64

Decompressed file directory

2.2 configure environment variables

Add the bin path under the unzipped folder to the variable value, beginning and ending with;

2.3 configure initialized my.ini files

We found that there is no my.ini file in the extracted directory, so you can create it yourself. Add my.ini (create a new text file, change the file type to .ini) under the installation root, and write to the basic configuration:

[mysqld] # set port 3306 port=3306# set mysql installation directory basedir=E:\\ software\\ mysql\\ mysql-8.0.11-winx64 # be sure to use double slash here, 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 in the mysql database is stored: datadir=E:\\ software\\ mysql\\ mysql-8.0.11-winx64\\ Data # here is the same as above # the maximum number of connections allowed 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.

3. Install mysql

During installation, cmd must be run as an administrator, otherwise an error will be reported during installation, which will lead to installation failure

3.1 initialize the database

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

Mysqld-initialize-console

When the execution is complete, the initial default password for the root user is printed, such as:

C:\ Users\ Administrator > cd C:\ Program Files\ MySQL\ binC:\ Program Files\ MySQL\ bin > mysqld-- initialize-- console2018-04-28T15:57:17.087519Z 0 [System] [MY-013169] [Server] C:\ Program Files\ MySQL\ bin\ mysqld.exe (mysqld 8.0.11) initializing of server in progress as process 49842018-04-28T15:57:24.859249Z 5 [Note] [MY-010454] [Server] A temporary password is generated for root@localhost: rI5rvf5x5G E2018-04-28T15:57:27.106660Z 0 [System] [MY-013170] [Server] C:\ Program Files\ MySQL\ bin\ mysqld.exe (mysqld 8.0.11) initializing of server has completedC:\ Program Files\ MySQL\ bin >

Be careful! There is a paragraph in the output of the execution: [Note] [MY-010454] [Server] A temporary password is generated for root@localhost: rI5rvf5x5G,E, where the "rI5rvf5x5G,E" after root@localhost: 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 are cheap, close fast, or don't remember, that's fine. 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.

Reference: https://dev.mysql.com/doc/refman/8.0/en/data-directory-initialization-mysqld.html

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

4. Change the 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 3.1 above, and enter it to log in successfully and enter the MySQL command mode.

Execute the command in MySQL:

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

Change the password, pay attention to the end of the command; be sure to have, this is the syntax of mysql

At this point, the installation and deployment is complete. Officials say the test speed MySQL8 is twice as fast as 5.

You can use the command to view the default installed database:

Show databases

Use mysql

Show tables

Mysql > show databases;+-+ | Database | +-+ | information_schema | | mysql | | performance_schema | | sys | +-+ 4 rows in set (0.01 sec) mysql >

See that the mysql database is initialized by default, where MySQL user information is stored in the user table. We can take a look at the default MySQL user:

Select user,host,authentication_string from mysql.user;mysql > select user,host,authentication_string from mysql.user +-+ | user | host | authentication_string | +-+- -+-- + | mysql.infoschema | localhost | * THISISNOTAVALIDPASSWORDTHATCANBEUSEDHERE | | mysql.session | localhost | * THISISNOTAVALIDPASSWORDTHATCANBEUSEDHERE | | mysql.sys | localhost | * THISISNOTAVALIDPASSWORDTHATCANBEUSEDHERE | | root | localhost | * 27C237A977F4F44D3F551F1A673BE14DFD232961 | +-- -- + 4 rows in set (0.00 sec) mysql >

Administrator root's host is localhost, which means localhost login access only. If you want to allow other ip logins to be open, you need to add a new host. If you want to allow all ip access, you can directly modify it to "%"

Create a user:

CREATE USER 'xxh'@'%' IDENTIFIED WITH mysql_native_password BY' xxh223'

# (Note: mysql8.0 encryption method has been modified)

# check users

Select user, host, plugin, authentication_string from user\ G

Authorize remote database

# authorize all permissions GRANT ALL PRIVILEGES ON. * TO 'xxh'@'%';# authorize basic query and modify permissions, and set GRANT SELECT,INSERT,UPDATE,DELETE,CREATE,DROP,ALTER ON *. * TO' xxh'@'%' as needed

View user permissions

Show grants for 'xxh'@'%'

Example:

Mysql > use mysql;Database changedmysql > CREATE USER 'xxh'@'%' IDENTIFIED WITH mysql_native_password BY' xxh223 encrypted users; # create users (Note: mysql8.0 encryption has been modified) Query OK, 0 rows affected (0.07 sec) mysql >

View password encryption method:

Mysql > select user, host, plugin, authentication_string from user +-+ | user | host | plugin | authentication_string | | +-+ | xxh |% | mysql_native_password | * 70FD6FB4F675E08FF785A754755B5EBA6DA62851 | | mysql | .infoschema | localhost | mysql_native_password | * THISISNOTAVALIDPASSWORDTHATCANBEUSEDHERE | | mysql.session | localhost | mysql_native_password | * THISISNOTAVALIDPASSWORDTHATCANBEUSEDHERE | | mysql.sys | localhost | mysql_native_password | * THISISNOTAVALIDPASSWORDTHATCANBEUSEDHERE | | root | localhost | mysql_native_password | * 27C237A977F4F44D3F551F1A673BE14DFD232961 | + -- + 5 rows in set (0.00 sec) mysql > Thank you for reading! This is the end of the article on "how to install and configure mysql 8.0.11". I hope the above content can be of some help to you, so that you can learn more knowledge. if you think the article is good, you can share it for more people to see!

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.