MySQL 5.6.36 Windows x64 bit installation tutorial details, 5.6.36x64

MySQL 5.6.36 Windows x64 bit installation tutorial details, 5.6.36x64

1. Target Environment

Windows 7 64-bit

2. Materials

(1) VC ++ 2010 release package (64-bit)

(2) MySQL 5.6.36 Windows x64 bit version (for non-MSI versions, you can obtain the free version from the official website)

(3) EditPlus (optional)

3. Basic operations

Some operations in this article must be executed as Administrator + command line.

4. Steps

(1) (decompress to the current folder) decompress the installation package, edit the my-default.ini file, mainly 2 items:

① Basedir is the basic mysql folder, such as: C: \ mysql-5.6.36-winx64

2 datadir, that is, mysq data folder, such as: C: \ mysql-5.6.36-winx64 \ data

(2) install the 64-bit release package of the VC ++ 2010 release package

(3) install the mysql Service

Run the "mysqld.exe: mysqld-install

If the machine has not installed the mysql database, an OK message is displayed. Otherwise, an error message is displayed. Delete the installed services first.

(4) [Optional] delete an existing mysql Service

SC delete mysql (administrator privilege required), and then install the service (step 1)

(5) start the service

 net start mysql

(The stop service is: net stop mysql)

(6) set the password of the root user

Mysqladmin-u root-p password (the password here is used to specify the management type, not the specific password to be set)

① Enter the original password, and if the original password is empty, press Enter.

② And ③ enter the new password

5. Others

To modify configurations or operations, you must restart the Service (STOP and restart.

① Allow remote host access

Log on to the mysql database (System Database) locally on the server, enter the user table of the mysql database, and add a new record, except for host %, other contents are the same as the password record (including password) in this table ).

Stop the mysql service.

The above is a detailed tutorial on installing MySQL 5.6.36 Windows x64 bit. I hope it will help you. If you have any questions, please leave a message, the editor will reply to you in a timely manner. Thank you very much for your support for the help House website!