摘要:
#create a root password formysqladmin -u root password '19740415'create user silmysql> CREATE USER sil IDENTIFIED BY '123';Host | User| % | silthen we must grant permission to sil user.mysql> grant all on *.* to 'sil'@localhost' identified by '123'sudo servi 阅读全文
摘要:
The create user command:mysql> CREATE USER yy IDENTIFIED BY '123';yy表示你要建立的用户名,后面的123表示密码上面建立的用户可以在任何地方登陆。如果要限制在固定地址登陆,比如localhost 登陆:mysql> CREATE USER yy@localhost IDENTIFIED BY '123';一, 创建用户: 命令:CREATE USER 'username'@'host' IDENTIFIED BY 'password'; 阅读全文