-- Create USER

-- CREATE USER 'user1'@localhost IDENTIFIED BY 'password1';

CREATE USER blog_admin@'%' IDENTIFIED BY 'pass@1234';

GRANT ALL PRIVILEGES ON blogDB.* TO blog_admin@'%';

SHOW GRANTS FOR blog_admin@'%';

FLUSH PRIVILEGES


-- Create Counter Table

-- DROP TABLE PostVisitCounter

-- create table PostVisitCounter (id INT(20) NOT NULL AUTO_INCREMENT PRIMARY KEY, siteid nvarchar(500), postid nvarchar(500), count INT(20), datecreated TIMESTAMP, datemodified TIMESTAMP);