1. Please take a little time for this simple survey! Thank you for participating!
    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...