MySQL

sudo apt install mysql-server

sudo mysql_secure_installation

sudo mysql

CREATE DATABASE example_database;

CREATE USER 'example_user'@'%' IDENTIFIED WITH mysql_native_password BY 'password';

GRANT ALL ON example_database.* TO 'example_user'@'%';

exit

mysql -u example_user -p

SHOW DATABASES;

ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY 'password';

mysqldump -u root -h 127.0.0.1 -P 33060 -p databse_name>dump.sql

mysql -u root -h 127.0.0.1 -P 33060 -p database_name<dump.sql

RENAME USER 'aiopay'@'172.31.35.120' TO 'aiopay'@'172.31.%.%';
FLUSH PRIVILEGES;