Sysop:MySQL: Unterschied zwischen den Versionen
Zur Navigation springen
Zur Suche springen
Mh (Diskussion | Beiträge) (Die Seite wurde neu angelegt: == adding new user accounts == * http://dev.mysql.com/doc/refman/5.0/en/adding-users.html <pre> mysql> GRANT ALL PRIVILEGES ON *.* TO 'monty'@'localhost' -> IDE...) |
Mh (Diskussion | Beiträge) |
||
| Zeile 9: | Zeile 9: | ||
mysql> GRANT USAGE ON *.* TO 'dummy'@'localhost'; | mysql> GRANT USAGE ON *.* TO 'dummy'@'localhost'; | ||
</pre> | </pre> | ||
[[Category:ImmmerdaProjectGroup]] | |||
Version vom 9. März 2007, 16:45 Uhr
adding new user accounts
mysql> GRANT ALL PRIVILEGES ON *.* TO 'monty'@'localhost'
-> IDENTIFIED BY 'some_pass' WITH GRANT OPTION;
mysql> GRANT ALL PRIVILEGES ON *.* TO 'monty'@'%'
-> IDENTIFIED BY 'some_pass' WITH GRANT OPTION;
mysql> GRANT RELOAD,PROCESS ON *.* TO 'admin'@'localhost';
mysql> GRANT USAGE ON *.* TO 'dummy'@'localhost';