RE: Allow other host

2006-08-24 Thread Mikhail Berman
man/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 runni

Re: Allow other host

2006-08-24 Thread Jo�o C�ndido de Souza Neto
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. "Andr

Allow other host

2006-08-24 Thread Andreas Moroder
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