Home / Questions / 22448
Accepted
Oscar E. Alvarado
Asked: 2020-09-03 09:25:51 +0800 CST 2020-09-03 09:25:51 +0800 CST

How to connect mysql user to an AWS server?

  • 772

I am using AWS and I have just installed mysql in an EC2 environment with ubuntu 14, I have created my root user with which I can connect via SSH normally, but I have created another user with grant all privileges so that another person can upload changes to a DB and I have tried to connect through a standard mode with the public dns of my EC2 but it rejects me. What am I doing wrong? Do I need to configure something?... I have opened the respective port 3306 in my security group assigned to my EC2. I hope you can help me

mysql

2 Answers

  1. You have to have these considerations:

    • Add an input rule in your security group of your EC2 instance to port 3306
    • Make sure in your mysql my.conf file you have the bind-address parameter set to 0.0.0.0 (listen to all ip addresses)
    • If you did the previous point restart the mysql service (# service mysqld restart)
    • Create a mysql user "create user [name]@'%' ... the % is important as it indicates that the user can access from any IP address

    With all of the above you shouldn't have any problems, at point 2 you can do a

    $ telnet [dirección ip] 3306

    to check if the port is listening remotely

    • 2
  2. Best Answer

    It looks like you haven't changed the default listening address of your MySQL, check your my.cnf to see if it has the following value:

    bind-address = 127.0.0.1

    If you have it, comment it and restart.

    Another Solution, SSH Tunneling: Something you can do to remotely connect to a MySQL server without opening any ports is to use an SSH tunnel.

    Something like this on Linux:

    ssh -fNg -L 9999:127.0.0.1:3306 [email protected]

    This will enable port 9999 on your local machine as a "tunnel" to remote port 3306 on your local server.

    For Windows, maybe using Putty you can get it too:

    Take a look at this: http://www.ytechie.com/2008/05/set-up-a-windows-ssh-tunnel-in-10-minutes-or-less/

    Most graphical clients for MySQL allow connections through tunneling, such as MySQL WorkBench.

    https://www.mysql.com/products/workbench/

    • 1