[JiminSA]

I have imported a database I set up on my website using the host's 3rd party PMA (phpMyAdmin) software. I created a user for that website database using the Control Panel. I now want to simulate the same for localhost, so I used localhost (xampp) PMA to run an sql query...

CREATE USER 'surfwhee_jim'@'localhost' IDENTIFIED BY *****'james*****'

there is a screen shot of the query attached.
All seems well, however when I attempt to gain access thus...

PHP Code:

$con = mysql_connect("localhost","surfwhee_jim","******james******") or die(mysql_error()); 


it gives me the following error response...

Access denied for user 'surfwhee_jim'@'localhost' to database 'surfwhee_vehicles'

can anyone see where I might be screwing up?
(The passwords have been edited out - but are identical)

[dukevyner]

The user has to be given permission to select, and if needed update, insert as well as others depending on what the user should be able to do..

[JiminSA]

Thanks - does that mean the SQL query needs expanding to include the permissions for the user?

[dukevyner]

The permissions have to be set on the database... I'm unsure how to set permissions with mysql in ur situation... I would look into it... But someone here may be able to cleify

[JiminSA]

Thank you duke!
I managed to set the permissions using the following generic

GRANT ALL ON mydb.* TO 'someuser'@'somehost';

which I adapted for my set up... found it here
and "ran" it using the SQL tab in PMA... Problem solved

[dukevyner]

Good to hear... Remember there's always someone online here don't hesitate to ask for help

[JiminSA]

Oh I'm definitely not shy when it comes to asking! (Check my signature...)

[dukevyner]

That's good "The only bad question is the one not asked"