MySQL Forums
Forum List  »  Security

Cannot Access Remotely
Posted by: Michael Hare
Date: June 27, 2005 11:44AM

I've been using mySQL for several years now, but always access from PHP code on the local server.
My server is running Windows2000 Pro with MySQL 4.1.11

Now I'm trying to branch out and connect using JDBC. The only users I had before were accessing the data from the 'localhost', now I need to access from other hosts.

I'm not clear, reading about the security model, how to turn all this on.
As a test I created a new user, 'auser' with a simple password, 'auser1'

In the USER table I have:
HOST: <empty>
USER: auser
PASSWORD: <whatever it MD5'd to>
Granted Select Privilege Only (I just want to see it work)

In the DB table I have:
HOST: % (for all remote hosts)
USER: auser
DB: mydatabase
Granted Select Privilege Only

In the HOST table I have
HOST: % (for all remotes hosts)
DB: mydatabase
Granted Select Privilege Only

I still get "#HY000Host 'my-remote-hostname' is not allowed to copnnect to this MySQL server".

I can't telnet into the database either, I get the connection refused.

Any ideas what I have not done to get this working?

Thanks

------------------------------
Mike

GnuPG Key fingerprint = 1AD4 726D E359 A31D 05BF ACE5 CA93 7AD5 D8E3 A876

Options: ReplyQuote


Subject
Views
Written By
Posted
Cannot Access Remotely
4565
June 27, 2005 11:44AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.