MySql权限设置

MySql开始没有权限需要:

grant all privileges on *.* to 账户@'%' identified by '密码' with grant option;(对全部数据设置权限,%=IP地址)

grant all privileges on 数据库名.* to 账户@'%' identified by '密码' with grant option;(对单个数据库设置权限)

flush privileges;(刷新配置)

posted on 2014-12-27 10:52  羽落丶星辰  阅读(93)  评论(0编辑  收藏  举报

导航