Jiangyue_

原创 MySQL GRANT用法

Grant 授权语法 priv_type: 数据库操作权限 select, update, delete, insert… priv_level: 控制可以访问哪些数据库和表 Grant priv_type [(column_list)] on priv_level to 'username' @ 'IP' identified by 'password'; 常用语句 GRANT ALL PRIVILEGES ON *.* TO 'USER' @ 'localhost' WITH GRANT O