FsseInfo: MySql User Accounts

Revision [411]

Last edited on 2007-09-20 11:28:56 by FsseInfo

Additions:

==You can add users right using GRANT==
Add User (usage only, all privs, full rights)
mysql> GRANT USAGE ON * . * TO 'myuser'@'myhost' ;
mysql> GRANT ALL PRIVILEGES ON * . * TO 'myuser'@'myhost' IDENTIFIED BY 'newpass' ;
mysql> GRANT ALL PRIVILEGES ON * . * TO 'myuser'@'myhost' IDENTIFIED BY 'newpass' WITH GRANT OPTION ;
==You can remove users rights using REVOKE==
Remove User (usage only, all privs, full rights)
mysql> revoke all on * . * from 'myuser'@'myhost' ;
----
REFERRERS
{{backlinks}}

Deletions:

You can add users using GRANT
==Add User (usage only, all privs, full rights)==
mysql> GRANT USAGE ON *.* TO 'myuser'@'myhost' ;
mysql> GRANT ALL PRIVILEGES ON *.* TO 'myuser'@'myhost' IDENTIFIED BY 'newpass' ;
mysql> GRANT ALL PRIVILEGES ON *.* TO 'myuser'@'myhost' IDENTIFIED BY 'newpass' WITH GRANT OPTION ;

Revision [285]

Edited on 2006-12-11 05:45:14 by FsseInfo

Additions:

==Add User (usage only, all privs, full rights)==
mysql> GRANT USAGE ON *.* TO 'myuser'@'myhost' ;
mysql> GRANT ALL PRIVILEGES ON *.* TO 'myuser'@'myhost' IDENTIFIED BY 'newpass' ;
mysql> GRANT ALL PRIVILEGES ON *.* TO 'myuser'@'myhost' IDENTIFIED BY 'newpass' WITH GRANT OPTION ;

Deletions:

==Add User==
mysql> GRANT ALL PRIVILEGES ON *.* TO 'myuser'@'myhost' IDENTIFIED BY 'newpass' WITH GRANT OPTION;

Revision [78]

Edited on 2006-09-01 08:45:48 by FsseInfo

Additions:

mysql> GRANT ALL PRIVILEGES ON *.* TO 'myuser'@'myhost' IDENTIFIED BY 'newpass' WITH GRANT OPTION;
mysql> UPDATE user SET password = PASSWORD('newpass') WHERE user = 'user' ;

Deletions:

mysql> GRANT ALL PRIVILEGES ON *.* TO 'newuser'@'localhost' IDENTIFIED BY 'newpassword' WITH GRANT OPTION;
mysql> update user set password = PASSWORD('newpass') where user = 'user' ;

Revision [68]

The oldest known version of this page was created on 2006-09-01 06:00:58 by FsseInfo