MySQL notes

From Noah.org
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@'%';"