Shulou(Shulou.com)06/01 Report--

As follows:

The main execution of authorization commands:

Two ways

1. Allow any host to connect to the local server with user bd and password bdpw

Mysql > GRANT ALL PRIVILEGES ON *. * TO 'bd'@'%' IDENTIFIED Y' bdpw' WITH GRANT OPTION;mysql > flush privileges

two。 Allow specific IP addresses to connect to the local server with user bd and password bdpw

Mysql > GRANT ALL PRIVILEGES ON *. * TO 'bd'@'172.16.4.198' DENTIFIED BY' bdpw' WITH GRANT OPTION; mysql > flush privileges

Note:

1. Enter your password in Command Line Client or enter the command line interface of Nivacat

two。 Input: use mysql

3. Query host input: select user,host from user

If there is a host value of%, execute the authorization statement directly; if not, perform step 4

4. Create host

If there is no host value of "%", select an open user (bd) and execute

Mysql > update user set host='%' where user='bd'; mysql > flush privileges

5. Authorized user *. * indicates that all permissions are authorized

Mysql > GRANT ALL PRIVILEGES ON *. * TO 'bd'@'%' IDENTIFIED BY' bdpw' WITH GRANT OPTION; mysql > flush privileges

The above mysql open access to the public network method is the editor to share with you all the content, I hope to give you a reference, but also hope that you support more.

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.