Coral: mysql edit restricted user

From The Uniform Server Wiki
Revision as of 13:40, 12 November 2011 by Ric (talk | contribs) (Created page with "<div id="top" style="margin:0;padding: 0px 0px 0px 5px; color: #000; background-color: #FFFFEB; border: 1px solid darkslateblue;"><span id="top" style="margin:0;padding: 0px;font...")
(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
Jump to navigation Jump to search

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.


UniServer 8-Coral
  Home
  Quick Start
  General
  Apache
» MySQL
  PHP
  MSMTP
  CRON
  DtDNS
  Db Backup
  Perl
  Main Index

Edit Restricted MySQL User using UniController

Server Configuration > MySQL > Edit Restricted MySQL User

Edit Restricted User

  • 1) Select user to edit from the list, which populates the upper form
  • 3) Enter the old or a new password for the user
  • 5) Select or deselect user privileges as required
  • 6) Click "Update User" button

Delete Restricted User

  • 1) Select user to be deleted from the list.
  • 7) Click "Delete" button

Note 1: Cancel (8) and (9) clear both the edit fields and the user selection.

Top

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)

  • 1) If not at the home page, click home icon
  • 2) From the top menu bar, select Privileges
  • 3) Under "Action", Click Edit Privileges

The Edit Privileges: User 'fred'@'localhost' page is displayed.
From this page you can change the user privileges, the database(s)
the user is assigned to and privileges, password and login information.

Top

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

Top Related topics

MySQL Console

Top