grant all on datebase.* to "user"@"host" Identified by "passwd";
host 一般为localhost,127.0.0.1 ...等等
增加全部数据库 全部权限:
grant all privileges on *.* to "user"@"127.0.0.1" Identified by "passwd";
grant all on datebase.* to "user"@"host" Identified by "passwd";
host 一般为localhost,127.0.0.1 ...等等
增加全部数据库 全部权限:
grant all privileges on *.* to "user"@"127.0.0.1" Identified by "passwd";
转载于:https://my.oschina.net/comguo/blog/107855