MySQL create account
建立Account: mealadmin@localhost (@localhost代表可以在local登入)
並且給予密碼12345
並給予所有的權限
CREATE USER 'mealadmin'@'%' IDENTIFIED BY 'xxxxxxxx';
GRANT ALL PRIVILEGES ON *.* TO 'mealadmin'@'%' WITH GRANT OPTION;
FLUSH PRIVILEGES;
初次建立的DB會有預設的root帳號
請先把root帳號的密碼設定好
必要的話，移除root@%的設定
SET PASSWORD FOR 'root'@'localhost' = PASSWORD('xxxxxxxx');
SET PASSWORD FOR 'root'@'tucson' = PASSWORD('xxxxxxxx');
SET PASSWORD FOR 'root'@'%' = PASSWORD('xxxxxxxx');
並且給予密碼12345
並給予所有的權限
CREATE USER 'mealadmin'@'%' IDENTIFIED BY 'xxxxxxxx';
GRANT ALL PRIVILEGES ON *.* TO 'mealadmin'@'%' WITH GRANT OPTION;
FLUSH PRIVILEGES;
初次建立的DB會有預設的root帳號
請先把root帳號的密碼設定好
必要的話，移除root@%的設定
SET PASSWORD FOR 'root'@'localhost' = PASSWORD('xxxxxxxx');
SET PASSWORD FOR 'root'@'tucson' = PASSWORD('xxxxxxxx');
SET PASSWORD FOR 'root'@'%' = PASSWORD('xxxxxxxx');