MySQL create DB, USER, Restore

root@wmstreampro:~/# mysql -u root -p
Enter password: 
MariaDB [(none)]> create database DBNAME;
MariaDB [(none)]> CREATE USER 'USER'@'localhost' IDENTIFIED BY 'PASS';
MariaDB [(none)]> GRANT ALL PRIVILEGES ON DBNAME.* TO 'USER'@'localhost';
MariaDB [(none)]> FLUSH PRIVILEGES;
MariaDB [(none)]> SHOW GRANTS FOR 'DBNAME'@'localhost';
MariaDB [(none)]> quit
root@wmstreampro:~/# mysql -u root -p < site_backup.sql
Enter password: