Enable remote access to database without SSH

I am actually running MariaDB (10.1.19) and has also tried following this guide: https://mariadb.com/kb/en/mariadb/configuring-mariadb-for-remote-client-access/

I have:

1. commented out bind-address
2. created a user with access to the database
3. opened up port 3306 in the Forge interface

But I still get no access to the database when trying to connect from Sequel Pro using only username / password.

If you're using aws, etc, did you open the port up in a policy (on aws, not forge)?

I am not using AWS, but I am using a server in our own data center.

I don't know that much about server configuration, but could there be something else in front of my server, that I need to configure?

Here the values from:

ufw status:

3306                       ALLOW       Anywhere 
3306 (v6)                  ALLOW       Anywhere (v6)  

sudo netstat -ntlup | grep mysql

tcp6       0      0 :::3306                 :::*                    LISTEN      6213/mysqld

@troelsjohnsen Did you get this working?

@troelsjohnsen Please let us know if you find a solution, i am also stuck. i am also using Amazon EC2 via Laravel Forge. :|

I can't actually remember how I solved this issue, but I think it was related to another firewall in front of the server I was trying to connect to.

So I had to configure the firewall through the Forge dashboard, but also the firewall in front of the server.

I cannot connect to my EC2 database no matter what I try! My public key is added to Forge and I can ssh into the Forge server using my private key in Terminal. I try to connect using my private key in MySQL Workbench and no matter what I try I get the following message...

"Access denied. Authentication that can continue: publickey".

I have searched Google for hours and have found nothing that helps. Any additional assistance would be greatly appreciated!

The database is in your ec2?

If so you will be able to access the database. Take a look on the link below.

https://vannstudios.com/connecting-mysql-database-engine-on-amazon-ec2-from-mysql-workbench

Thank you for the response! It ended up being a MySQL Workbench issue. Not sure what because I downloaded Sequel Pro and connected with no issues. Thanks again!