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

This article mainly shows you "how to install and configure mysql unzipped version", the content is easy to understand, clear, hope to help you solve your doubts, the following let the editor lead you to study and learn "how to install and configure mysql unzipped version" this article.

1. Go to the official website: d:\ mysql-5.7.21-winx64\ bin

two。 Extract to disk D (personal preference): d:\ mysql-5.7.21-winx64

3. Configure environment variables, path:D:\ mysql-5.7.21-winx64\ bin

4. Check whether the following two configuration paths in the D:\ mysql-5.7.21-winx64\ my-default.ini file are correct

[mysqld]

Basedir=D:\ mysql-5.7.21-winx64

Datadir=D:\ mysql-5.7.21-winx64\ data

Directory where basedir-mysql is located

The directory where datadir-mysql is located\ data (the data directory is not seen in the installation path D:\ mysql-5.7.21-winx64, I created it myself! However, there will be problems with self-creation, which can be found in step 5, so we only need to configure this path, not to create our own data clip)

If you don't have a default.ini file, you can create one yourself and paste the above

5. Install mysql. Run cmd as an administrator, cut to the bin directory of the mysql installation, and execute the installation statement

Enter the command cd D:\ mysql-5.7.21-winx64\ bin to enter the bin root directory of mysql

(note: if this command cannot be executed successfully, execute DRV first, and then execute cd mysql-5.7.21-winx64\ bin after successfully switching directories.)

It's going so well at this point. It's all an illusion! )

In fact, it is because you created the data directory in step 4, and there is no table structure configuration file required for mysql startup. The solution is as follows:

Delete the data directory you created, then execute mysqld-- initialize-insecure under the bin directory of mysql (without setting the root password), and then start it successfully. After executing mysqld-- initialize-insecure, you can see that the data directory is automatically generated under the installation directory and contains a lot of files.

Reboot can start successfully:

6. Check whether you can log in: mysql-u root-p. Because you don't have a password set, you don't need to enter a password to log in for the first time. You can log in by pressing enter directly.

After setting the password, you need to modify the password reference:

ALTER USER @ 'localhost' IDENTIFIED BY'

New password

The PASSWORD EXPIRE NEVER;-- password never expires, but if you remove the NEVER, it will expire.

The above is all the contents of the article "how to install and configure the unzipped version of mysql". Thank you for reading! I believe we all have a certain understanding, hope to share the content to help you, if you want to learn more knowledge, welcome to follow 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.