how to connect to an mysql comm server 5.7 on ec2 from another ec2 instance

0

I have installed mysql community server 5.7 on2 different ec2 instance. As root user created a user on server1 to allow access from the the other ec2 instance. (create user 'xxx'@'yy.yy.yy.yy' identified by 'zzzz' ; grant all privileges on dbxxx to xxx'@'yy.yy.yy.yy';)
bind address is set to 0.0.0.0 in /etc/my.cin -> mysqld on server 1
when i try this command from server 2 to connect to server 1 mysql -u xxx -p -h server1IP and enter my password, the cursor just sits blinking and steady. beyond that nothing happens.

Not sure what i have missed or not done to get this working

Thanks for any help

qcap

Edited by: qcap on Mar 13, 2020 11:26 AM

qcap
已提問 4 年前檢視次數 230 次
1 個回答
0

i figured it out and resolved the issue

qcap
已回答 3 年前

您尚未登入。 登入 去張貼答案。

一個好的回答可以清楚地回答問題並提供建設性的意見回饋,同時有助於提問者的專業成長。

回答問題指南