ODBC and Mysql problem

Anon

Hi My problem is that when I using MySQL tables in localhost everything works fine but
ODBC requires certain host ip like 192.168.0.2 and when I use in linux command
mysql -h 192.168.0.2 -u webuser to connect
MySQL it doesn't work.
question is how can I define in MySQL whitch Ip addresses I can use to connect MySQL or Am I doing something wrong in ODBC conf????

Anon

Do you have the appropiate permissions in the "mysql" database?
You might have to grant "webuser" the permission to connect,
something like:

GRANT ALL ON dbname.* TO webuser@192.168.0.2 IDENTIFIED BY 'passwd';
FLUSH PRIVILEGES;

I hope this help....

Anon

my problem still exist...

[lauri@oxygen lauri]$ mysql -h 192.168.0.4 -u root -p
Enter password:
ERROR 2003: Can't connect to MySQL server on '192.168.0.4' (111)
[lauri@oxygen lauri]

Anon

You may need to put the database you're trying to connect
mysql -h 192.168.0.4 -uroot database -p

or add the host 192.168.0.4 to the mysql.host table

mysql mysql -e 'describe host' to construct your insert statement

mysql mysql -e 'insert into host VALUES('192.168.0.4','dbname','Y',.......)

This may help