远程登录MySQL

1）首先要确保MySQL服务器允许远程访问。
首先登录

C:\>mysql -u root -p
Enter password: ****
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 1 to server version: 5.0.15-nt

Type 'help;' or '\h' for help. Type '\c' to clear the buffer.

查看mysql库下的user表

user mysql;

mysql> use mysql
Database changed
mysql> select host, user from user;
+---------------+------+
| host          | user |
+---------------+------+
| 127.0.0.1     | root |
| localhost     | root |
+---------------+------+
2 rows in set (0.08 sec)

用update语句把"127.0.0.1"改成客户端的IP 或者改成"%"允许所有人访问

2)客户端
找到客户端的安装目录下的my.cnf文件
bind-address=127.0.0.1
这个地方改成服务器IP地址。
重新启动。