Mysql green version is enabled in windows, mysqlwindows

Mysql green version is enabled in windows, mysqlwindows

Start mysql Green Edition in windows

1. Download mysql installation-free version such as: mysql-5.7.11-winx64

2, modify the configuration file, my-default.ini name changed to: my. ini, the file parameters in the Configuration:

[Mysqld]

# Skip-grant-tables

# These are commonly set, remove the # and set as required.

Basedir = D: // mysql

Datadir = D: // mysql // data

Port = 3306

# Server_id = .....

Character_set_server = utf8

 

SQL _mode = NO_ENGINE_SUBSTITUTION, STRICT_TRANS_TABLES

3. Register a service name. First, check whether a service name exists. If yes, delete SC delete xxxx first;

If the command does not exist, run the cmd command as an administrator to go to the bin directory and run mysqld-install MySQL-defaults-file = "D: \ mysql \ my. "ini", register the service name, and have the corresponding service in the windows service.

4. check whether there is a data folder in the mysql home directory. You can run mysqld-initialize to create this folder.

5. Execute net start mysql to start the service and net stop mysql to close the service.

6. An error is reported during initial logon. In the my. ini file, add skip-grant-tables to skip permission verification.

7. mysql-u root-p

8. log on successfully. Change the PASSWORD: update mysql. user set authentication_string = PASSWORD ('***') where user = 'root' and host = 'localhost ';

9. Remove skip-grant-tables from my. ini and restart the service.

10. The client fails to connect to 1862 your password. In cmd, mysql-uroot-proot

11. set password = password ('root ');