mysql远程连接有关问题

mysql远程连接问题

远程连接问题，大家可以参考：1、MYSQL服务器上：比如：

?

C:\>mysql -uroot -pEnter password: ******Welcome to the MySQL monitor. Commands end with ; or \g.Your MySQL connection id is 2Server version: 5.1.22-rc-community-log MySQL Community Server (GPL)Type 'help;' or '\h' for help. Type '\c' to clear the buffer.mysql> grant all privileges on *.* to 'yourname'@'%' identified by 'youpasswd';Query OK, 0 rows affected (0.05 sec)mysql> flush privileges;Query OK, 0 rows affected (0.06 sec)mysql> exitBye

开启3306的方法：http://www.google.cn/search?hl=zh-CN&q=%E5%BC%80%E5%90%AF3306&meta=2、这里假设用SQLYog连接MYSQL服务器。客户端机器上：HOST ADDRESS:服务端IP地址USER NAME：yournamePASSWORD:yourpasswdPORTS：3306DATABASES：可以留空。