win10 mysql 5.6.35 winx64 free installation version configuration tutorial

mysql 5.6.35 winx64 free installation version configuration tutorial under win10, the specific contents are as follows

1. Unzip the MySQL compressed package

Unzip the downloaded MySQL compressed package to a 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 path

2. Edit the unzipped file my-default.ini

[client]
port=3306
default-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/data
port=3306
character_set_server=utf8

default-storage-engine=MYISAM
sql_mode=NO_ENGINE_SUBSTITUTION,STRICT_TRANS_TABLES

Register Windows system service

Register MySQL as a Windows system service

The operation is as follows:

1) Right-click the start menu and select "Command Prompt (Administrator)" (must be under administrator privileges)

2) Enter the service installation command:
Enter cmd and 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 will pop up saying that the service has been successfully installed.

If it appears

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 and can be removed.
The command to remove the service is: mysqld remove

5. Start MySQL service

Method 1:

The command to start the service is: net start mysql

Method 2:

Open the management tool service and find the MySQL service.

Start the service by right-clicking and selecting Start or directly clicking Start on the left.
If the service fails when starting, check the imagePath path in the registry editor to see if it is correct. At first, my path was wrong and it kept failing to start. Later, after I modified it, it started 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. Change the root account password

When the installation is just completed, the default password of the root account is empty. At this time, you can change the password to the specified password. For 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 third-party management tools to change passwords. Such as Navicat for MySQL

The above is the full content of this article. I hope it will be helpful for everyone’s study. I also hope that everyone will support 123WORDPRESS.COM.