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
posta 4 anni fa259 visualizzazioni
1 Risposta
0

i figured it out and resolved the issue

qcap
con risposta 4 anni fa

Accesso non effettuato. Accedi per postare una risposta.

Una buona risposta soddisfa chiaramente la domanda, fornisce un feedback costruttivo e incoraggia la crescita professionale del richiedente.

Linee guida per rispondere alle domande