Page 1 of 1

Trying to Import MySQL data into ArcMAP

Posted: Wed Jul 23, 2003 10:19 am
by DynPHP
Has anyone done this, we keep getting an authentification error. Am using ODBC connection to connect from the database to the windows box.

Error I get:

Code: Select all

[ODBC 3.51 Driver]Access denied for user:'user name@ip address'(Using Password:Yes)

Posted: Wed Jul 23, 2003 3:01 pm
by Stoker
You have to grant access to the table for the user to access it from the host you are connecting from

USE databasename
GRANT SELECT ON table TO 'user'@'hostname' IDENTIFIED BY 'password'