Win10 mysql 5.6.35 winx64 installation-free configuration tutorial, win10winx64

Win10 mysql 5.6.35 winx64 installation-free configuration tutorial, win10winx64

Mysql 5.6.35 winx64 installation-free configuration tutorial in win10. The specific content is as follows:

1. decompress the MySQL package

Decompress the downloaded MySQL package to the custom directory. I put it in C: \ software \ mysql-5.6.35-winx64 \ mysql_master

Add Environment Variables

Configure the MySQL path to the path

2. Edit the extracted file my-default.ini

[Client] port = 3306default-character-set = utf8 [mysqld] # Set MySQL directory basedir = C:/software/mysql-5.6.35-winx64/mysql_master # Set MySQL Data datadir = C: /software/mysql-5.6.35-winx64/mysql_master/dataport = 3306character_set_server = utf8default-storage-engine = MYISAMsql_mode = NO_ENGINE_SUBSTITUTION, STRICT_TRANS_TABLES

Register windows Services

Register mysql as a windows system service

The procedure is as follows:

1) Right-click the Start menu and choose "command prompt (Administrator)" (must be under the administrator privilege)

2) enter the service installation command:
Go to cmd, enter the mysql bin directory, and run

Mysqld install MySQL -- defaults-file = "C: \ software \ mysql-5.6.35-winx64 \ mysql_master \ my-default.ini"

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

If

The service already exists!
The current server installed: "C: \ software \ mysql-5.6.35-winx64 \ mysql_master \ bin \ mysqld"-defaults-file = "C: \ software \ mysql-5.6.35-winx64 \ mysql \ master \ my-default.ini" MySQL
Indicates that the service has been registered. Remove the service.
Command: mysqld remove

5. Start the MySQL Service

Method 1:

Run the following command to start the service: net start mysql.

Method 2:

Open the management tools service and find the MySQL service.

Right-click Start or click Start on the left to start the service.
If the service fails to be started, check whether the imagePath path is correct in the registration editor. At the beginning, my path is incorrect and the startup fails. After modification, the system starts successfully.

"C: \ software \ mysql-5.6.35-winx64 \ mysql_master \ bin \ mysqld" -- defaults-file = "C: \ software \ mysql-5.6.35-winx64 \ mysql_master \ my-default.ini" MySQL3306

6. Modify the password of the root account

When the installation is complete, the default password of the root account is blank. You can change the password to the specified password. Example: 123456

Method 1:

c:>mysql –uroot mysql>show databases; mysql>use mysql; mysql>UPDATE user SET password=PASSWORD(“123456”) WHERE user='root'; mysql>FLUSH PRIVILEGES; mysql>QUIT 

Method 2:

Use a third-party management tool to change the password. For example, Navicatfor MySQL

The above is all the content of this article. I hope it will be helpful for your learning and support for helping customers.