Detailed explanation of MySql5.6.35winx64 installation tutorial

This article mainly introduces MySql 5.6.35 winx64 installation detailed tutorial, very Yes, it has reference value. Friends who need it can refer to the following

Description: There is no error in the project startup due to database version problem, but there is an error in the process of operating the database. In order to keep the database consistent, the installation mysql5 is retrieved again. .6 tutorial is not complicated and requires patience.

If the notebook originally installed other database versions, please uninstall the mysql database first to prevent the URL from being inaccessible or non-existent. The specific steps are as follows:

1. First delete the MySQL service in the windows service and use the command sc

delete

mysql2. Uninstall it in the control panel mysql.

3. Clean up the ini file in the mysql installation directory

4. Clean up the registry:

HKEY_LOCAL_MACHINE\SYSTEM\ControlSet001\Services\Eventlog\Application\MySQL 目录删除 
HKEY_LOCAL_MACHINE\SYSTEM\ControlSet002\Services\Eventlog\Application\MySQL 目录删除
HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services\Eventlog\Application\MySQL 目录删除（我卸载的时候没有找到，略过后仍达到完全卸载的目的。）

5. Some mysql data files must also be deleted. For example: C:\Documents and Settings\All Users\Application Data\MySQL

Install mysql5.6

(1) On the mysql official website dev.mysql.com/downloads/mysql/5.6 .html#downloads

Download the version that matches your computer system and extract it to a certain disk directory

(2) Configure the environment

variables

in Add to Path: D:\mysql-5.6.35-winx64/bin;

(3) Create a new my.ini file and copy the my.ini file to the c:/windows directory

# Contents of ##my.ini:

[client]
port=3306
default-character-set=utf8
[mysqld] 
# 设置为自己的MYSQL的安装目录 
basedir=D:/mysql-5.6.35-winx64
# 设置为自己的MYSQL的数据目录 
datadir=D:/mysql-5.6.35-winx64/data
port=3306
character_set_server=utf8
default-storage-engine=MYISAM
sql_mode=NO_ENGINE_SUBSTITUTION,STRICT_TRANS_TABLES

(4) Go to the bin directory under the MySQL decompression directory from the cmd command window and enter the service installation command:

mysqld –initialize 
mysqld.exe -install

After the installation is successful, the Prompt that the service installation is successful.

(5) Start the mysql service

First make sure that the mysql service has been closed. How to close it:

Open Task Manager-Process-right-click mysqld.exe Mouse, close the service.

(6) Modify the mysql password

Mysql has no password by default, the user name is root

win+q Search command prompt, right. Click-Run as administrator

Enter the mysql installation directory. The author's is: D:\mysql-5.6.35-winx64

Enter the command:

cd bin
mysql –uroot
mysql>show databases; 
mysql>use mysql;
mysql>UPDATE user SET password=PASSWORD("123456") WHERE user='root';
mysql>FLUSH PRIVILEGES; 【注意一定不要遗忘这句话，否则密码更改不能生效】
mysql>QUIT

The above is the detailed content of Detailed explanation of MySql5.6.35winx64 installation tutorial. For more information, please follow other related articles on the PHP Chinese website!