Trying to connect to remote MySQL

evanlivin..

Trying to connect to remote MySQL

in Integration and Hardware • 1 years ago

I'm trying to connect to a MySQL database on a remote server using Florian Jenett's Mysql library. However i feel as though the library is only meant to be used for local SQL databases. It seems as though even when I try to change the server it's still trying to connect to a local database.

SQL.connect(): Could not connect to the database ( jdbc:mysql://173.236.223.166:3306/evanliv_democ ).

java.sql.SQLException: Access denied for user 'democ'@'159.28.155.185' (using password: YES)

at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:2975)

at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:798)

at com.mysql.jdbc.MysqlIO.secureAuth411(MysqlIO.java:3700)

at com.mysql.jdbc.MysqlIO.doHandshake(MysqlIO.java:1203)

at com.mysql.jdbc.Connection.createNewIO(Connection.java:2572)

at com.mysql.jdbc.Connection.<init>(Connection.java:1485)

at com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:266)

at java.sql.DriverManager.getConnection(DriverManager.java:582)

at java.sql.DriverManager.getConnection(DriverManager.java:185)

at de.bezier.data.sql.SQL.connect(Unknown Source)

at MySQL_example1.setup(MySQL_example1.java:55)

at processing.core.PApplet.handleDraw(PApplet.java:1608)

at processing.core.PApplet.run(PApplet.java:1530)

at java.lang.Thread.run(Thread.java:680)

Is it possible to connect to a remote database with this library?

thanks for any help.

Replies(2)

PhiLho

Re: Trying to connect to remote MySQL

1 years ago

It depends on the database. I know that one DB I use on a Web server is configured to answer only local requests (basically, from PHP scripts on the same server). It won't answer requests from outside, for security reasons. Which is annoying as we cannot run some tools on the DB.
Looks like you are in the same case. Consult the DB host to see if something can be done.

evanlivin..

Re: Re: Trying to connect to remote MySQL

1 years ago

@phi.lho,

Exactly right. my DB is with dreamhost and I just had to add rights to connect from another host.

Top Reply