MySQL free installation version configuration tutorial

This article shares the MySQL free installation configuration tutorial for your reference. The specific content is as follows

1. Download the MySQL installation-free version compressed package and decompress it to a custom directory, such as: D:\program0\mysql (the following takes this directory as an example)

2. Modify the my.ini file (maybe my-default.ini, manually modify it to my.ini);
Items that need to be configured:

basedir =D:\program0\mysql
datadir =D:\program0\mysql\data

#If you customize this directory, you must move all files in this directory to the new customized directory

port = 3306
server_id =10

3. Configure the default encoding for the newly created data path:
Also in the my.ini file,
Add character_set_server = gbk under [mysqld]

4. Add environment variables

Create a new variable MYSQL_HOME
Enter the variable name: MYSQL_HOME
Enter variable value: D:\program0\mysql
2) Add Path

Click the Edit button
Add variable values ​​in Variable Values:
`%MYSQL_HOME%\bin`
Note that you should add this variable after the original variable value, separated by ;. You cannot delete the original variable value.

5. Register mysql service:
1) From the console, go to the bin directory under the MySQL decompression directory (D:\program0\mysql\bin):
2) Enter the service installation command:

mysqld install mysql

#If `Install/Remove of the Service Denied` appears, select "Open as Administrator" when opening the cmd.exe program, and the same when starting the service.
#After successful installation, the service will be prompted to be successfully installed.
#Remove service command: `mysqld remove`

6. Start the mysql service: cmd enter the console

net start mysql

7. Close the mysql service: cmd enter the console

net stop mysql

8. Configure the root user password:

cmd: mysql -uroot
  mysql< use mysql;
  mysql< delete from user;
  mysql< grant all on *.* to root@'%' identified by "root" with grant option;
  mysql< flush privileges;
  mysql< quit;

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.