MySQL grant privileges

[Anon]

I have tried to create a MySQL user on my development machine so that they match the user created by my ISP in the \'production\' environment using the following.

GRANT select, insert, update, delete on <dbname>.* to <username>@% identified by \'<password>\';

I now cannot connect from the terminal on my development server or by telnet using the user name and password I specified above.

I had already set another user on this database and that worked OK but I was wondering if you can have more than user (other than root) per db? If so any other suggestions as to why it doesnt work will be greatly appreciated

[[deleted]]

Ofcourse you can have more users per table/database.

You have to make very sure that the user@host is correct.
If you are on the localhost, sometimes you will be connected as 'user@localhost' and other times as 'user@hostname'.

[Anon]

Excellent,

Had to change the <user>@% to <user>@ and that did the trick. Any idea why % didn't work?

[Anon]

You'd have to insert it as:
<user>@"%" or else mysql will use the escape sequence for a % 🙂