SET PASSWORD FOR 'root'@'localhost' = PASSWORD('{password}');
SET PASSWORD FOR 'root'@'127.0.0.1' = PASSWORD('{password}');
SET PASSWORD FOR 'root'@'::1' = PASSWORD('{password}');メンドイ場合は以下
UPDATE mysql.user SET Password=PASSWORD('{password}') WHERE User='root';
FLUSH PRIVILEGES;


