473,288 Members | 1,718 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,288 software developers and data experts.

Trouble connecting to mysql databases to link tables

I have a Mysql database hosted on a remote server. Previously, I could
always connect to those databases using the 3.51 ODBC connector and
linking the tables in Access. The benefit of this is that I can view
the data from my desktop, export it to spreadsheets if necessary and
print labels.

I guess because of a Mysql upgrade by my host, the 3.51 connector
stopped working (the password hash problem), so I upgraded to the 5.*
ODBC connector (beta). That got me connected, but I can't view the only
table in the database because I get this error:

ODBC -- call failed.

[MySQL][MyODBC 5.00.6][MySQL] 1142 SELECT command denied to user
(myusername)@(myisp) for table 'STATISTICS' #1142

I didn't even KNOW I had a table called "statistics," although I guess
it's a log or something. I was trying to link a table called "signups"
that's in the database.

I know my login info is correct, because I've been able to open the
database and edit this table using a free GUI called SQLYog.

I don't have command-line access to my databases, so any queries have
to be run (I assume) from phpMyAdmin.

Any suggestions? And please talk to me like I'm a five-year-old,
because when it comes to this stuff, I am. :)
Thanks,

Tracey

Nov 27 '06 #1
4 3995
If it worked before, then I suspect your ODBC driver may not be
compatible with the new version of MySQL. Also, never use a beta
edition in production mode. Instead of version 5, get the latest
version of 3.51 (3.51.12) from here:

http://dev.mysql.com/downloads/connector/odbc/3.51.html

Alexandre Bejerman
Montreal, Canada
Tracey wrote:
I have a Mysql database hosted on a remote server. Previously, I could
always connect to those databases using the 3.51 ODBC connector and
linking the tables in Access. The benefit of this is that I can view
the data from my desktop, export it to spreadsheets if necessary and
print labels.

I guess because of a Mysql upgrade by my host, the 3.51 connector
stopped working (the password hash problem), so I upgraded to the 5.*
ODBC connector (beta). That got me connected, but I can't view the only
table in the database because I get this error:

ODBC -- call failed.

[MySQL][MyODBC 5.00.6][MySQL] 1142 SELECT command denied to user
(myusername)@(myisp) for table 'STATISTICS' #1142

I didn't even KNOW I had a table called "statistics," although I guess
it's a log or something. I was trying to link a table called "signups"
that's in the database.

I know my login info is correct, because I've been able to open the
database and edit this table using a free GUI called SQLYog.

I don't have command-line access to my databases, so any queries have
to be run (I assume) from phpMyAdmin.

Any suggestions? And please talk to me like I'm a five-year-old,
because when it comes to this stuff, I am. :)
Thanks,

Tracey
Nov 27 '06 #2
If it worked before, then I suspect your ODBC driver may not be
compatible with the new version of MySQL. Also, never use a beta
edition in production mode. Instead of version 5, get the latest
version of 3.51 (3.51.12) from here:

http://dev.mysql.com/downloads/connector/odbc/3.51.html

Alexandre Bejerman
Montreal, Canada
Tracey wrote:
I have a Mysql database hosted on a remote server. Previously, I could
always connect to those databases using the 3.51 ODBC connector and
linking the tables in Access. The benefit of this is that I can view
the data from my desktop, export it to spreadsheets if necessary and
print labels.

I guess because of a Mysql upgrade by my host, the 3.51 connector
stopped working (the password hash problem), so I upgraded to the 5.*
ODBC connector (beta). That got me connected, but I can't view the only
table in the database because I get this error:

ODBC -- call failed.

[MySQL][MyODBC 5.00.6][MySQL] 1142 SELECT command denied to user
(myusername)@(myisp) for table 'STATISTICS' #1142

I didn't even KNOW I had a table called "statistics," although I guess
it's a log or something. I was trying to link a table called "signups"
that's in the database.

I know my login info is correct, because I've been able to open the
database and edit this table using a free GUI called SQLYog.

I don't have command-line access to my databases, so any queries have
to be run (I assume) from phpMyAdmin.

Any suggestions? And please talk to me like I'm a five-year-old,
because when it comes to this stuff, I am. :)
Thanks,

Tracey
Nov 27 '06 #3
If it worked before, then I suspect your ODBC driver may not be
compatible with the new version of MySQL. Also, never use a beta
edition in production mode. Instead of version 5, get the latest
version of 3.51 (3.51.12) from here:

http://dev.mysql.com/downloads/connector/odbc/3.51.html

Alexandre Bejerman
Montreal, Canada
Tracey wrote:
I have a Mysql database hosted on a remote server. Previously, I could
always connect to those databases using the 3.51 ODBC connector and
linking the tables in Access. The benefit of this is that I can view
the data from my desktop, export it to spreadsheets if necessary and
print labels.

