Coral: mysql edit restricted user
MySQL Edit Restricted User There are three methods for editing a restricted user; you can use a command window, phpMyAdmin or UniController. UniController provides a convenient menu option described bellow. To use this option ensure the MySQL server is running otherwise a warning message is produced.
|
|
Edit Restricted MySQL User using UniController
Server Configuration > MySQL > Edit Restricted MySQL User
Edit Restricted User
Delete Restricted User
Note 1: Cancel (8) and (9) clear both the edit fields and the user selection. |
Edit Restricted MySQL User using phpMyAdmin
Start UniController and start both servers, then click phpMyAmin button. To edit a restricted user, proceed as follows:
Note: Assume the user fred has already been created.
When first started the phpMyAdmin home page is displayed; you can always return to this page by clicking the home icon (1)
The Edit Privileges: User 'fred'@'localhost' page is displayed. |
Edit Restricted MySQL User using command window
Editing an existing user with restricted privileges can be performed using the MySQL Client.
You can use REVOKE to remove some or all privileges or alternatively use GRANT to add additional privileges. This example assumes a user fred has been created with the privileges GRANT SELECT, INSERT, UPDATE, DELETE assigned on database wordpress. You can revoke (remove) privileges; for example, the following command removes INSERT, UPDATE and DELETE.
- REVOKE INSERT, UPDATE, DELETE ON wordpress.* FROM 'fred'@'localhost' ;
You can grant (add) privileges; for example, the following command adds INSERT and UPDATE.
- GRANT INSERT, UPDATE ON wordpress.* TO 'fred'@'localhost' ;
You can display the grants assigned with the following command:
- SHOW GRANTS FOR 'fred'@'localhost';
Example for the above commands. Click MySQL console, which opens a command window. Then we run the MySQL Client with the following commands:
- mysql -uroot -proot
- SHOW GRANTS FOR 'fred'@'localhost';
- REVOKE INSERT, UPDATE, DELETE ON wordpress.* FROM 'fred'@'localhost' ;
- SHOW GRANTS FOR 'fred'@'localhost';
- GRANT INSERT, UPDATE ON wordpress.* TO 'fred'@'localhost' ;
- SHOW GRANTS FOR 'fred'@'localhost';
- exit
The results are shown below.
C:\UniServer\usr\local\mysql\bin>mysql -uroot -proot mysql> SHOW GRANTS FOR 'fred'@'localhost'; +-------------------------------------------------------------------------------------------------------------+ | Grants for fred@localhost | +-------------------------------------------------------------------------------------------------------------+ | GRANT USAGE ON *.* TO 'fred'@'localhost' IDENTIFIED BY PASSWORD '*F5F0B28BD93FCF0C77FD96BB97BBC745ED8EA6BC' | | GRANT SELECT, INSERT, UPDATE, DELETE ON `wordpress`.* TO 'fred'@'localhost' | +-------------------------------------------------------------------------------------------------------------+ 2 rows in set (0.00 sec) mysql> REVOKE INSERT, UPDATE, DELETE ON wordpress.* FROM 'fred'@'localhost' ; Query OK, 0 rows affected (0.02 sec) mysql> SHOW GRANTS FOR 'fred'@'localhost'; +-------------------------------------------------------------------------------------------------------------+ | Grants for fred@localhost | +-------------------------------------------------------------------------------------------------------------+ | GRANT USAGE ON *.* TO 'fred'@'localhost' IDENTIFIED BY PASSWORD '*F5F0B28BD93FCF0C77FD96BB97BBC745ED8EA6BC' | | GRANT SELECT ON `wordpress`.* TO 'fred'@'localhost' | +-------------------------------------------------------------------------------------------------------------+ 2 rows in set (0.00 sec) mysql> GRANT INSERT, UPDATE ON wordpress.* TO 'fred'@'localhost' ; Query OK, 0 rows affected (0.01 sec) mysql> SHOW GRANTS FOR 'fred'@'localhost'; +-------------------------------------------------------------------------------------------------------------+ | Grants for fred@localhost | +-------------------------------------------------------------------------------------------------------------+ | GRANT USAGE ON *.* TO 'fred'@'localhost' IDENTIFIED BY PASSWORD '*F5F0B28BD93FCF0C77FD96BB97BBC745ED8EA6BC' | | GRANT SELECT, INSERT, UPDATE ON `wordpress`.* TO 'fred'@'localhost' | +-------------------------------------------------------------------------------------------------------------+ 2 rows in set (0.00 sec) mysql> exit Bye