MySQL dump/create database and grant all privileges to specific user

gistfile1.txt

mysqldump -uroot databasename > database.sql

mysql create database databasename DEFAULT CHARACTER SET utf8 DEFAULT COLLATE utf8_general_ci;

Option1
=======
$ mysqldump yourFirstDatabase -u user -ppassword > yourDatabase.sql
$ mysql yourSecondDatabase -u user -ppassword < yourDatabase.sql

Option2
=======
use databasename;
set autocommit = 0;
source database.sql;
commit;

mysql -uroot;
grant all on *.* to 'joomla_user'@'localhost';
flush privileges;
exit;