can't get remote access to mysql server

hughes28105 · 09-14-2005, 02:23 PM

I have just finished geting my sql server up and running but now i can get remote access to mysql.

david_ross · 09-14-2005, 02:28 PM

What error do you get?

Is it listening on port 3306?

Do you have any firewall rules in place?

Is your user account set up correctly?

hughes28105 · 09-14-2005, 03:53 PM

Could not connect to host
MySQl Error Nr. 1130
Host '192.168.1.103' is not allowed to connect to this MySQL server

here is the error message

david_ross · 09-14-2005, 04:13 PM

When you set up your user account on mysql you'll need to specify your hostname/ip address or "%" wildcard as the hostname.

hughes28105 · 09-15-2005, 07:18 PM

hay got mysql to work. but now i am having problems creating new user in mysql administrator gui. i get an error message like could not retrieve privilege information.

david_ross · 09-17-2005, 09:05 AM

I'm not sure what the GUI does, what happens when you just run a grant statement?

What error do you get?

hughes28105 · 09-17-2005, 09:07 PM

the grant statment works and there no problem with the grant statment. but the gui is were the problem is.