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

About uninstalling the database of the previous installation, you can refer to this article.

Remember to copy and retain the previous data before uninstalling, the data of the installation version is in the

Uninstall tutorials for all installed versions of mysql5.7, it is recommended that you must restart after uninstalling.

Catalogue

1. First go to the official website to download the download ​ of the MySQL clicked.

two。 Configure the file of the initialized my.ini file

3. Initialize MySQL

4. Install MySQL service + start MySQL service

5. Connect MySQL + change password

1. First go to the official website to download the MySQL you clicked.

two。 Decompress after download

2.1 configure files for initialized my.ini files

There is no my.ini file in the extracted directory. You can create the my.ini added under the installation root directory (create a new text file and change the file type to .ini) and write to the basic configuration:

[mysqld] # set port 3306 port=3306# set mysql installation directory basedir=C:\ Program Files\ MySQL# set the data storage directory of mysql database datadir=C:\ Program Files\ MySQL\ Data# allow the maximum number of connections max_connections=200# allows the number of connections to fail. The character set used by the max_connect_errors=10# server defaults to the default storage engine default-storage-engine=INNODB# that utf8mb4character-set-server=utf8mb4# will use when creating new tables using the "mysql_native_password" plug-in authentication # mysql_native_passworddefault_authentication_plugin=mysql_native_ password [MySQL] # setting the mysql client default character set default-character-set=utf8mb4 [client] # setting the default port port=3306default-character-set=utf8mb4 when the mysql client connects to the server

2.2. Create a new MySQL folder in C:\ Program Files\ (delete the previous one if any)

Copy all the directories and files into C:\ Program Files\ MySQL. Originally, there is no data folder. Create a new Data folder.

3. Initialize MySQL

To avoid errors during installation, we try to run CMD as an administrator as far as possible, otherwise an error will be reported during installation, which will lead to installation failure.

After opening it, enter the bin directory of mysql

Execute the command under the bin directory under the MySQL directory:

Mysqld-initialize-console

Remember the password is: the following string, be sure to copy and save!

4. Install MySQL service + start MySQL service

Install the mysql service

Execute the following command:

Mysqld-install

If this happens,

It means that mysql's service is still deleting it.

Sc decelte mysql

Then perform the above installation service

After the service is installed successfully, use the command net start mysql to start the service of MySQL

5. Connect MySQL + change password

Make a database connection under the bin directory of mysql mysql-u root-p

Then enter the password (the one that was generated by default) and enter.

Modify the password

ALTER USER 'root'@'localhost' IDENTIFIED BY' New password

Connect with the sqlyong tool:

Conclusion: these are the detailed tutorials for installing the recently released 8.0.18 stable version. In fact, I took a look at a boss's 8.0.16 installation tutorial and refactored (modified) on him. I am still very grateful for his blog. I hope this blog can help you.

Wonderful topic sharing:

Installation tutorials for different versions of mysql

Installation tutorials for each version of mysql5.7

Installation tutorials for each version of mysql5.6

Installation tutorials for each version of mysql8.0

The above is the whole content of this article, I hope it will be helpful to your study, and I also hope that you will support it.

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.