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

This article shares the installation tutorial of mysql 8.0.12 for your reference. The details are as follows

Install the tutorial environment:

System: Windows8.1

Installation package: mysql-8.0.12-winx64 .zip

1. Go to MySQL official website to download the installation package: https://dev.mysql.com/downloads/mysql/

Choose the right version

2. Unzip the downloaded installation package (mysql-8.0.12-winx64 .zip) to the appropriate path.

(my installation path is: e:\ SQLServer\ MySQL)

3. Create a new configuration file under the installation directory, name it my.ini, and enter the following:

(installation directory and data storage directory need to configure their own directory according to their own installation path)

[mysql] # set mysql client default character set default-character-set=utf8 [mysqld] # set port 3306 port = 330 setting mysql installation directory basedir=E:SQLServer\ MySQL# set mysql database data storage directory datadir=E:SQLServer\ MySQL\ DBData# allow maximum number of connections the character set used by the max_connections=20# server defaults to 8-bit coded latin1 character set character-set-server=utf8# when creating a new table Default storage engine default-storage-engine=INNODB to be used

4. Run the cmd.exe command line tool as an administrator:

5. Go to the MySQL installation directory and the bin directory

Cd / d E:SQLServer\ MySQL\ bin

6. Execute the command to install MySQL

Mysqld install

7. Execute the following command to initialize the data directory (you must execute the command before you can start mysql)

Mysqld-initialize-insecure

8. Execute the following command to start mysql

Net start mysql

9. Execute the following command to log in to mysql. You don't need to enter your password when you log in for the first time. Just enter directly.

Mysql-u root-p

10. After logging in successfully, execute the following command to change the password (newpassword changes the password set by yourself):

Alter user 'root'@'localhost' identified with mysql_native_password by' newpassword'

11. After changing the password, execute the following command to refresh the permissions

Flush privileges

12. At this point, the latest version of MySQL has been installed!

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.