Forum Post

Linux Adding a mysql user

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