mysql 5.7.18 winx64 free installation configuration method

1. Download

2. Decompression

3. Add the path environment variable, and point the path to the bin directory where mysql is located

4. Create a data folder in the main directory

5. Register Windows system services

Create a new my.ini file and copy it to the c:\windows directory. The content is as follows:

[client]
port=3306
default-character-set=utf8
[mysqld] 
# Set to the installation directory of MYSQL basedir=C:\_04Tools\mysql-5.7.18-winx64
# Set to the MYSQL data directory datadir=C:\_04Tools\mysql-5.7.18-winx64\data
port=3306
character_set_server=utf8
sql_mode=NO_ENGINE_SUBSTITUTION,NO_AUTO_CREATE_USER
# Enable query cache explicit_defaults_for_timestamp=true

Open cm, enter the mysql bin directory, and enter the service installation command:

 mysqld -install

If Install/Remove of the Service Denied! appears, go to C:\Window\System32, find CMD.EXE, right-click and choose to run as administrator, then go to the corresponding directory and execute the command, and everything will be OK.

6. Start MySQL service

Order:

net start mysql

If an error occurs, find the .rr file in the data directory to view the specific error information. Remember to clear the contents of the data directory after fixing the error.

If the above command still fails, try mysqld --initilize --user=mysql --datadir=data

Or enable the service via Control Panel --> Administrative Tools --> Services.

7. Change the root password

set password for root@localhost = password('123');

After successfully changing the password, log in: mysql -u root -p, enter password

If an error occurs: mysql access denied for user 'root'@'localhost' (using password: YES), add the following to the last line of the my.ini file:

 skip-grant-tables

After restarting the service, log in again and succeed

The above is the MySQL 5.7.18 winx64 free installation configuration method introduced by the editor. I hope it will be helpful to everyone. If you have any questions, please leave me a message and the editor will reply to you in time. I would also like to thank everyone for their support of the 123WORDPRESS.COM website!