< MySQL
Content added Content deleted
imported>mutante mNo edit summary |
imported>mutante mNo edit summary |
||
| (8 intermediate revisions by 3 users not shown) | |||
Line 1:
->[[MySQL]]->Create User
Dont use mysql-root because of lazyness ;)▼
▲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".:
Line 13 ⟶ 15:
Give permissions to the user "fnord" on all tables of the db "grudnuk":
<pre>
GRANT SELECT, INSERT, UPDATE, DELETE, CREATE, DROP
ON grudnuk.* TO fnord;
</pre>
Line 20 ⟶ 22:
FLUSH PRIVILEGES;
</pre>
[[Category:Computer]]
[[Category:Programs]]
| |||
Latest revision as of 21:15, 24 October 2006
->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;