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

This article records the installation tutorial of mysql 8.0.11 under Windows, for your reference, the specific contents are as follows

1, Official download mysql-8.0.11-winx64.zip

2. Extract the download file to the installation directory (current D:\mysql-8.0.11)

3. Create my.ini file (currently placed in D:\mysql-8.0.11 directory)

[mysql] #Set mysql client default character set default-character-set=utf8mb4 [mysqld] default_password_lifetime=0 #Set 3307 port = 3307 #Set installation directory basedir = D: \mysql-8.0.11\ #datadir=D: \mysql-8.0.11\data\ #Max connections allowed max_connections=200 #Character set used by server by default character-set-server=utf8mb4 #Default storage engine when creating new tables @ ault-storage-engine=INNODB #case-insensitive lower_case_table_names=1 #authentication default_authentication_plugin=mysql_native_password

4. Open the win command window as an administrator

5. Create a data directory (the data path is consistent with the data storage directory set in my.ini)

mkdir D:\mysql-8.0.11\data

6. Execute cd command to enter bin folder

7. Execute in the command window

mysqld --defaults-file=D:\mysql-8.0.11\my.ini --initialize --console

8. Command window to install MySQL service (named MySQL-8)

mysqld install MySQL-8

9. Open the service panel and start the service

Log in to MySQL and change your password

mysql -uroot -p -hloalhost -P3307 ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY '******';

Wonderful topic sharing: mysql different versions installation tutorial mysql 5.7 version installation tutorial mysql 5.6 version installation tutorial

The above is all the content of this article, I hope to help everyone's study, but also hope that everyone a lot of support.

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.