RE: Allow other host
Hi Andreas, On the local host using mysql database. Execute the following command at mysql prompt: 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. Regards Mikhail Berman -Original Message- From: news [mailto:[EMAIL PROTECTED] On Behalf Of Andreas Moroder Sent: Thursday, August 24, 2006 9:53 AM To: mysql@lists.mysql.com Subject: Allow other host Hello, 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 ) Thanks Andreas -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Allow other host
You ought to look at the field Host in the table Users In the db Mysql. This field set from where this user can access. If you put a % simbol in it the user could access from any host, or if this user can access only from on host, you must put in this field the IP of the host. Hope help. "Andreas Moroder" <[EMAIL PROTECTED]> escreveu na mensagem news:[EMAIL PROTECTED] > Hello, > > 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 ) > > Thanks > Andreas > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Allow other host
Hello, 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 ) Thanks Andreas -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]