mysql权限

来源:互联网 发布:php 端口号链接超时 编辑:程序博客网 时间:2024/03/28 21:27
1.查看数据库用户权限,默认是root@locakhostmysql> show grants;      +---------------------------------------------------------------------+| Grants for root@localhost                                           |+---------------------------------------------------------------------+| GRANT ALL PRIVILEGES ON *.* TO 'root'@'localhost' WITH GRANT OPTION |+---------------------------------------------------------------------+2.查看数据库某用户的权限mysql> show grants for root@'localhost';+---------------------------------------------------------------------+| Grants for root@localhost                                           |+---------------------------------------------------------------------+| GRANT ALL PRIVILEGES ON *.* TO 'root'@'localhost' WITH GRANT OPTION |+---------------------------------------------------------------------+2.授予用户在所有数据库上的所有权限mysql> GRANT ALL PRIVILEGES ON *.* TO 'root'@'192.168.1.105' IDENTIFIED BY 'huawei123#';// 所有ip都可以以这个用户名密码访问数据库mysql> GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' IDENTIFIED BY 'huawei123#';//刷新系统权限表mysql> flush privileges;
0 0