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
gefragt vor 4 Jahren260 Aufrufe
1 Antwort
0

i figured it out and resolved the issue

qcap
beantwortet vor 4 Jahren

Du bist nicht angemeldet. Anmelden um eine Antwort zu veröffentlichen.

Eine gute Antwort beantwortet die Frage klar, gibt konstruktives Feedback und fördert die berufliche Weiterentwicklung des Fragenstellers.

Richtlinien für die Beantwortung von Fragen