MySQL/Create User

->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";)

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;