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

User Administration

  • DELETE FROM mysql.user WHERE user='user2Bdeleted'; (Will delete the user2Bdeleted user from the accepted users for the database

  • FLUSH PRIVILEGES will force direct changes to the mysql.user table to take effect

  • SET PASSWORD=PASSWORD('newpass') will set the password for the current user (encrypted)


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