Sysop:MySQL: Unterschied zwischen den Versionen

Aus immerda
Zur Navigation springen Zur Suche springen
Zeile 1: Zeile 1:
== cluster ==
* http://www.lod.com/whitepapers/mysql-cluster-howto.html
== adding new user accounts ==
== adding new user accounts ==
* http://dev.mysql.com/doc/refman/5.0/en/adding-users.html
* http://dev.mysql.com/doc/refman/5.0/en/adding-users.html

Version vom 10. April 2007, 10:30 Uhr

cluster

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';