MySQL 8.0.12 installation and configuration graphic tutorial

Recorded the download and installation tutorial of MySQL 8.0.12 and shared it with everyone.

download

Download

As shown

After downloading, unzip the installation package to any folder. I unzip it to drive E.

Install

1. After decompression, there is E:\mysql\mysql-8.0.12-winx64, in which there is an empty folder data. If there is already such a folder, you don’t need to do this step

2. Create a my.ini file, open it with Notepad, and copy the following code into it

[mysqld]
# Set port 3306 port=3306
# Set the installation directory of mysql basedir=E:\\mysql\\mysql-8.0.12-winx64
# Set the storage directory of mysql database data datadir=E:\\mysql\\mysql-8.0.12-winx64\\Data # Note the double \\
# Maximum number of connections allowed max_connections=200
# The number of connection failures allowed. This is to prevent someone from trying to attack the database system from this host max_connect_errors = 10
# The default character set used by the server is UTF8
character-set-server=utf8
# The default storage engine that will be used when creating a new table default-storage-engine=INNODB
# By default, the "mysql_native_password" plug-in is used for authentication. default_authentication_plugin=mysql_native_password
[mysql]
# Set the default character set of the mysql client to default-character-set=utf8
[client]
# Set the default port used by the mysql client to connect to the server port = 3306
default-character-set=utf8

Configuring environment variables

• Right click on computer -> Properties -> Advanced system settings -> Advanced -> Environment variables
• Add a variable named MYSQL_HOME to the system variables.
• Modify the Path variable and add %MYSQL_HOME%\bin at the end
  

Run the cmd command as an administrator and change the path to the bin directory of mysql

• Initialize the database, run the command: mysqld –initialize –console
• Note that the part after the colon in the following sentence is the default password. Write it down. A temporary password is generated for root@localhost : rI5rvf5x5G,E
  

Installation Services

• Run the command: mysqld –install, and mysql is now installed.
• ###Test whether the installation is successful
• Run the mysql command: net start mysql
• Stop mysql command: net stop mysql
  

change password

Suppose you want to change the password to 123456, run cmd, and run the command in the bin directory: mysql -u root -p
Enter the original password input statement:

ALTER USER 'root'@'localhost' IDENTIFIED BY '123456';

Wonderful topic sharing:

MySQL different versions installation tutorial

MySQL 5.7 installation tutorials for various versions

MySQL 5.6 installation tutorials for various versions

mysql8.0 installation tutorials for various versions

The above is the full content of this article. I hope it will be helpful for everyone’s study. I also hope that everyone will support 123WORDPRESS.COM.