I got the error:
"Server configuration denies access to data source".
when moving a jdbc app (that uses "localhost" as its host name) from
Windows to Linux (Redhat 6.2).
The solution was:
1. Create a new mysql user whose host is: localhots.localdomain
2. Reload the user privileges information, for example by restarting
mysql.
3. Change the java connection code along the following lines:
Conn = DriverManager.getConnection(
"jdbc:mysql://localhost.localdomain/my_db?user=my_new_user&password=my_new_user_password");
4. Compile and run the new code.
Mike
PS It was Mark Mathew who suggested adding localhost.localdomain to the
network permissions