Mysql-install

MySQL

sudo yum install -y https://repo.percona.com/yum/percona-release-latest.noarch.rpm
sudo percona-release setup ps80
sudo yum install percona-server-server
systemctl edit mysql

[Service]
LimitNOFILE = 262144

How to turn off mysql password validation?

set global validate_password.policy = LOW;
set global validate_password.length = 2;
set global validate_password.mixed_case_count = 0;
set global validate_password.number_count = 0;
set global validate_password.special_char_count = 0;

Create super user

GRANT ALL PRIVILEGES ON *.* TO 'admin'@'%' WITH GRANT OPTION;
FLUSH PRIVILEGES;

Create user

CREATE USER 'user'@'%' IDENTIFIED BY '<password>;
CREATE USER 'some_user'@'somehost.somedomain' IDENTIFIED BY '<password>';

Delete user

DROP USER 'some_user'@'somehost.somedomain';

Grant permissions

GRANT SELECT ON `some_db`.* TO 'some_user'@'somehost.somedomain';
FLUSH PRIVILEGES; 

Show permissions

SHOW GRANTS FOR 'someuser'@'somehost.somedomain';

Revoke permissions

REVOKE SELECT ON `somedb`.* FROM 'someuser'@'somehost';
REVOKE ALL PRIVILEGES ON `somedb`.* FROM 'someuser'@'somehost';
REVOKE ALL PRIVILEGES, GRANT OPTION FROM 'someuser'@'somehost';

Change password

ALTER USER 'test_user'@'localhost' IDENTIFIED BY '<password>';