Detailed explanation of the installation tutorial of MySQL5.6.36 under Windows x64 version (picture)

This article mainly introduces the Installation tutorial of MySQL 5.6.36 Windows x64-bit version. It is very good and has reference value. Friends who need it can refer to it

1, Target environment

Windows 7 64-bit

2,Material

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

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

(3) EditPlus (optional)

3, Basic operations

Part of this article The operation needs to be performed as an administrator + command line.

4, step

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

①basedir is the mysql base folder, in the shape of: C:\mysql-5.6.36-winx64

②datadir is the mysq data folder, in the shape of: C:\mysql-5.6.36-winx64\data

(2) Install VC++2010 release package 64-bit release package

(3) Install mysql service

Use the command line (run as administrator) to execute mysqld.exe under the bin folder in the mysql installation folder: mysqld -install

If the machine has not installed mysql database, it will prompt OK, otherwise it will prompt an error that the service already exists. You need to deletethe installed service first.

(4) [Optional] Delete the existing mysql service

sc delete mysql (administrator rights required), and then install the service (step 3)

(5) Start the service

 net start mysql

(Stop the service: net stop mysql)

(6) Set the password of the root user

mysqladmin -u root -p password      （这里的password用来指明管理类型，不是具体要设置的密码）

① Enter the original password first, and if the original password is empty, just press Enter

② and ③Enter the new password

##5, others

Modification of related configurations or operations requires restarting the service (stop and restart) to be effective.

①Allow remote host access

Log in to the mysql database (system database) locally on the server, enter the user table of the mysql library,

add a record, except host is % , other contents are the same as the record with password in this table (including password).

Just stop and start the mysql service.

The above is the detailed content of Detailed explanation of the installation tutorial of MySQL5.6.36 under Windows x64 version (picture). For more information, please follow other related articles on the PHP Chinese website!