MySql 5.6.35 winx64 installation tutorial, 5.6.35winx64

MySql 5.6.35 winx64 installation tutorial, 5.6.35winx64

Note: There is no error in project startup because of database version problems, but there is an error in database operations. To keep the database consistent, I retrieved the tutorial for installing mysql5.6 again, which is not complex and requires patience.

If the notebook was originally installed with other database versions, please first uninstall mysql database, see the URL: http://materliu.github.io/all/web/database/mysql/2014/04/24/uninstall-mysql-totaly.cm.html

To prevent the website from being accessible or nonexistent, follow these steps:

1. delete the MySQL service from the windows Service and run the SC delete mysql command.

2. uninstall mysql in the control panel.

3. Clear the INI file in the mysql installation directory.

4. Clear the registry:

HKEY_LOCAL_MACHINE \ SYSTEM \ ControlSet001 \ Services \ Eventlog \ Application \ MySQL directory Delete HKEY_LOCAL_MACHINE \ SYSTEM \ ControlSet002 \ Services \ Eventlog \ Application \ MySQL directory Delete HKEY_LOCAL_MACHINE \ SYSTEM \ CurrentControlSet \ Services \ Eventlog \ application \ MySQL directory deleted (not found during uninstallation, .)

5. Some mysql Data Files must also be deleted, for example, C: \ Documents ents and Settings \ All Users \ Application Data \ MySQL.

Install mysql5.6

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

Download the version that meets your computer system and decompress it to a disk directory.

(2) Configure Environment Variables

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

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

My. ini content:

[Client] port = 3306default-character-set = utf8 [mysqld] # Set to your own MYSQL installation directory basedir = D:/mysql-5.6.35-winx64 # Set to your own mysql data directory datadir = D: /mysql-5.6.35-winx64/dataport = 3306character_set_server = utf8default-storage-engine = MYISAMsql_mode = NO_ENGINE_SUBSTITUTION, STRICT_TRANS_TABLES

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

mysqld –initialize mysqld.exe -install

After the installation is successful, a message is displayed, indicating that the service is successfully installed.

(5) Start the mysql Service

First, make sure that the mysql service is closed. The method is as follows:

Right-click Task Manager-process-mysqld.exe and close the service.

(6) change the mysql password

Mysql does not have a password by default, and the user name is root.

Win + q SEARCH command prompt, right click-run as Administrator

Enter the mysql installation directory the author is: D: \ mysql-5.6.35-winx64

Enter the following command:

Cd binmysql-urootmysql> show databases; mysql> use mysql; mysql> UPDATE user SET password = PASSWORD ("123456") WHERE user = 'root'; mysql> flush privileges; [do not forget this sentence, otherwise the password change will not take effect] mysql> QUIT

The above is a detailed tutorial on installing MySql 5.6.35 winx64. I hope it will help you. If you have any questions, please leave a message and I will reply to you in a timely manner. Thank you very much for your support for the help House website!