mysql操作

1.允许本地所有数据库权限

grant all privileges on *.* to root@localhost identified by "XXX" ;　

grant all privileges on *.* to root@"%" identified by "XXX" ;

2.设置用户访问数据库权限

grant all privileges on 数据库.* to root@localhost identified by "XXX" ;　

grant all privileges on 数据库.* to root@"%" identified by "XXX" ;