Mysql database hacking

GRANT ALL PRIVILEGES ON database_name.* TO ‘database_user’@’localhost’;

over all databases: GRANT ALL PRIVILEGES ON . TO ‘database_user’@’localhost’; link

CREATE DATABASE prestashop;
GRANT ALL ON prestashop.* TO 'prestashop'@'localhost' IDENTIFIED BY 'change-with-strong-password';

export with dump
mysqldump -u YourUser -p YourDatabaseName > wantedsqlfile.sql

import sql database, on an already created emtpy database
mysql -u username -p -h localhost DATA-BASE-NAME < data.sql

DROP USER ‘bloguser’@’localhost’;

DROP DATABASE mywpblog;

SELECT User,Host FROM mysql.user;