Difference between revisions of "MySQL notes"
From Noah.org
Jump to navigationJump to searchLine 1: | Line 1: | ||
− | + | [[Category:Engineering]] | |
== create a user == | == create a user == | ||
This create a new root level user named USERNAME. | This create a new root level user named USERNAME. | ||
mysql -u root -e "grant all on *.* to USERNAME@localhost;" | mysql -u root -e "grant all on *.* to USERNAME@localhost;" | ||
mysql -u root -e "grant all on *.* to USERNAME@'%';" | mysql -u root -e "grant all on *.* to USERNAME@'%';" |
Revision as of 15:59, 26 April 2007
create a user
This create a new root level user named USERNAME.
mysql -u root -e "grant all on *.* to USERNAME@localhost;" mysql -u root -e "grant all on *.* to USERNAME@'%';"