asked on

cannot connect to mysql database on droplet server on port 3306

I can connect from local but cannot connect from my company.

I tried to use "telnet xxx.xxxx.xxx.xxx 3306" but got rejected. Is this the corporation firewall blocked my connection?

I am able to connect to the MYSQL RDS on Amazon AWS.

Swadhin Ray

Using SSH Tunneling you should be able to connect from your local .

Jason Yu

ASKER

it's still not accessible, I used the following command to create the user account and assign privilege.

CREATE USER 'phpconnector'@'*' identified by 'XXXXX';
GRANT ALL PRIVILEGES ON user_login.* to 'phpconnector'@'*';

Jason Yu

ASKER

mysql> select Host,User,Select_priv from user;
+----------------+--------------+-------------+
| Host | User | Select_priv |
+----------------+--------------+-------------+
| localhost | root | Y |
| localhost | mysql.sys | N |
| localhost | phpconnector | N |
| 104.172.53.39 | jasonyu | N |
| 198.199.89.211 | phpconnector | N |
| localhost | yijiama | Y |
| 63.138.193.186 | phpconnector | N |
| * | phpconnector | Y |
+----------------+--------------+-------------+
8 rows in set (0.00 sec)

mysql>

Swadhin Ray

first you have to establish a connection

ASKER CERTIFIED SOLUTION

Swadhin Ray

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

SOLUTION