以下是远程访问数据库时,给数据库赋予权限方法
grant all privileges on 数据库名.* to 用户名 identified by '密码' with grant option;
grant all privileges on kmproject_new.* to km@192.168.129.56 identified by 'km' with grant option;
然后flush privileges;
以下是远程访问数据库时,给数据库赋予权限方法
grant all privileges on 数据库名.* to 用户名 identified by '密码' with grant option;
grant all privileges on kmproject_new.* to km@192.168.129.56 identified by 'km' with grant option;
然后flush privileges;