Quelques commandes de MariaDB/ MySQL

sudo mysql -u root -p
use zabbix;
show databases;
create user zabbix@localhost identified by 'password';
create database zabbix character set utf8 collate utf8_bin;
select count(*) from items;
show processlist;

show variables like 'open_files_limit';
uses wordpress ;

Commande dans une procédure :
sudo mysql -uroot -p'xxxxxx' -e "CREATE DATABASE wordpress"