ODBC connection with MySQL - DevShed Discussion Forums

★ wanayoo — archive 1999 http://www.devshed.com/Talk/Forums/Forum4/HTML/000667.html

Nouvelle recherche | Portail wanayoo

DevShed Menu

* DevShed Home

* Developer News

* DevShed Brain Dump

UBBFriend: Email This Page to Someone!

DevShed Discussion Forums

MySQL

ODBC connection with MySQL

profile | register | preferences | faq | search

next newest topic | next oldest topic

Author

Topic: ODBC connection with MySQL

tigg
Junior Member

posted July 05, 2000 04:30 PM

I cannot connect to a MySQL database thru ODBC. I keep getting: 'ODBC error: [TCX][MyODBC]Host"is not allowed to connect the this MySQL server'. I have checked the permissions everywhere that I know and they seem alright. What could my problem be or where might I need to fix my permissions that I haven't checked?

Ore
Junior Member

posted July 07, 2000 12:40 PM

quote:
Originally posted by tigg:
I cannot connect to a MySQL database thru ODBC. I keep getting: 'ODBC error: [TCX][MyODBC]Host"is not allowed to connect the this MySQL server'. I have checked the permissions everywhere that I know and they seem alright. What could my problem be or where might I need to fix my permissions that I haven't checked?

Ok, let see.
1) Did you reload the grant tables in the MySQLd?.
2) Try entering in the HOST table of MySQL DB (the grant DB) the IP address of the machine that you are trying to access from and the hostname too (both in diferent rows).
3) Did you encode the password for the user of the DB with the "password" command?.

Greettings and excuse my English, but it is not my mother language =)

All times are MST (US)	next newest topic \| next oldest topic
Administrative Options: Close Topic \| Archive/Move \| Delete Topic
	Hop to:

Contact Us | DevShed.com