mysql 用localhost能登录:ip不能登录 :
执行下面程序,参数自换:
grant all privileges on *.* to '用户名'@'你本机ip' identified by '密码';
mysql 他人无法用ip连接:
在mysql执行如下代码,参数自换
GRANT ALL PRIVILEGES ON *.* TO '用户名'@'%' IDENTIFIED BY '密码' WITH GRANT OPTION;
FLUSH PRIVILEGES;
mysql 用localhost能登录:ip不能登录 :
执行下面程序,参数自换:
grant all privileges on *.* to '用户名'@'你本机ip' identified by '密码';
mysql 他人无法用ip连接:
在mysql执行如下代码,参数自换
GRANT ALL PRIVILEGES ON *.* TO '用户名'@'%' IDENTIFIED BY '密码' WITH GRANT OPTION;
FLUSH PRIVILEGES;