1. Please take a little time for this simple survey! Thank you for participating!
    Dismiss Notice
  2. Dear Pleskians, please read this carefully! New attachments and other rules Thank you!
    Dismiss Notice
  3. Dear Pleskians, I really hope that you will share your opinion in this Special topic for chatter about Plesk in the Clouds. Thank you!
    Dismiss Notice

Problems with access mysql with Jdbc drivers

Discussion in 'Plesk for Linux - 8.x and Older' started by agews, Jan 20, 2005.

  1. agews

    agews Guest

    0
     
    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) ?
     
  2. agews

    agews Guest

    0
     
    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 !
     
Loading...