Mysql user howto, All these commands were tested on MySQL5

1. How to add a user.
   • I am using the user test as a example as well as the host localhost as an example...
     "CREATE USER 'test'@'localhost' IDENTIFIED BY 'passwd';"
2. How to change a users password
   • "SET PASSWORD FOR 'test'@'localhost' = PASSWORD('passwd');"
3. How to delete a user
   
   • "DROP USER 'test'@'localhost';"
4. How to rename a users account
   • "RENAME USER 'test'@'localhost' TO 'test1'@'localhost';"
5. How to grant different permissions to users
   • This statement give the SELECT(query) access to the user test on all databases on localhost...
     "GRANT SELECT on *.* TO 'test'@'localhost' IDENTIFIED BY 'passwd';"
   • This statement gives the test user super user privileges on all databases on localhost to user test....
     "GRANT ALL PRIVILEGES on *.* TO 'test'@'localhost' IDENTIFIED BY 'passwd';"

---

Add this page to your favorite Social Bookmarking websites