Why am I getting an error connecting to MySQL?
From the README.txt file: NOTE: If you get a ‘Server configuration denies access to data source’ or ‘access denied’ or ‘Invalid authorization’ or ‘java.lang.NullPointerException: Connection object was null.’ error from MySQL in the log files, please read the MySQL documentation on how to fix this error. We will not provide support for this since it is really a MySQL configuration issue. Hint: On some operating systems, there seems to be a weird interation between the JVM, DNS resolution and the MySQL driver where a JDBC url pointing to ‘localhost’ will resolve as ‘localhost.localdomain’ and will prevent the connection to MySQL from authenticating correctly because most people configure MySQL for ‘localhost’. One way to get around this is to use IP addresses in both the MySQL ACL as well as in the JDBC url. At least one person has reported that using ‘127.0.0.1’ instead of ‘localhost’ resolved a ‘Server configuration denies access to data source’ connection issue. In order to setup the
Related Questions
- How do I resolve the Exception when initializing the connection to MySQL error message that I receive when I launch IME from the browser?
- How can I prevent a FileMaker "fetch forward" error when transferring data to MySQL via an ODBC connection?
- Why do I get a MySQL 1064 error when attempting to create a MySQL table?
