mysql grant privileges

最新推荐文章于 2024-04-01 10:06:21 发布

原创最新推荐文章于 2024-04-01 10:06:21 发布 · 205 阅读

0 ·

CC 4.0 BY-SA版权

文章标签：

#MySQL

mysql 专栏收录该内容

12 篇文章

订阅专栏

本文详细介绍了MySQL中如何为不同用户分配全局及特定数据库权限的方法，包括EXECUTION、FILE、REPLICATIONCLIENT等特权，并展示了如何使用GRANT命令为本地或远程用户设置各种权限级别的示例。

The EXECUTION, FILE, PROCESS, RELOAD, REPLICATION CLIENT, REPLICATION SLAVE, SHOW DATABASES, SHUTDOWN, and SUPER privileges are administrative privileges that can only be granted globally (using ON *.* syntax).

GRANT FILE ON *.* TO 'mysql_user'@'localhost'

mysql -uroot -p

create database monitor charset=utf8;

#赋权限

#可以从其他主机链接过来
GRANT ALL PRIVILEGES ON monitor.* TO 'monitor_account'@'%' IDENTIFIED BY 'asdfio123k9' WITH GRANT OPTION;

or
#本机链接
GRANT ALL PRIVILEGES ON monitor.* TO 'monitor_account'@'localhost' IDENTIFIED BY 'asdfio123k9' WITH GRANT OPTION;

or
#指定IP链接
GRANT ALL PRIVILEGES ON monitor.* TO 'monitor_account'@'10.22.33.44' IDENTIFIED BY 'asdfio123k9' WITH GRANT OPTION;

#test
mysql -u monitor_account -pasdfio123k9 monitor -h 10.16.254.130