Setup mysql 8 for Ghost blog

cmd.sh

mysqldump -u root -p my_blog_prod > db_backup.sql

mysql -u my_blog_user -p my_blog_prod < db_backup.sql

my.sql

CREATE DATABASE my_blog_prod CHARACTER SET utf8 COLLATE utf8_general_ci;
show databases;
CREATE USER 'my_blog_user'@'localhost' IDENTIFIED BY 'myPassword';
SET GLOBAL validate_password.policy = 0; 
GRANT ALL PRIVILEGES ON my_blog_prod.* TO 'my_blog_user'@'localhost';
ALTER USER 'my_blog_user'@'localhost' IDENTIFIED WITH mysql_native_password BY 'myPassword';
FLUSH PRIVILEGES;