Have you tried logging in as root? If that works, then you'll know
that it's a privilages issue with your java user. Also, have you tried
starting the mysql client logged in as java? i.e.- mysql -u java -p
Russ Wright wrote:
>Hey Sluggers
>I'm having some problems with a java app I'm writing for school.
>I have mysql running on my local box and the database and table exist.
>the user has insert update select delete rights. I have the mysql conectj
>driver installed.
>
>MY CODE:
>try
>{
>//using MySQL database connectj driver
>//www.mysql.com
>//syntax eample:
>//String cs = "jdbc:mysql://"+dbserver+"/"+dbname+"?user="+user
>+"&password="+password;
>url = "jdbc:mysql://127.0.0.1:3306/TS5502?user=java&password=secret";
>//register the MySQL Driver
>Class.forName("com.mysql.jdbc.Driver").newInstance();
>connect = DriverManager.getConnection(url);
>connectField.setText("Connection successful");
>
>}
>catch(ClassNotFoundException cnfx)
>{
>cnfx.printStackTrace();
>connectField.setText("Connection unsuccessful" + cnfx.toString());
>}
>catch (SQLException sqlx)
>{
>sqlx.printStackTrace();
>connectField.setText("Connection unsuccessful" + sqlx.toString());
>}
>catch (Exception ex)
>{
>ex.printStackTrace();
>connectField.setText("Connection unsuccessful" + ex.toString());
>}
>
>
>THE ERROR:
>
>java.sql.SQLException: Unable to connect to any hosts due to exception:
>java.security.AccessControlException: access denied
>(java.net.SocketPermission 127.0.0.1:3306 connect,resolve)
> at com.mysql.jdbc.Connection.createNewIO(Connection.java:1797)
> at com.mysql.jdbc.Connection.<init>(Connection.java:562)
> at
>com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:361)
> at java.sql.DriverManager.getConnection(DriverManager.java:512)
> at java.sql.DriverManager.getConnection(DriverManager.java:193)
> at finalProject.AddressBook.myInit(AddressBook.java:398)
> at finalProject.AddressBook.init(AddressBook.java:85)
> at sun.applet.AppletPanel.run(AppletPanel.java:353)
> at java.lang.Thread.run(Thread.java:534)
>
>
>
>-----------------------------------------------------------------------
>This list is provided as an unmoderated internet service by Networked
>Knowledge Systems (NKS). Views and opinions expressed in messages
>posted are those of the author and do not necessarily reflect the
>official policy or position of NKS or any of its employees.
>
>
>
-----------------------------------------------------------------------
This list is provided as an unmoderated internet service by Networked
Knowledge Systems (NKS). Views and opinions expressed in messages
posted are those of the author and do not necessarily reflect the
official policy or position of NKS or any of its employees.
This archive was generated by hypermail 2.1.3 : Fri Aug 01 2014 - 19:49:47 EDT