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
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