Mémo rapide pour mySQL

mysql -u uname -p -e "CREATE DATABASE new_name_of_database"
mysqldump -u uname -p old_name_of_database> BackupFile.sql
mysql -u root -p new_name_of_database <BackupFile.sql
mysql -u name -p -e "DROP DATABASE old_name_of_database"

GRANT ALL PRIVILEGES ON `maBdD`.* TO `user1`@`localhost`;