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

This article mainly introduces how to install mysql 8.0.27 decompression version of the relevant knowledge, detailed and easy to understand, simple and fast operation, with a certain reference value, I believe we read this mysql 8.0.27 decompression version of how to install configuration articles will be harvested, let's take a look at it.

1. official website to download

https://dev.mysql.com/downloads/mysql/

2. set the environment variable

2.1 Create a new system variable MYSQL_HOME. The value is the path of the decompression package.

2.2 Create new "%MYSQL_HOME%\bin" in system variable "Path"

3. Under MySQL decompression path, create my.ini to configure initialization parameters. Note that the file encoding format cannot be utf-8, ANSI/ASCII can be used, and utf-8 will give an error.

[mysql]; Set the default character set of mysql client default-character-set=utf8 [mysqld]; set port 3306 port = 3306 ; set the installation directory of mysql basedir=D:\MySQL\mysql-8.0.15-winx64; set the storage directory of mysql database data datadir=D:\MySQL\mysql-8.0.15-winx64\data ; max_connections=200 ; the character set used by server defaults to latin1 character set with 8-bit encoding character-set-server=utf8 ; Default storage engine to be used when creating new tables default-storage-engine=INNODB ; Passwords skipped (Note: If passwords are skipped, you may not be able to execute the modify user password sql statement.) skip-grant-tables

4. initialize the database

Enter cmd in the path to the decompression package and enter the command: mysqld --initialize

Initialize the mysql data directory. Under this folder, there is a file ending in.err. Open it and find " A temporary password is generated for root@localhost: ", followed by the generated random password.

5. Registration service

Command: mysqld --install

6. start the service

Command: net start mysql

7. login

Command: mysql -u root -p

Note: You don't need to enter the password, press Enter to skip

ERROR 2003 (HY000): Can't connect to MySQL server on 'localhost:3306' (10061)

Solution:

(1) My.ini file is placed in the bin directory of mysql.

(2) Open cmd command window with administrator privileges and enter sc query mysql

(3) Delete service command: sc delete mysql

(4) Path to bin directory, initialization command: mysqld --initialize --user=mysql --console

(5) Installation service: mysqld --install

(6) Start service: net start mysql

(7) Login service: mysql -u root -p

8. change Password

alter user 'root'@'localhost' IDENTIFIED BY '111111';

If you get an error using navicat: 2059 - authentication plugin 'caching_sha2_password' use the following solution.

Solution:

alter user 'root'@'localhost' IDENTIFIED WITH mysql_native_password by '11111'; About "mysql 8.0.27 decompression version how to install configuration" The content of this article is introduced here, thank you for reading! I believe that everyone has a certain understanding of the knowledge of "mysql 8.0.27 decompression version how to install configuration." If you still want to learn more knowledge, please pay attention to the industry information channel.

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.