Connection Error help please...

General usage of Access to MySQL

Moderator: jr

Post Reply
Posts: 1
Joined: Fri Mar 15, 2013 5:48 pm

Connection Error help please...

Post by GhostRider2110 »

Moving data directly to MySQL server

Error connecting to destination database.
Connection: Provider=MSDASQL.1;Driver={MySQL ODBC 5.2w Driver};Extended Properties="SERVER=localhost;UID=root;PWD=********Access;PORT=3306;OPTION=0;STMT=;"
Program Version:
ODBC Version:
Function: modMySql.MoveData2MySql
Error: -2147467259
Reason: [MySQL][ODBC 5.2(w) Driver]Access denied for user 'root'@'localhost' (using password: YES)

I know that account works, MySQL workbench has no problem connecting.

Any help would be greatly appreciated.

Posts: 6
Joined: Tue Jun 04, 2013 12:22 am

Re: Connection Error help please...

Post by cove3 »

1. Use Admin Tools/ODBC to test connecton
2. Be sure your hosting MYSQL has enable remote connections checked
3. Make sure your sign in has full priviliges for the database
4. Check if your hosting MYSQL has drop database disabled. If anything is wrong with the script, my x10 host gives a access denied message, rather than any explanation of what the problem is

Post Reply