User received the following error when attempting to connect to their MySQL v5.0.2 Database from Spotlight on MySQL 2.0.
[MySQL][ODBC 3.51 Driver]Access denied for user 'mysqlname'@'localhost.localdomain' ( (using password: YES)
[MySQL][ODBC 3.51 Driver]Access denied for user 'mysqlname'@'localhost.localdomain' ( (using password: YES)
[MySQL][ODBC 3.51 Driver]Access denied for user 'mysqlname'@'localhost.localdomain' ( (using password: YES)
User switched to an 8 character-digit password, e.g. max 8 letters and digits. User unable to connect [natively] using the ODBC driver to a MySQL database.
1. Verify that the MySQL client has been installed. For example, the MySQL 3.5.1 odbc driver.
2. Verify the user can connect to a native MySQL tool or through the MySQL Datasource ODBC Test connection via Control Panel | ODBC Connection.
3. Verify the user can Telnet the Database server using the default MySQL port number 3306.
4. Verify the User is using an 8 character-digit password, e.g. max 8 letters and digits.
Reference: Setting up the ODBC connection
http://www8.pair.com/dmurdoch/mysql.html
First, you need to download and install the MyODBC driver from www.mysql.org, currently at http://dev.mysql.com/downloads/connector/odbc/3.51.html.
Then, in Windows XP, go to Settings | Control Panel | Administrative tools | Data sources | Add...
Choose the "MySQL ODBC 3.51 driver" (or whatever version you downloaded), and fill in the fields.
Example:
Data source name: the name you'll use in Windows to refer to the database.
Description: your helpful description.
Server: localhost
User: mysqlname (your MySQL database username)
Password: ******* (your MySQL database password)
Database: mydatabase (the name of the database to connect to)
Careful with the password: remember, max 8 letters and digits.
On the 2nd page of the dialog, choose to connect to port 3307 (matching the local port that the tunnel is using).
Then click "Test". If you get errors like: "[MySQL][ODBC 3.51 Driver]#HY000Host 'localhost.localdomain' is not allowed to connect to this MySQL server", grant your user account access rights from host localhost.localdomain.
