This shows you the differences between two versions of the page.
| create_new_mysql_user [2011/06/01 12:58] 127.0.0.1 external edit | create_new_mysql_user [2012/03/22 11:10] (current) root | ||
|---|---|---|---|
| Line 2: | Line 2: | ||
| First create user: | First create user: | ||
| - | CREATE USER '<username>'@'<host to connect from>' IDENTIFIED BY '<password>'; | + | CREATE USER '<username>'@'<host to connect from>' IDENTIFIED BY 'clear text password>'; | 
| + | or | ||
| + | CREATE USER '<username>'@'<host to connect from>' IDENTIFIED BY PASSWORD '<encrypted password>'; | ||
|  |  | ||
| Grant some rights to the user (here all as * is used): | Grant some rights to the user (here all as * is used): | ||