MySQL/Create User

From S23Wiki

->MySQL->Create User

Dont use mysql-root because of lazyness ;) (set root pw with UPDATE mysql.user SET Password=PASSWORD("new_password") WHERE User="root";) -> MySQL#Setting_the_initial_root_password

Create a new user "fnord" with password "foobar".:

INSERT INTO mysql.user (user, host, password)
   VALUES ('fnord', 'localhost', PASSWORD('foobar'));

Create a new database "grudnuk":

CREATE DATABASE grudnuk;

Give permissions to the user "fnord" on all tables of the db "grudnuk":

GRANT SELECT, INSERT, UPDATE, DELETE, CREATE, DROP
   ON grudnuk.* TO fnord;

Dont forget to update permissions:

FLUSH PRIVILEGES;