I wondered if anyone could help with the following? Im trying to setup new users on a mysql database (based on my win xp pc), for a uni project. The version of mysql Im using is 5.1.36. I am getting the following error when trying to create a new user -

Any help greatly appreciated. Passwords blanked out only.

dude - are you not putting your password in single quotes?

That will help you do most tasks:

http://sourceforge.net/projects/mysql-admin/

No offence intended cheezemonkhai, but I wouldn't touch that mysql-admin php tool you linked to, it hasn't been updated in years and could well have security holes. If you are going to use a php based mysql admin tool, it's got to be the industry standard phpMyAdmin.

Yep I put the passwords in single quotes - `password' using the quotation on the far left of the keyboard (above the tab key). However when I typed it in here to demonstrate what I was doing I saw that it didn't appear as a quotation! I tried the command using two of the quotations (same key as the @ sign on the keyboard) and this fixed it!

Thanks for your advice.

None taken about the PHP tools, I don't use them and the last time I did that one was the standard.

You haven't created any databases (and therefore no tables to grant permissions on) by the looks of it.

You haven't created any databases (and therefore no tables to grant permissions on) by the looks of it.

You can grant priveleges on non-existant databases / tables.

I had created databases so that was all ok. I was using the wrong quotation mark at the beginning of that password