My apologies if I am cross-posting as I am not clear
on which is the proper list for gal questions (& I have
also posted to [EMAIL PROTECTED]).
What is the proper database URL for JDBC connectivity ?
I have set
String url = "jdbc:mysql://localhost:3306/music";
String user = "charly";
String password = "whatever";
and my call to
con = DriverManager.getConnection(url, user, password);
throws:
java.sql.SQLException: Server configuration denies access to data source
at org.gjt.mm.mysql.MysqlIO.init(MysqlIO.java:193)
at org.gjt.mm.mysql.Connection.connectionInit(Connection.java:261)
at org.gjt.mm.mysql.jdbc2.Connection.connectionInit(Connection.java:89)
at org.gjt.mm.mysql.Driver.connect(Driver.java:167)
at java.sql.DriverManager.getConnection(DriverManager.java:515)
at java.sql.DriverManager.getConnection(DriverManager.java:174)
at org.theblueplanet.music.Select.main(Select.java:21)
I'm satisfied that the user & passwords are ok, the port is 3306,
the mysql daemon is running ok, the driver was loaded and
the db 'music' indeed exists, so the problem appears to come from
the URL.
Thanks for your input,
Charles
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
