Your problem is that your Host is not allowed to connect as 'your user'. In the database under the user you need to set the '172.16.100.108' as a allowed host.
If you are using MySQL Administrator: Click on User Administration Right click on the user you want to use and from the menu select Add Host from Which the User Can Connect Hope this helps. -----Original Message----- From: [email protected] [mailto:[email protected]] On Behalf Of Roger E. Rustad, Jr. Sent: Tuesday, April 03, 2007 10:30 AM To: 909linux.org general mailing list Subject: Re: [909linux] IPtables question (was MySQL thread....) > In the Windows ODBC program, now I get > > "[MySQL][ODBC 3.51 Driver]Host '172.16.100.108' is not allowed to > connect to this MySQL server" > > instead of (what I originally got) > > "MySQL][ODBC 3.51 Driver]Can't connect to MySQL server on > '172.16.100.200' (10065)" > > I'm guessing that "not allowed" is a permissions issue or > something...or perhaps something like tcp/ip isn't enabled? An update to the problem. "netstat" shows that the port isn't even listening, so it's most likely a TCP/IP problem. Joel suggested that my.cnf wasn't properly configured, so I'm looking at some examples. _______________________________________________ 909linux mailing list [email protected] http://909linux.org/cgi-bin/mailman/listinfo/909linux
