Site Migration

https://www.interserver.net/tips/kb/migrate-wordpress-site-localhost-ubuntu-vps

sudo mysql

mysql> CREATE DATABASE  dbname;

mysql> DROP USER 'dbuser'@'localhost';

mysql> CREATE USER 'dbuser'@'localhost' IDENTIFIED BY 'password';

mysql> SELECT user, host FROM mysql.user;
+------------------+-----------+
| user             | host      |
+------------------+-----------+
| debian-sys-maint | localhost |
| mysql.infoschema | localhost |
| mysql.session    | localhost |
| mysql.sys        | localhost |
| root             | localhost |
| dbuser           | localhost |
+------------------+-----------+
6 rows in set (0.00 sec)

mysql> GRANT ALL PRIVILEGES ON dbname.* TO 'dbuser'@localhost WITH GRANT OPTION;
mysql> FLUSH PRIVILEGES;
mysql> \q

mysql -u dbname -p dbuser < ./dbexportfile.sql