This is a draft cheat sheet. It is a work in progress and is not finished yet.
Install Mariadb-Server
sudo apt install mariadb-server |
sudo mysql_secure_installation |
sudo mariadb |
CREATE DATABASE example_database; |
ALTER DATABASE test CHARACTER SET='utf8' COLLATE='utf8_bin'; |
GRANT ALL ON example_database.* TO 'example_user'@'localhost' IDENTIFIED BY 'password' WITH GRANT OPTION; |
FLUSH PRIVILEGES; |
exit |
sudo mariadb |
mariadb -u example_user -p |
SHOW DATABASES; |
|
Basic Mariadb Commands
Log into DB |
sudo systemctl enable mysql |
| |
sudo systemctl restart mysql |
| |
sudo mysql -u root -p |
Basic Queries
select user from mysql.user; |
| displays all database users |
show grants for 'zabbix'@'locahosts' |
| displays user privileges |
set password for 'zabbix'@'localhost = password ('zabbix'); |
|
|
|
