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년 전249회 조회
1개 답변
0

i figured it out and resolved the issue

qcap
답변함 3년 전

로그인하지 않았습니다. 로그인해야 답변을 게시할 수 있습니다.

좋은 답변은 질문에 명확하게 답하고 건설적인 피드백을 제공하며 질문자의 전문적인 성장을 장려합니다.

질문 답변하기에 대한 가이드라인

관련 콘텐츠