User Administration

• MySQL users and their privileges are normally created with the GRANT command

• mysql> grant select on test.* to testguy@localhost identified by 'testpass'

• Query OK, 0 rows affected (0.00 sec)

• REVOKE will remove privileges but leave user record in mysql.user (you must DELETE the users to completely remove them)

Notes: