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 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
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
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
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 This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics
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...
|
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...
|
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...
|
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...
|
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...
|
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...
|
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...
|
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...
|
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...
|
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...
|
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...
|
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...
|
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 =...
|
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...
|
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...
|
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...
|
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...
|
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)...
| |