給root使用者添加遠端連接配接權限

環境說明：

 linux as5  mysql資料庫主機 IP：192.168.1.1  root/123456

遠端主機 windows xp IP：192.168.1.2  

一.建立資料庫

[root@mail /root]#mysql -u root -p < DATABASE_MYSQL.SQL(TXT)

二.連接配接檢視資料庫

[root@mail /root]#mysql -u root -p

Enter password: 

Welcome to the MySQL monitor.  Commands end with ; or \g.

Your MySQL connection id is 10 to server version: 5.0.22

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

mysql> use mysql

Reading table information for completion of table and column names

You can turn off this feature to get a quicker startup with -A

Database changed

Query OK, 0 rows affected (0.00 sec)

mysql>flush privileges; (重新整理系統表)

三.用戶端登陸

本文轉自 pgmia 51CTO部落格，原文連結:http://blog.51cto.com/heyiyi/115772