On 4/3/07, Fischer, Benjamin <[email protected]> wrote:
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
And if I'm not using MySQL administrator? From the command line, I
suppose that it's something like this
http://dev.mysql.com/doc/refman/5.0/en/grant.html
e.g.
grant all on test.* to root@'172.16.100.108' identified by 'password';
?
After doing that, I can now telnet to port 3306 and also test the ODBC DSN.
