如何从远端登录mysql
我有个vps ip,上面安装了mysql数据库。我用putty登录vps后,进入这个mysql.mysql> GRANT ALL PRIVILEGES ON . TO 'root'@'%'IDENTIFIED BY 'passwd' WITH GRANT OPTION;
mysql> FLUSH PRIVILEGES;
然后 service mysql restart
现在,我为何不能从远端登录这个mysql数据库?
mysql -h vpsip -P 3306 -u root -ppasswd
ERROR 2003 (HY000): Can't connect to MySQL server on 'vpsip' (111)
你的vps有映射3306这个端口吗?
页:
[1]