MySQL 5.6 zip package installation tutorial detailed

Previously, we all used files with the suffix .msi, in other words, a fool-proof installation. However, some versions are not easy to control the installation path, or the database encoding format, and some will install many useless services. However, none of them are as simple and direct as files with the suffix .zip, which can be installed wherever you say.

1. First, download a suitable MySQL version from the official website. There are msi files and zip files. I downloaded two before. One is 5.7.24, but it lacks a folder: data and a file: my-default.ini. Later, I downloaded the zip compressed package of 5.6.42, which has everything.

2. Unzip the zip file you downloaded to a suitable folder. You will find that there is no my.ini file. You need to copy my-default.ini and name it according to this my.ini file.

Note: Do not change the encoding of the Save As file to UTF-8, you must use the default encoding set ANSI

Contents of my.ini:

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

The completed file:

3. Enter cmd as an administrator. You must enter as an administrator, otherwise you will not have enough permissions to enter the unzipped bin directory.

Input: mysqld install is to install the mysql service,

There are other syntaxes: mysql remove is to uninstall mysql, net start mysql is to start the service, and net stop mysql is to stop the service.

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

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

First, enter exit to exit the MySQL database, then enter mysqladmin -u root -p password and press Enter. When prompted, press Enter (because MySQL did not have a password set at the beginning).

Then it prompts New password: Enter the password you need to set and press Enter.

Then it prompts Confirm new password: At this time, you are asked to enter the password again and press Enter. The password has been changed. Use someone else's picture first.

Summarize

The above is a detailed explanation of the MySQL5.6 zip package installation tutorial introduced by the editor. I hope it will be helpful to everyone. If you have any questions, please leave me a message and the editor will reply to you in time. I would also like to thank everyone for their support of the 123WORDPRESS.COM website!