# You don't use IDENTIFIED BY in GRANT queries, it's used in CREATE USER CREATE USER 'root'@'%' IDENTIFIED BY 'password'; GRANT ALL PRIVILEGES ON *.* TO 'root'@'%';