MYSQL Installation and Grant Privilege

apt update -y
apt install mysql-server
systemctl start mysql.service
systemctl enable mysql.service

change bind address to 0.0.0.0 and then restart mysql

CREATE USER 'mictrio'@'%' IDENTIFIED BY 'Password';

GRANT CREATE, ALTER, DROP, INSERT, UPDATE, DELETE, SELECT, REFERENCES, RELOAD on *.* TO 'mictrio'@'%' WITH GRANT OPTION;

FLUSH PRIVILEGES;

ALTER USER 'mictrio'@'%' IDENTIFIED WITH mysql_native_password BY 'Password';
FLUSH PRIVILEGES;

nano /etc/mysql/mysql.conf.d/mysqld.cnf
and uncomment line and add 700 as max connection
max_connections = 700

Comments :

No Comments.