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

This article mainly introduces the mysql8.0 window system installation tutorial, hoping to give you some knowledge to supplement and update, if there are other issues to understand, you can continue to pay attention to my updated article in the industry information.

1. Create my.ini file

Specify installation directory and data directory

eg：

[client]

default-character-set=utf8mb4

[mysqld]

lower_case_table_names=1

default-storage-engine=INNODB

character-set-server=utf8mb4

collation-server=utf8mb4_unicode_ci

basedir=E:/developertools/mysql8.0/mysql-8.0.11-winx64

datadir=E:/developertools/mysql8.0/mysql-8.0.11-winx64/data/

port=33068

sql_mode=NO_ENGINE_SUBSTITUTION,STRICT_TRANS_TABLES

default_authentication_plugin=mysql_native_password

[mysql]

default-character-set=utf8mb4

2. Use the administrator command to open the cmd box and enter the bin directory to execute mysqld --initialize --console.

8.0 Version Initial password will appear in [Note] [MY-010454] [Server] A temporary password is generated for root@localhost: F &gzjKrio3!#

mysqld -install MYSQL8.0

4. Start the service net start MYSQL8.0

5. Modify the password mysql -uroot -p (or modify it with navitcat tool)

Note password format:

Because there are currently 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 plugin.

[mysqld]

default_authentication_plugin=mysql_native_password

Delete Services:

sc delete MYSQY8.0

Create database and authorize

CREATE DATABASE srdbjj;

CREATE USER 'ffajj'@'%' IDENTIFIED BY 'sinnrenadmin';

grant all on srdbjj.* to ffajj@'%';

Read the above on mysql8.0 window system installation tutorial, I hope to give you some help in the actual application. Due to the limited space of this article, it is inevitable that there will be deficiencies and needs to be supplemented. If you need more professional answers, you can contact our 24-hour pre-sales service on the official website to help you answer your questions at any time.

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.