linux创建权限数据库用户
linux创建权限数据库用户
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";
grant all privileges on *.* to "user"@"127.0.0.1" Identified by "passwd";