Search
 
SCRIPT & CODE EXAMPLE
 
CODE EXAMPLE FOR SQL

mysql identified by syntax error

# 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'@'%';
 
PREVIOUS NEXT
Tagged: #mysql #identified #syntax #error
ADD COMMENT
Topic
Name
4+7 =