Displaying 1 result from an estimated 1 matches for "mysql_remote".
2011 Apr 15
0
RODBC with MySQL sees tables, but queries return zero rows
...the connection is successful: I can see all tables and columns in my
database. However, queries return zero lines, including queries I've
verified as functional and non-empty by entering them directly in
MySQL.
I granted myself all privileges to the database, as per
http://www.actualtech.com/mysql_remote.php, by entering this into
mysql:
GRANT ALL ON your_database_name.* TO your_user_id@'%' IDENTIFIED BY
'your_password';
I've opened ports on my server, as per
http://forums.systeminetwork.com/isnetforums/showthread.php?t=42086
My setup:
mysql Ver 14.12 Distrib 5.0.77, for redh...