MySQL notes

From Noah.org
Revision as of 15:59, 26 April 2007 by Root (talk | contribs)
(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
Jump to navigationJump to search

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@'%';"
Retrieved from "https://www.noah.org/mediawiki-1.34.2/index.php?title=MySQL_notes&oldid=2170"