< MySQL
Content added Content deleted
No edit summary |
imported>mutante mNo edit summary |
||
Line 1: | Line 1: | ||
->[[MySQL]]->Create User |
|||
Dont use mysql-root because of lazyness ;) |
Dont use mysql-root because of lazyness ;) |
||
Revision as of 15:40, 27 February 2006
->MySQL->Create User
Dont use mysql-root because of lazyness ;)
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;