MySql 5.6.35 winx64 Detailed Installation Tutorial

Content5.6Instructions: The project starts without errors due to database version issues, but errors occur during the database operation process. To maintain database consistency, mysql was re-installed.

If the laptop originally installed other database versions, please uninstall the mysql database cleanly first, see the tutorial at the following website for details, it is not complicated, but requires patience.http://materliu.github.io/all/web/database/mysql/2014/04/24/uninstall-mysql-totaly.cm.html

To prevent the situation where the website cannot be accessed or does not exist, the specific steps are as follows:

1First, delete the MySQL service in Windows services, use the command sc delete mysql

2Uninstall mysql from the Control Panel.

3Clean up the ini files in the MySQL installation directory.

4Clean up the registry:

HKEY_LOCAL_MACHINE\SYSTEM\ControlSet001\Services\Eventlog\Application\MySQL directory deletion 
HKEY_LOCAL_MACHINE\SYSTEM\ControlSet002\Services\Eventlog\Application\MySQL directory deletion
Delete the HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services\Eventlog\Application\MySQL directory (I did not find it when I uninstalled it, skipped it, but still achieved the purpose of complete uninstallation.)

5Some mysql data files must also be deleted cleanly, such as: C:\Documents and Settings\All Users\Application Data\MySQL

Install mysql5.6

(1At the official mysql websitehttps://dev.mysql.com/downloads/mysql/5.6.html#downloads

Download the version that matches your computer system and unzip it to a disk directory.

(2Configure environment variables

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

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

The content of my.ini:

[client]
port=3306
default-character-set=utf88
[mysqld] 
# Set your own MySQL installation directory 
basedir=D:/mysql-5.6.35-winx64
# Set your own MySQL data directory 
datadir=D:/mysql-5.6.35-winx64/data
port=3306
character_set_server=utf88
default-storage-engine=MYISAM
sql_mode=NO_ENGINE_SUBSTITUTION,STRICT_TRANS_TABLES

(4(

mysqld –initialize 
mysqld.exe -install

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

(5Start MySQL service

(

Firstly, make sure that the MySQL service is closed, and the method to close it is:

(6Modify MySQL password

MySQL is default without a password, the username is root.

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

Enter the MySQL installation directory, 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("123456SELECT * FROM user WHERE user='root';
mysql>FLUSH PRIVILEGES; [Note: Do not forget this sentence, otherwise the password change will not take effect]
mysql>QUIT

The above is what the editor introduces to everyone about MySQL 5.6.35 winx64 Detailed installation tutorial, hoping it will be helpful to everyone. If you have any questions, please leave a message, and the editor will reply to everyone in time. Thank you very much for your support of the Yelling Tutorial website!

Statement: The content of this article is from the Internet, and 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 manually edited, and does not assume any relevant legal liability. If you find any content suspected of copyright infringement, please send an email to: notice#oldtoolbag.com (Please replace # with @ when sending an email to report abuse, and provide relevant evidence. Once verified, this site will immediately delete the infringing content.)