Table of Contents

Quelques commandes MySQL

Créer BDD

create database creaphilie
use crea_bd
GRANT ALL PRIVILEGES ON crea_bd.* TO 'usr_crea_bdd'@'localhost' IDENTIFIED BY 'jM1fh7~8' WITH GRANT OPTION;

Import d'un dump sql volumineux via la CLI

MYSQL_PWD=`cat /etc/psa/.psa.shadow` mysql -uadmin YOUR_EXISTENT_DATABASE_NAME < /COMPLETE/PATH/TO/YOUR/DATADASE_DUMP.sql