I installed MySQL under Linux Suse 9.0,
using the Driver Connector/J,
but my
Java program cannot connect to the database.
The Driver works fine and MySQL is reachable by direct approach
(means not via Java), as root as well as user.
My java code is the same I used before (with Linux Suse 8.2),
so I know that there is no general problem with the Java code.
this line finds and loads the Driver, okay.
It turns out that this line:
(my url is:
)
makes the program run in some endless try in vain to connect.
I tried both: root with rootPassword or user with userPassword.
I tried with and without the port 3306.
Could there be a problem with some Linux specific permission rights?
directory var/lib has:
drwxr-xr-xuser=mysql, group=daemonmysql
directory var/lib/mysql has:
drwx------user=mysql, group=daemonmyDB
drwxr-xr-xuser=mysql, group=rootmysql
srwxrwxrwxuser=mysql, group=daemonmysql.sock
-rw-rw----user=mysql, group=daemonmysqld.pid
-rw-rw----user=mysql, group=rootmysqld.log
I am not that firm in choosing the right permissions
and don't want to experiment on this again
(I made a mess already once..).
Or should I look somwhere else completely?
Thank you very much for your help!
Juliane