Problem Setting up MyODBC Driver
HI I am trying to set up an ODBC connection between my Windows 2000 PC and my Web Server which has a MySQL database on it. I installed the MyODBC package for Windows NT and entered all the relevant information: DSN E-SkyMySQL MySQL host 192.168.1.100 MySQL Database Name eskylight User httpd and Password I did this as a machine data source When I try to connect I get the error message S1000[TCX][MYODBC] Host " is not allowed to connect to this MySQL Server. Any Ideas why this may be happening? Thanks Nick Steele - 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: Problem Setting up MyODBC Driver
Your workstation may not be in the host table of the MySQL Server. Pat... - Original Message - From: "Nick" [EMAIL PROTECTED] To: "mysql" [EMAIL PROTECTED] Sent: Tuesday, March 20, 2001 9:31 AM Subject: Problem Setting up MyODBC Driver HI I am trying to set up an ODBC connection between my Windows 2000 PC and my Web Server which has a MySQL database on it. I installed the MyODBC package for Windows NT and entered all the relevant information: DSN E-SkyMySQL MySQL host 192.168.1.100 MySQL Database Name eskylight User httpd and Password I did this as a machine data source When I try to connect I get the error message S1000[TCX][MYODBC] Host " is not allowed to connect to this MySQL Server. Any Ideas why this may be happening? Thanks Nick Steele - 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: Problem Setting up MyODBC Driver
Hi Nick, I think u have to make the following. go to mysql prompt: use mysql; then select * from user; is there an entry for the mysql client and the user on it? i don't think so. so u have to make a new entry. then: grant all on *.* to username@clienthostname username (username u are connecting with from client) clienthostname (hostname of your client) after this is done make the following from your mysql directory: bin/mysqladmin -u root flush-privileges hope that helps regards denis On Tuesday 20 March 2001 15:31, you wrote: HI I am trying to set up an ODBC connection between my Windows 2000 PC and my Web Server which has a MySQL database on it. I installed the MyODBC package for Windows NT and entered all the relevant information: DSN E-SkyMySQL MySQL host 192.168.1.100 MySQL Database Name eskylight User httpd and Password I did this as a machine data source When I try to connect I get the error message S1000[TCX][MYODBC] Host " is not allowed to connect to this MySQL Server. Any Ideas why this may be happening? Thanks Nick Steele - 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