如何從遠(yuǎn)端登錄mysql

hallo_2015

我有個vps ip,上面安裝了mysql數(shù)據(jù)庫。我用putty登錄vps后，進(jìn)入這個mysql.

mysql> GRANT ALL PRIVILEGES ON . TO 'root'@'%'IDENTIFIED BY 'passwd' WITH GRANT OPTION;
mysql> FLUSH PRIVILEGES;

然后   service mysql restart

現(xiàn)在，我為何不能從遠(yuǎn)端登錄這個mysql數(shù)據(jù)庫？

mysql -h vpsip -P 3306 -u root -ppasswd
ERROR 2003 (HY000): Can't connect to MySQL server on 'vpsip' (111)

lyhabc

你的vps有映射3306這個端口嗎？