Using online mysql database with java

Question

I'm trying to build portfolio and I have problem with using online mysql database. I have code like this:

public class DBManager {
    public static String _host = "sql8.freesqldatabase.com";
    public static String _port = "3306";
    public static String _user = "************";
    public static String _pass = "**************";
    public static String _db = "**********";

    private static Connection connection;

    public static Connection getConnection() throws ClassNotFoundException, SQLException {
        if (connection == null) {
            Class.forName("com.mysql.jdbc.Driver");
            String url = "jdbc:mysql://" + _host + ":" + _port + "/" + _db + "";
            connection = DriverManager.getConnection(url , _user, _pass);
        }
        return connection;
    }
  }

Some database works in workbench, before that I was working on a local database. Now I have an error like this:

Access denied for user 'sql8167592'@'host-79.173.28.129.tesatnet.pl' (using password: YES)

Tambet-Telvis Tanilsoo · Accepted Answer · 2017-04-05 15:20:59Z

1

You need to execute following line on your MySQL server.

ALTER USER 'your username'@'your ip' IDENTIFIED BY 'your password';

EDIT: Remove your MySQL server ip, username and password from your question!!!

answered Apr 5, 2017 at 15:20

Tambet-Telvis Tanilsoo

386 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Carlos · Accepted Answer · 2017-04-05 15:13:22Z

1

Ensure the user exists in the database and the credentials are ok, if it is saying access denied, it means that the url is correct and there is a mysql server in that address

answered Apr 5, 2017 at 15:13

Carlos

713 bronze badges

Collectives™ on Stack Overflow

Using online mysql database with java

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related