take a look in the user table (database mysql). There should be a row like this...
Host User Password .... localhost root ... means that the user root can connect from localhost (the mysql server) only. replace localhost by % or (better) insert a new row % newuser password ... ------------------------------------------------- Hi, I tried to connect to a mysql database running on a linux server using an odbc connection in windows 98. I get the following message: [TCX][MyODBC]Host x.x.x.x is not allowed to connect to this MySQL server (#1130)[Microsoft][ODBC Driver Manager] Connection not open (#0) The username specified in the data source name is root and I can ping the server where MySQLis running. What did I do wrong or did not do at all on client or server side? Plase help me. --------------------------------------------------------------------- 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