AWS EC2 MySql server Remote Access Ubuntu 18 04 MySql 5 7 38

Configure AWS ec2 ubuntu 18.04 instance for MySql server 5.7.38 for remote access via MySql Workbench or any mysql client like php, node js etc
sudo su
apt update
apt upgrade -y
apt install mysql-server -y
mysql_secure_installation
///////////
mysql
SELECT user,authentication_string,plugin,host FROM mysql.user;
ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY 'your_password';
/////////////////////
nano /etc/mysql/mysql.conf.d/mysqld.cnf
bind-address = 0.0.0.0
systemctl restart mysql
mysql -u root -p
CREATE USER 'admin'@'%' IDENTIFIED WITH mysql_native_password BY 'your_password';
GRANT CREATE, ALTER, DROP, INSERT, UPDATE, DELETE, SELECT, REFERENCES, RELOAD on . TO 'admin'@'%' WITH GRANT OPTION;
FLUSH PRIVILEGES;
exit

[@vinnialves5367]

Nice video thanks very much.
Portugues Br: Mesmo sendo em ingles o video é bem explicativo e funcional, obrigado pelos ensinamentos ajudou muito para o que eu precisava.

[@EddieMao]

Great video, bro, thanks for sharing it.