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

This article mainly gives you a brief talk about Linux-MySQL user viewing and authorization. You can check the relevant professional terms on the Internet or find some related books to supplement them. We will not dabble here. Let's go straight to the topic. I hope that Linux-MySQL users can view and authorize this article to bring you some practical help.

Mysql > grant all on. To 'user1'@' source ip address' identified by 'password; # define user1, source ip to log in, all libraries have permissions, or mysql. Specify a library of mysql

Mysql > grant all on. To 'user1'@'%' identified by' password; #% represents all ip addresses

Grant all on. To 'user' identified by 'password'; # grant authorization. All stands for all.

Grant SELECT,UPDATE,INSERT on db1.* to 'user2'@'192.168.133.1' identified by' passwd'; # authorizes permissions. SELECT,UPDATE,INSERT aims at the library of db1. All tables are given to user2. The source ip address is 192.168.133.1.

Grant all on db1.* to 'user3'@'%' identified by' passwd'; # for db1 libraries, where the table gives the user the user3,ip address of all

Show grants; # View the authorization of the current user

Show grants for user2@192.168.133.1; # View the authorization of the specified user. The user uesr2 source ip is 192.168.133.1. The ip address can be increased.

Linux-MySQL user view and authorization will first tell you here, for other related issues you want to know can continue to pay attention to our industry information. Our section will capture some industry news and professional knowledge to share with you every day.

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.