Central Indiana Linux Users Group
User: Guest Log in |  Join
MySQL Presentation
First page Back Continue Last page Overview Graphics

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:

Apr. 1, 2004 2:54 pm US/Eastern