Guida dettagliata di installazione di MySql 5.6.35 winx64

Spiegazione: se non ci sono errori durante l'avvio del progetto a causa del problema della versione del database, ma ci sono errori durante l'operazione del database, per mantenere l'unità del database, è stato nuovamente trovato il tutorial di installazione di mysql5.6, non complicato, ma richiede pazienza.

Se il portatile ha già installato altre versioni di database, è necessario prima disinstallare il database mysql completamente, per dettagli vedere l'indirizzo web:http://materliu.github.io/all/web/database/mysql/2014/04/24/uninstall-mysql-totaly.cm.html

为了防止网址不能访问或者不存在的情况，具体步骤如下：

1.首先在windows服务中将MySQL服务删掉，使用命令 sc delete mysql

2.在控制面板中卸载掉mysql。

3.清理mysql安装目录的ini文件。

4.清理注册表：

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.有一些mysql的数据文件也必须删除干净，比如说：C:\Documents and Settings\All Users\Application Data\MySQL

安装mysql5.6

（1）在mysql官网https://dev.mysql.com/downloads/mysql/5.6.html#downloads

下载符合自己电脑系统的版本，解压到某个磁盘目录。

（2）配置环境变量

在Path中添加 :D:\mysql-5.6.35-winx64/bin;

（3）新建一个my.ini文件并把my.ini文件拷贝到c:/windows目录下

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) Enter the bin directory under the MySQL unzipped directory via the cmd command window, and enter the service installation command:

mysqld –initialize 
mysqld.exe -install

After the installation is successful, it will prompt that the service installation is successful.

(5) Start mysql service

Firstly, make sure that the mysql service is closed, and the method of closing it is:

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

(6) Modify mysql password

mysql is not set with a password by default, the username is root.

Press win+q to search for the command prompt, right-click - run as administrator

Enter the installation directory of mysql, which is: D:\mysql-5.6.35-winx64

Enter command:

cd bin
mysql –uroot
mysql>show databases; 
mysql>use mysql;
mysql>UPDATE user SET password=PASSWORD("123456") WHERE user='root';
mysql>FLUSH PRIVILEGES; [Note: Do not forget this sentence, otherwise the password change cannot take effect]
mysql>QUIT

The above-mentioned is the detailed installation tutorial of MySql 5.6.35 winx64 introduced by the editor, I hope it will be helpful to everyone. If you have any questions, please leave a message, and the editor will reply to everyone in time. I also want to express my heartfelt thanks to everyone for their support of the Nianyue tutorial website!

Declaration: The content of this article is from the Internet, the copyright belongs to the original author, the content is contributed and uploaded by Internet users spontaneously, this website does not own the copyright, has not been edited by humans, nor does it undertake relevant legal liability. If you find any content suspected of copyright infringement, please send an email to: notice#oldtoolbag.com (replace # with @ when sending an email) to report, and provide relevant evidence. Once verified, this site will immediately delete the content suspected of infringement.