Free Software Server Environment: MySql User Accounts

Revision [411]

Most recent edit made 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
MySqlAdministration

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)

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 edited on 2006-09-01 06:00:58 by FsseInfo

MySql User Accounts

You can add users using GRANT

Add User

mysql> GRANT ALL PRIVILEGES ON *.* TO 'newuser'@'localhost' IDENTIFIED BY 'newpassword' WITH GRANT OPTION;

Insert & Flush

You can also insert users but must always flush privileges before changes take effect

mysql> INSERT INTO user VALUES('%','newuser',PASSWORD('newpass'),'Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y');
mysql> FLUSH PRIVILEGES;

Update Password & Flush

You can also update users but must always flush privileges before changes take effect

mysql> update user set password = PASSWORD('newpass') where user = 'user' ;
mysql> FLUSH PRIVILEGES;