Hi, Try this update user set Host='%' where Host='foobar'; update db set Host='%' where Host='foobar';
Cheers ----- Original Message ----- From: "Brian Henning" <[EMAIL PROTECTED]> To: "freebsd" <[EMAIL PROTECTED]> Sent: Monday, February 03, 2003 09:30 PM Subject: mysql add host > Hello, > I just installed mysql and i would like to allow all hosts to acess the > databases on my server. > > ERROR 1130: Host 'foobar' is not allowed to connect to this MySQL server > > what can i do to remedy this problem? > > thank, > b > > > ps.. the command:. > >telnet foobar 3306 > > Host 'trinity.the-matrix.net' is not allowed to connect to this MySQL server > > Connection to host lost. > > > To Unsubscribe: send mail to [EMAIL PROTECTED] > with "unsubscribe freebsd-questions" in the body of the message > To Unsubscribe: send mail to [EMAIL PROTECTED] with "unsubscribe freebsd-questions" in the body of the message