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

Editor to share with you how to install the compressed version of mysql5.6.zip format configuration, I believe that most people do not know much about it, so share this article for your reference, I hope you can learn a lot after reading this article, let's go to know it!

MySQL is a relational database management system, developed by MySQL AB Company of Sweden, and currently belongs to the products of Oracle. The installation package given on the official website comes in two formats, one in msi format and the other in zip format. However, many people download the installation package in zip format, but they find that there is no setup.exe installer, so today we introduce the installation tutorial in zip format.

1. First download mysql, go to this website to download, scroll down, and click on the text in the red circle.

MySQL Community Server 5.6.38 appears, flip down

Because my computer 64-bit, so download the second download address, if there are children's shoes do not know whether their computer is 32-bit or 64-bit, you can right-click on my computer "Properties", look at the system type to know how many bits of your computer

After the download is completed, there will be a compressed package in mysql-5.6.38-winx64.zip format. After decompression, put the folder in your favorite location, and then rename the folder to mysql5.6. The path to this tutorial is D:\ learning software\ mysql5.6, and copy the bin path in your mysql5.6, so copy it to D:\ learning software\ mysql5.6\ bin

two。 First configure the environment variable, right-click on my computer, properties "Click Advanced system Settings"

Select the environment variable in the advanced options, double-click path, click New, paste your bin path, and then go all the way to determine.

Then go to the mysql5.6 folder, find the my-default.ini inside, right-open to notepad open, and then save as my.ini, note: do not change the save as encoding to UTF-8, you must use the default code set ANSI, and then save. Re-open the my.ini file in notepad and find these three lines

Modify them to

Basedir = D:\ learning software\ mysql5.6

Datadir = D:\ learning software\ mysql5.6\ data

Port = 3306

You can delete everything else, but you must keep [mysqld], show it as the following picture, and then save it and close it.

3. If you enter cmd as an administrator, you must enter it as an administrator, otherwise you may not have sufficient permissions. Enter d: enter first, and then enter cd. / learning software / mysql5.6/bin, and then enter the bin directory:

Enter mysqld-install at this time, and the installation is successful.

Ps:mysqld-remove is the uninstall mysql.

Then start the service, enter net start mysql, and the service starts successfully

Ps:net stop mysql is to stop service.

4. At this time, mysql has been successfully run, now you can log in to mysql, enter mysql-u root-p (the first login does not have a password, press enter directly), login is successful!

5. How to set the password?

First enter exit to exit the mysql database, and then enter mysqladmin-u root-p password to prompt Enter password: enter directly at this time (because the password is not set at the beginning of mysql), then prompt New password: enter the password you need to set and enter, and then prompt Confirm new password: at this time, please enter the password again and enter, the password has been modified!

Finally, enter mysql-u root-p to log in again.

The above is all the contents of the article "how to install and configure the compressed version of mysql5.6.zip format". 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.