Add/Remove User MySQL / MariaDB (Common)

README.md

Add User Spesification Database

CREATE USER 'STRING-USER'@'localhost' IDENTIFIED BY 'STRING-PASSWORD';
GRANT ALL PRIVILEGES ON STRING-DATABASE.* TO 'STRING-USER'@'localhost';
FLUSH PRIVILEGES;
\q

Add User Anything Database

CREATE USER 'STRING-USER'@'localhost' IDENTIFIED BY 'STRING-PASSWORD';
GRANT ALL PRIVILEGES ON * . * TO 'STRING-USER'@'localhost';
FLUSH PRIVILEGES;
\q

Change Password

USE mysql;
UPDATE USER SET password=PASSWORD("STRING-PASSWORD") where User='STRING-USER';
__Or__
SET PASSWORD FOR 'STRING-USER'@'localhost' = PASSWORD('STRING-PASSWORD');
FLUSH PRIVILEGES;
\q

Delete User

DROP USER 'STRING-USER'@'localhost';

Change Privileges

SELECT user,host FROM mysql.user;
SHOW GRANT FOR 'STRING-USER'@'localhost';
REVOKE ALL PRIVILEGES ON *.* FROM 'STRING-USER'@'localhost';
GRANT ALL PRIVILEGES ON STRING-DATABASE.* TO 'STRING-USER'@'localhost';
FLUSH PRIVILEGES;
\q