Connection Error help please...

General usage of Access to MySQL

Moderator: jr

Connection Error help please...

Postby GhostRider2110 » Fri Mar 15, 2013 6:20 pm

SETTINGS
--------
Moving data directly to MySQL server

TABLES
------------
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: 5.1.0.232
ODBC Version: 5.2.4.0
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.

See-ya
Mitch
GhostRider2110
 
Posts: 1
Joined: Fri Mar 15, 2013 5:48 pm

Re: Connection Error help please...

Postby cove3 » Fri Jun 07, 2013 9:31 pm

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

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


Return to General

Who is online

Users browsing this forum: No registered users and 2 guests

cron