Mysql 5.7.18 winx64 installation-free configuration method, 5.7.18winx64

Mysql 5.7.18 winx64 installation-free configuration method, 5.7.18winx64

1. Download

2. Extract

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

4. Create a data folder in the main directory

5. Register windows Services

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

[Client] port = 3306default-character-set = utf8 [mysqld] # Set to MYSQL installation directory basedir = C: \ _ 04Tools \ mysql-5.7.18-winx64 # Set to mysql data directory datadir = C: \ _ 04Tools \ mysql-5.7.18-winx64 \ dataport = 3306character_set_server = utf8sql_mode = NO_ENGINE_SUBSTITUTION, NO_AUTO_CREATE_USER # enable query cache explicit_defaults_for_timestamp = true

Open cm, go to 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, right-click CMD. EXE, and select "Run as administrator". Then, go to the corresponding directory and execute the command. Everything is OK.

6. Start the MySQL Service

Command:

net start mysql

If an error is reported, find the. rr file in the data directory to view the specific error information. After fixing the error, remember to clear the content in the data directory.

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

You can also use Control Panel> Administrative Tools> Services to enable the Service.

7. Modify the root password

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

After the password is changed, log on to mysql-u root-p and enter the password.

If an error occurs: mysql access denied for user 'root' @ 'localhost' (using password: YES), add

　skip-grant-tables

Log On again after restarting the service.

The above is a free installation and configuration method for mysql 5.7.18 winx64. I hope it will be helpful to 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!