User Tools

Site Tools


create_new_mysql_user

Differences

This shows you the differences between two versions of the page.

Link to this comparison view

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):
create_new_mysql_user.txt · Last modified: 2012/03/22 11:10 by root