On the local host using mysql database. Execute the following command at
Mysql>grant all privileges on [database_name].* to 'user'@'remote_host'
identified by 'password'
Please read more about this at
http://dev.mysql.com/doc/refman/4.1/en/grant.html or whatever version of
MySQL you have.
From: news [mailto:news@stripped] On Behalf Of Andreas Moroder
Sent: Thursday, August 24, 2006 9:53 AM
Subject: Allow other host
I have a mysql DB running on a Windows XP machine.
I can access it locally via mysql command, I have also a ODBC driver
installed and the test says it works ok.
When I try to connect from a remote host via JDBC I get the error
message that this host is not allowed to access the db.
How can I enable a external host to access this DB ?
It is possible to configure this from command line ?
( winmysqladmin is not working properly on this machine )
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql