MySQL 之認證與授權篇

bestlong

設定密碼：

1. mysql> set password for root@localhost = password('XXXX');

複製代碼

建立連線帳號、權限：

1. mysql> GRANT ALL privileges ON *.* TO 'root'@'localhost' IDENTIFIED BY 'XXXX' ;

複製代碼

要讓權限修改立即生效：

1. mysql> FLUSH PRIVILEGES ;

複製代碼