Create user database mysql

CREATE USER ‘blogs’@’localhost’ IDENTIFIED BY ‘PASSWORD’;

CREATE DATABASE blogs ;

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

FOR REMOTELY:

GRANT ALL ON *.* to 'blogs'@'%' IDENTIFIED BY 'password' WITH GRANT OPTION;

FLUSH PRIVILEGES;

GRANT ALL PRIVILEGES ON blogs.localhost TO ‘blogs‘@’%’;