How to install the green version of MySQL Community Server 5.7.16 and implement remote login

1. Download MySQL Community Server 5.7.16 and install it

2. Go to the bin directory of the MySQL installation directory, enter cmd in the file address bar and press Enter

3. Enter the command: mysqld --initialize-insecure --console

4. Enter the command: mysqld -install

5. mysql -u root--skip-password

6.ALTER USER 'root'@'localhost'IDENTIFIEDBY '123456';

7.\quit

8. mysql -h localhost -uroot -p

Installation Complete

Authorize remote login

Log in as an administrator

Execute command: grant all PRIVILEGES on *.* to zhanghao@'%' identified by '123456';

Refresh takes effect: flush privileges;

Command Explanation:

all PRIVILEGES means granting all permissions to the specified user. This can also be replaced by granting a specific permission, for example:

select,insert,update,delete,create,drop , etc. Specific permissions are separated by half-angle commas.

*.* indicates which table the above permissions apply to. The first * refers to the database, and the following * refers to all tables. For all tables in a certain database, the authorization is "database name.*", and for a certain table in a certain database, the authorization is "database name.table name".

zhanghao indicates which user you want to authorize. This user can be an existing user or a non-existent user.

Summarize

The above is the method that I introduced to you to install the green version of MySQL Community Server 5.7.16 and realize remote login. I hope it will be helpful to you. If you have any questions, please leave me a message and I will reply to you in time. I would also like to thank everyone for their support of the 123WORDPRESS.COM website!