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

We used to have files with the suffix .msi, in other words, silly installation, but some versions do not easily control the installation path or database encoding format, and some install a lot of useless services, but none of them is as straightforward as the suffix .zip file.

1. First of all, download an appropriate mysql version on the official website, including msi files and zip files. Previously, you downloaded two files, one is 5.7.24, but there is a missing folder: data, and the missing file: my-default.ini file. Later, you downloaded the 5.6.42 zip package, which contains everything.

2. Unzip the zip you downloaded to the appropriate folder, and you will find that there is no my.ini, so you need to copy the my-default.ini and name it according to the my.ini.

Note: do not change the saved as encoding to UTF-8, you must use the default code set ANSI

The content of my.ini:

[mysql] # set mysql client default character set default-character-set=utf8 [mysqld] # set port 3306 port = 3306 # set mysql installation directory basedir=E:\ SoftWare-SQL\ MySQL\ mysql-5.6.42-winx64# set mysql database data storage directory datadir=E:\ SoftWare-SQL\ MySQL\ mysql-5.6.42-winx64\ data# the maximum number of connections allowed by the max_connections=200# server Default 8-bit encoded latin1 character set character-set-server=utf8# the default storage engine default-storage-engine=INNODB that will be used when creating new tables

Completed documents:

3. If you enter cmd as an administrator, you must enter it as an administrator, otherwise you will have insufficient permissions and go outside the decompressed bin directory.

Enter: mysqld install is to install the mysql service

There are other syntax: mysql remove is to uninstall mysql, net start mysql is to start the service, net stop mysql is to stop the service

4. Enter net start mysql: you can start the service. At this time, you can log in to mysql. Enter mysql-u root-p (no password for the first login, press enter directly), and the login is successful! I don't have a screenshot here, so I use someone else's picture.

5. How to set the password after the service is started

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 was not set at the beginning of mysql)

Then prompt New password: enter the password you need to set and enter enter

Then prompt Confirm new password: at this time, I want you to enter your password again and enter. After the password has been modified, use someone else's picture first.

Summary

The above is the detailed explanation of the MySQL5.6 zip package installation tutorial introduced by the editor to you. I hope it will be helpful to you. If you have any questions, please leave me a message and the editor will reply to you in time. Thank you very much for your support to the website!

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.