MySQL 之認證與授權篇
設定密碼：[code]
mysql> set password for root@localhost = password('XXXX');
[/code]
建立連線帳號、權限：
[code]
mysql> GRANT ALL privileges ON *.* TO 'root'@'localhost' IDENTIFIED BY 'XXXX' ;
[/code]
要讓權限修改立即生效：
[code]
mysql> FLUSH PRIVILEGES ;
[/code]
頁:
[1]