M

Mysql

Login to mysql

mysql -u root
mysql -u root -p: login with password

Use database

show databases;
user $databasename;

Create and Delete user

CREATE USER ‘$user’@’$host’ IDENTIFIED BY ‘$password’;
View created users: Select user from mysql.user;
Change password: ALTER USER ‘$user’@’$host’ IDENTIFIED BY ‘$newpassword’;
DROP USER ‘$user’@’$host’
After delete user, update status: FLUSH PRIVILEGES;

Grant Permission

GRANT ALL PRIVILEGES ON *.* TO ‘user1’@localhost IDENTIFIED BY ‘password1’;
GRANT ALL PRIVILEGES ON ‘yourDB’.* TO ‘user1’@localhost;
FLUSH PRIVILEGES;
SHOW GRANTS FOR ‘user1’@localhost;

Create Table

CREATE TABLE $Name ( $columnname $datatype($length))
Example: CREATE TABLE Content (Output Text(4096));

Reference

https://phoenixnap.com/kb/how-to-create-mariadb-user-grant-privileges