Problems with access mysql with Jdbc drivers

[agews]

We want to approach to one database mySQL with JDBC drivers with Plesk 7.5.1 on RedHat Ent. Server 3.0

We use a script like this:

/usr/java/jdk1.4.2/bin/java -cp /usr/xxx/mysql-connector-java-3.0.6-stable-bin.jar /usr/xxx/com/agews/vgload/LoadVirtual

In JDBC drivers we setup:
ServerName=localhost
Database= database_name
Port=3306
User=username
Password=password
etc.

but when we launch the procedure we obtain the following error:
"Server configuration denies access to data source"

We have set up all the corrected permissions of access on mySQL!

There are other configurations to bring to the system (example: tomcat/catalina.policy) ?

 

[agews]

Grant database on mySQL

The solutions is:

# mysql -u admin -p [CP_PASSWORD]
mysql> use [DATABASE];
mysql> GRANT ALL ON [DATABASE].* TO [USER] IDENTIFIED BY '[PASSWORD]';
mysql> FLUSH PRIVILEGES;
mysql> exit;

after access with JDBC to mySQL work fine !