hi,

mysql> GRANT ALL PRIVILEGES ON *.* TO user@% IDENTIFIED BY password;
ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that
corresponds to your MySQL server version for the right syntax to use near '% IDE
NTIFIED BY Savem3' at line 1
mysql>

i google around and this command is found everywhere... could anyone please point out what is wrong?

hi,

mysql> GRANT ALL PRIVILEGES ON *.* TO user@% IDENTIFIED BY password;
ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that
corresponds to your MySQL server version for the right syntax to use near '% IDE
NTIFIED BY Savem3' at line 1
mysql>

i google around and this command is found everywhere... could anyone please point out what is wrong?

GRANT ALL PRIVILEGES ON *.* TO 'user'@'%' IDENTIFIED BY 'password';

You must use single quotes around user, % and password.

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.