Skip to main content

User

使用Workbench管理使用者​

  • Administrator > Users and Privileges
  • User為帳號,From Host為可以登入的主機
  • 新增帳號：Administrator > Users and Privileges > Add Account按鈕
  • 修改帳號：Administrator > Users and Privileges > 選擇User帳號,進行修改
  • 刪除帳號：Administrator > Users and Privileges > 選擇User帳號,進行刪除

使用sql語法管理使用者​

SELECT user,host FROM mysql.user;
################# 新增使用者:
CREATE USER john@localhost IDENTIFIED BY '1234';                    #預設密碼為1234
CREATE USER john@localhost IDENTIFIED BY '1234' PASSWORD EXPIRE;    #登入就要重設密碼
CREATE USER john@localhost PASSWORD EXPIRE;                         #沒有預設密碼
################# 修改使用者:
ALTER USER john@localhost IDENTIFIED BY '5678';                     #修改密碼
ALTER USER john@localhost PASSWORD EXPIRE;                          #登入就要重設密碼
################# 刪除使用者:
DROP USER john@localhost;