借人气问：连MySQL的问题? - 未名空间MITBBS历史存档

国际科技财经博客移民网络热点娱乐民生时事公众号

Redian新闻

>未名空间

>Database - 数据库

借人气问：连MySQL的问题?

借人气问：连MySQL的问题?# Database - 数据库

c*t2005-08-16 07:08

1 楼

Behind the router, I have a linux box, and a XP box;
MySQL is running on the linux box; MySQL Administrator 1.0 is running on XP.
But I cann't connect to the linux box from XP with the valid user account.
The account (someuser) was created by:
GRANT USAGE ON myapp.* TO 'someuser'@'192.168.0.xxx' IDENTIFIED BY 'some_pass'
;
FLUSH PRIVILEGES;
Any clue?

D*I2005-08-16 07:08

2 楼

GRANT USAGE ON myapp.* TO 'someuser'@'192.168.%' IDENTIFIED BY 'some_pass'
or
GRANT USAGE ON myapp.* TO 'someuser'@'%' IDENTIFIED BY 'some_pass'
also make sure port is ok

pass'

【在 c**t 的大作中提到】

: Behind the router, I have a linux box, and a XP box;
: MySQL is running on the linux box; MySQL Administrator 1.0 is running on XP.
: But I cann't connect to the linux box from XP with the valid user account.
: The account (someuser) was created by:
: GRANT USAGE ON myapp.* TO 'someuser'@'192.168.0.xxx' IDENTIFIED BY 'some_pass'
: ;
: FLUSH PRIVILEGES;
: Any clue?