===== 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