Do this as root in mysql

• create user 'user1'@'localhost' identified by 'pass1';
• grant select,insert,update,delete on .* to 'user1'@'localhost';
• flush privileges;

the following grants all

• grant all on database.* to 'user1'@'localhost';
• flush privileges;

Obviously user1 and pass1 are the actual user and password!

Remove a user

• drop user 'user1';
• flush privileges;

then remove the associated databases from the db column in mysql using phpmyadmin

To get the cronjob to work without throwing errors you will need to edit ~/.my.cnf

[client]
user = your_db_username
password = "your_db_password"
host = localhost

06/01/2017 05:31:09 AM Jamie General