SQL Error Whilst Creating New User

Asked Feb 24 '17 at 15:26

Active Feb 24 '17 at 15:32

Viewed 164 times

I'm trying to create a new user and grant permissions for all tables in my db on mySQL.

I'm using this command:

GRANT SELECT ON mailserver.* TO `mailuser`@`127.0.0.1` IDENTIFIED BY `mailuserpass`;

However for some reason I'm receiving this error:

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 'wefewwehappyfew' at line 1

I've done some googling and I can't seem to work out what's going wrong here so any help would be appreciated.

edited Feb 24 '17 at 15:32

Giorgos Betsos

71,379
9
63
98

asked Feb 24 '17 at 15:26

ScottishTapWater

3,656
4
38
81

try to remove ` character..and around your password use `'pass'` – Amani Ben Azzouz Feb 24 '17 at 15:34
That worked, thankyou! No idea why the website I was copying from used ` ` ` rather than `'` well spotted! – ScottishTapWater Feb 24 '17 at 15:36
that depends on your database quotes --> http://stackoverflow.com/questions/214309/do-different-databases-use-different-name-quote – Amani Ben Azzouz Feb 24 '17 at 15:42
Ahh, well thanks for resolving the issue. – ScottishTapWater Feb 24 '17 at 15:43
you are welcome :) – Amani Ben Azzouz Feb 24 '17 at 15:43

SQL Error Whilst Creating New User

0 Answers0