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

Let's learn how to authorize the user rights of mysql. I believe you will benefit a lot after reading it. The text is not much in essence. I hope you want the user rights of mysql to authorize this short article.

Mysql > grant permission 1, permission 2, … Permission n on database name. Table name to user name @ user address identified by 'connection password'

Permission 1, permission 2,... Permission n represents 14 permissions such as select,insert,update,delete,create,drop,index,alter,grant,references,reload,shutdown,process,file.

When permission 1, permission 2,... Permission n is replaced by all privileges or all, which means that the user is given full permissions.

When the database name. The name of the table is. Instead, it gives the user permission to manipulate all tables in all databases on the cloud server.

The user address can be localhost, ip address, machine name, domain name. You can also use'%'to indicate a connection from any address.

The connection password cannot be empty, otherwise the creation fails.

Mysql > grant select,insert,update,delete,create,drop on vtdc.employee to joe@10.163.225.87 identified by '123'

Assign the user joe from 10.163.225.87 the right to select,insert,update,delete,create,drop and other operations on the employee table of the database vtdc, and set the password to 123.

Mysql > grant all privileges on vtdc.* to joe@10.163.225.87 identified by '123'

Assign user joe from 10.163.225.87 permissions to perform all operations on all tables in the database vtdc, and set the password to 123.

Mysql > grant all privileges on. To joe@10.163.225.87 identified by '123'

The user joe from 10.163.225.87 is assigned permissions to perform all operations on all tables in all databases, and the password is set to 123.

Mysql > grant all privileges on. To joe@localhost identified by '123'

Assign the local user joe permission to perform all operations on all tables in all databases and set the password to 123.

Grant all privileges on. To root@'192.168.0.%' identified by '123456'

Grant all privileges on. To root@'211.149.231.21' identified by 'Uk8F$4_ ^ 6'

Flush privileges

Grant all privileges on. To root@'106.75.28.32' identified by 'yj123456'

Flush privileges

Grant all privileges on. To root@'%' identified by 'dev_pwd'

Flush privileges

After reading this article on how to authorize users of mysql, many readers will want to know more about it. For more industry information, you can follow our industry information section.

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.