I guess because of a Mysql upgrade by my host, the 3.51 connector
stopped working (the password hash problem), so I upgraded to the 5.*
ODBC connector (beta). That got me connected, but I can't view the only
table in the database because I get this error:

ODBC -- call failed.

[MySQL][MyODBC 5.00.6][MySQL] 1142 SELECT command denied to user
(myusername)@(myisp) for table 'STATISTICS' #1142

I didn't even KNOW I had a table called "statistics," although I guess
it's a log or something. I was trying to link a table called "signups"
that's in the database.

I know my login info is correct, because I've been able to open the
database and edit this table using a free GUI called SQLYog.

I don't have command-line access to my databases, so any queries have
to be run (I assume) from phpMyAdmin.

Any suggestions? And please talk to me like I'm a five-year-old,
because when it comes to this stuff, I am. :)
Thanks,

Tracey
Nov 27 '06 #4
Well, looks like you're right. I'd been told by someone in the mySql
forums that I'd need to run a 5.* client to get around a password
hashing incompatibility that was introduced in mysql 4.*, but that
version of the 3.51 client you pointed me to works like a charm.
Thanks!

Tracey

Nov 28 '06 #5

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

7
by: Peter Bach | last post by:
Would a medium sized (~500 pages) database driven website, search engine and mailing list be too much for one MySQL database? Instead of making using different databases I would use different...
11
by: Joshua Beall | last post by:
Hi All, I am working on a registration system, and one of the things I am going to need to be able to do it setup the database tables for each event that I have registration for. Normally I...
2
by: uli2003wien | last post by:
Dear group, we are dealing with some very specific problems with ODBC, where a connection from SQL-Server to Mysql works with ODBC-driver 3.51.10.00 and does NOT work with ODBC-driver...
5
by: Matt | last post by:
I know it is possible to establish a connection to an SQL Server over the Internet via Enterprise Manager. My question is, how secure is this connection? Is there a best practices document for this...
3
by: eieiohh | last post by:
MySQL 3.23.49 PHP 4.3.8 Apache 2.0.51 Hi All! Newbie.. I had a CRM Open Source application installed and running. Windows Xp crashed. I was able to copy the contents of the entire hard...
5
by: Nathan Given | last post by:
Hello All, I've been struggling on and off for 3 months trying to connect to an DB2 database running on an IBM iSeries machine. I FINALLY figured out how to connect with Coldfusion (see...
3
by: Mike | last post by:
I have transferred the data from Access to MySQL using MySQL's tool. The transfer worked great and saved me a lot of time (thanks MySQL). Now I'm trying to get the Access database, or a new access...
4
by: Jayhawk | last post by:
Hello, I am trying to use a MS Access front end application to link to data tables stored in MySQL Server. I am running MySQL 5.0 Community Server, MySQL Connector/ODBC 3.51, and MS Access...
18
by: asi242 | last post by:
Hello, Good day to all... I just want to ask.. How would you connect two tables from 2 different databases using PHP scripts? Because, one database that contains customer table is dedicated to...
2
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 7 Feb 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:30 (7.30PM). In this month's session, the creator of the excellent VBE...
0
by: DolphinDB | last post by:
The formulas of 101 quantitative trading alphas used by WorldQuant were presented in the paper 101 Formulaic Alphas. However, some formulas are complex, leading to challenges in calculation. Take...
0
by: Aftab Ahmad | last post by:
Hello Experts! I have written a code in MS Access for a cmd called "WhatsApp Message" to open WhatsApp using that very code but the problem is that it gives a popup message everytime I clicked on...
0
by: Aftab Ahmad | last post by:
So, I have written a code for a cmd called "Send WhatsApp Message" to open and send WhatsApp messaage. The code is given below. Dim IE As Object Set IE =...
0
by: marcoviolo | last post by:
Dear all, I would like to implement on my worksheet an vlookup dynamic , that consider a change of pivot excel via win32com, from an external excel (without open it) and save the new file into a...
0
by: Vimpel783 | last post by:
Hello! Guys, I found this code on the Internet, but I need to modify it a little. It works well, the problem is this: Data is sent from only one cell, in this case B5, but it is necessary that data...
0
by: jfyes | last post by:
As a hardware engineer, after seeing that CEIWEI recently released a new tool for Modbus RTU Over TCP/UDP filtering and monitoring, I actively went to its official website to take a look. It turned...
0
by: ArrayDB | last post by:
The error message I've encountered is; ERROR:root:Error generating model response: exception: access violation writing 0x0000000000005140, which seems to be indicative of an access violation...
1
by: PapaRatzi | last post by:
Hello, I am teaching myself MS Access forms design and Visual Basic. I've created a table to capture a list of Top 30 singles and forms to capture new entries. The final step is a form (unbound)...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.