Re: ERROR 1130: Host 'dhcp-70-219' is not allowed to connect to this MySQL server
On Wednesday 17 January 2001 23:38 kerry finn wrote: > Hi, > > I'm new to MySQL. I've installed MySQL on bothWin2000 and Solaris 2.8 > machines. Everything locally works fine. When I tried to connect from > the Win2000 (dhcp-70-219) machine to the Solaris machine > I get the following error: > > "ERROR 1130: Host 'dhcp-70-219' is not allowed to connect to this > MySQL server" > > I have added the hostnames and ip addresses to both /etc/hosts files. > And can ping each other. > > Any ideas (ERROR: 1130) ? > I suppose you have to set up grants on the server side. See the manual (command "grant") how to allow the Win host (dhcp...) connect to the server (Solaris). Regards Pavel > thanks, > Kerry > > - > Before posting, please check: >http://www.mysql.com/manual.php (the manual) >http://lists.mysql.com/ (the list archive) > > To request this thread, e-mail <[EMAIL PROTECTED]> > To unsubscribe, e-mail > <[EMAIL PROTECTED]> Trouble > unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: ERROR 1130: Host 'dhcp-70-219' is not allowed to connect to this MySQL server
This looks to be a misconfig problem with the mySQL server itself. Take a look at the mysql.users table. Make sure there is some type of entry for user '%' from host '%' with a password. Once those are in place, the server should let you in. Be sure the db you are connecting has proper privileges defined in mysql.db -Martin kerry finn wrote: > Hi, > > I'm new to MySQL. I've installed MySQL on bothWin2000 and Solaris 2.8 > machines. Everything locally works fine. When I tried to connect from > the Win2000 (dhcp-70-219) machine to the Solaris machine > I get the following error: > > "ERROR 1130: Host 'dhcp-70-219' is not allowed to connect to this > MySQL server" > > I have added the hostnames and ip addresses to both /etc/hosts files. > And can ping each other. > > Any ideas (ERROR: 1130) ? > > thanks, > Kerry > > - > Before posting, please check: >http://www.mysql.com/manual.php (the manual) >http://lists.mysql.com/ (the list archive) > > To request this thread, e-mail <[EMAIL PROTECTED]> > To unsubscribe, e-mail <[EMAIL PROTECTED]> > Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
