Connect to a live database with MySQL Workbench

Question

I've a question to the mySQL Workbench.

I want to connect to the mysql DB at the domain aaa.com. I write at the connection options these dates:

Hostname: www.aaa.com
Port: Which port do i have to write in?
Username: Username of the DB (which is 100% correct)
Password: Password of the DB (which is 100% correct)
Default Schema: Name of the DB (which is 100% correct)

If I click connect there is following error:

"Access denied"

Answer 1

Also you can ssh tunnel:

Create a new connection, select Standard TCP/IP over SSH.

For SSH host name enter your domain aaa.com (the domain you would SSH to).

For SSH username enter your SSH username, so if if you ssh test_user@aaa.com your user is test_user.

Store your SSH password or key files, which ever you use.

The Mysql hostname should be 127.0.0.1 if the mysql server is on the server you are SSH'ing to, else the IP or host name of you Mysql server.

Mysql server user - your mysqsl user.

And your Mysql server password.

This way your database isn't externally acceptable, meaning no one can trying to access it from outside your server on port 3306, but you still have access it through Workbench

Answer 2

Generally, for security reasons, the incoming connections from external domains will be disabled. Contact your host if that is allowed.

By the way, the default port of MySQL is 3306.

---

If you have root access to phpMyAdmin, you can see if the port is opened using this tutorial: Install MySQL and enable remote access.

Answer 3

Contact your web hosting company to make sure they allow remote connections first. It's disabled by some hosts. Default port will be 3306.