Category: Raindrop

create database DatabaseName;

create user 'User'@'localhost' identified by 'Password';

create database Database;

grant all on Database.* to 'User'@'localhost';

show grants;

show grants for 'User'@'Host'

grant all on Database.* to 'User'@'Host';

grant alter, alter routine, create, create routine, create temporary tables, create view, delete, drop, event, execute, index, insert, lock tables, references, select, show view, trigger, update on Database.* to 'User'@'Host';

create user 'User1'@'localhost', 'User2'@'Host', 'User3' identified by 'Password';

select * from mysql.user where user='User'\G;

drop user 'User1'@'localhost', 'User2'@'Host', 'User3'@'%';

curl https://ipinfo.io/ip

sudo sed -i.bak -e '0,/127.0.0.1/s//0.0.0.0/' /etc/mysql/mysql.conf.d/mysqld.cnf

sudo systemctl restart mysql

update mysql.user set host='%' where user='User';

sudo ufw allow mysql && sudo ufw reload && sudo ufw status

mysql --host=Host --user=User --password=Password

show variables where variable_name='port'