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): |