• Plesk Uservoice will be deprecated by October. Moving forward, all product feature requests and improvement suggestions will be managed through our new platform Plesk Productboard.
    To continue sharing your ideas and feedback, please visit features.plesk.com

Problems with access mysql with Jdbc drivers

A

agews

Guest
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) ?
 
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 !
 
Back
Top