MySQL 8.0.24 installation and configuration method graphic tutorial

This article shares the installation tutorial of MySQL 8.0.24 for your reference. The specific content is as follows

Download address: Official website

1. Unzip the folder

2. Configure environment variables and add the bin directory under mysql to PATH;

3. Create a new my.ini configuration file in the mysql directory

4. Modify the configuration file

[mysqld]
#Set port 3306 port=3306
#Set the installation directory of mysql basedir=D:\MySQL\mysql-8.0.24\
#Set the storage directory of mysql database data datadir=D:\MySQL\mysql-8.0.24\data\
#Skip password authentication skip-grant-tables 

5. Start CMD in administrator mode , switch the path to the bin directory under mysql, and then enter mysqld -install (install mysql service)

6. Enter mysqld --initialize-insecure --user=mysql to initialize the data file

The data directory will be automatically generated, and there will be some initial databases

7. Enter net start mysql to start the MySQL service and change the password

8. Use the command mysql -u root -p to enter the MySQL management interface (the password can be empty)

This is the first time I get an error. Just restart the service. Note that the password is empty.

9. Change the root password after entering the interface

alter user 'root'@'localhost' identified with mysql_native_password by '123456';

10. Finally, enter flush privileges； to refresh permissions.

11. Finally, go back and comment out the last sentence in the my.ini file.

Restart mysql and it will work normally

net stop mysql
net start mysql

If the connection is successful, it is OK.

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.