MySQL 8.0.15 version installation tutorial connect to Navicat.list

The pitfalls

1. Many tutorials on the Internet write that the file name for configuring environment variables is my.ini, but it cannot be started no matter what. Even after starting it and logging in with the password, there are various errors. Finally, it is changed to my-default.ini, which starts successfully and logs in without any obstacles.

2. Before using MySQL, you need to change the initial password. The instructions for version 8.0.15 are different from others. Since the password is encrypted, you need to use mysql_native_password to downgrade the password. Otherwise, an error 1064 will appear when connecting to Navicat.

Specific installation

1. Download from the official website

This is after the compressed package is unzipped, no installation is required, just enter the terminal command

2. Configure environment variables (you can choose not to configure this step. Configuring environment variables is equivalent to setting a shortcut. When operating with Windows terminal, you don’t need to cd to your path)

My Computer > Right Click > Properties > Advanced System Settings > Advanced > Environment Variables >

Edit directly. Here you only need to add a semicolon after the existing content and enter the path of the mysql you unzipped: mine is c:\mysql\bin, and it must be in the bin file directory

3. Add the my-default.ini file, create a new Notepad and change the file and suffix name. The content is as follows

[mysql]
# Set the default character set of the mysql client to default-character-set=utf8 

[mysqld]
#Set port 3306 port = 3306 
 
# Set the installation directory of MySQL basedir=C:\mysql# Set the storage directory of MySQL database datadatadir=C:\mysql\data
 
# Maximum number of connections allowed max_connections=200
 
# 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
 
[client]
# Set the default port and default character set used by the mysql client to connect to the server port=3306

default-character-set=utf8 

This is a pitfall. A lot of my.ini is written, which leads to a lot of errors later. Pay attention to modifying the paths of basedire and datadir

4.Terminal startup and login

Step 1 cd c:\mysql\bin (change the file path and write your own)

Step 2 mysqld install

c:\mysql\bin>mysqld install
The service already exists!
The current server installed: "C:\Program Files\MySQL\bin\mysqld" MySQL

This error occurs because you may have installed MySQL before and did not completely uninstall it. Use the following command or directly use mysqld remove

c:\mysql\bin>cd c:\

c:\>sc query mysql

SERVICE_NAME: mysql
 TYPE: 10 WIN32_OWN_PROCESS
 STATE : 1 STOPPED
 WIN32_EXIT_CODE : 1067 (0x42b)
 SERVICE_EXIT_CODE : 0 (0x0)
 CHECKPOINT : 0x0
 WAIT_HINT : 0x0

c:\>sc delete mysql
[SC] DeleteService Success c:\>cd c:\mysql\bin

c:\mysql\bin>mysqld install
Service successfully installed.

Service successfully installed. Indicates that mysqld was installed successfully

Step 3: Open the MySQL service

Pitfalls: The service cannot be started because the configuration file name is incorrect

Step 4: Log in to MySQL

After the password appears, press Enter

Pitfalls: 10061 Error

This is because the configuration file name is incorrect.

Step 5: Change the password. You must change the password before using MySQL. If you have nativepassword, you can connect to Navicat. BY 'Enter your own password' Don't forget the semicolon

Connect to Navicat

Connect to mysql

The connection name is entered at random, and the password is the password of the mysql root permission that you modified before. The reason for error 1251 is the password problem, because the mysql password in 8.0.15 is encrypted, and the previous password change statement (for example: alter user 'root'@'localhost' identified by 'password'😉) will cause this problem.

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.