Mariadb handy commands

User management

When creating user make use you replace localhost to the ip
the client can access from or add % if you allow global access

1

CREATE USER 'username'@'localhost' IDENTIFIED BY 'strong_password';

1

ALTER USER username WITH PASSWORD 'new_password';

1

DROP USER IF EXISTS username;

1
2


GRANT ALL PRIVILEGES ON my_database.* TO 'username'@'localhost';
FLUSH PRIVILEGES;

1
2
3


GRANT SELECT ON my_database.table1 TO 'username'@'localhost';
GRANT SELECT ON my_database.table2 TO 'username'@'localhost';
FLUSH PRIVILEGES;

1

CREATE DATABASE database_name;