This means the following: Mysql try to connect form localhost (aka 127.0.0.1) with user myUser and a password to connect
your grant is a bit useless. bevore myuser can use the right on the database it need siths to connect to the database itself so what you need is a user Myuser with right on localhost with password (whatever you suplyed) you have to understand. in Mysql Myuser connecting from 10.10.10.1 is not equal to Myuser connecting from 10.10.10.2 is not equal to Myuser connecting from 10.10.10.2 without password so you can have myuser from localhost with and without password and both are threaded different is laso different from where they come from i hope i made it clear :-) ----- news...@acrocat.com schrieb: | Von: news...@acrocat.com | An: dspam-user@lists.sourceforge.net | Gesendet: Donnerstag, 5. August 2010 23:41:32 GMT +01:00 Amsterdam/Berlin/Bern/Rom/Stockholm/Wien | Betreff: [Dspam-user] dspam_maintenance: Access denied for user | | When running dspam_maintenance.sh, I get the following error: | | | ERROR 1045 (28000): Access denied for user 'myUser'@'localhost' | (using | password: YES) | MySQL purge script returned error code 1 | | I have given that user rights to the database: | | GRANT ALL PRIVILEGES ON dspamDB.* TO 'myUser'@'localhost' WITH GRANT | OPTION; | GRANT ALL PRIVILEGES ON dspamDB.* TO 'myUser'@'%' WITH GRANT OPTION; | | Any idea what I am missing? | | Edward | | | ------------------------------------------------------------------------------ | This SF.net email is sponsored by | | Make an app they can't live without | Enter the BlackBerry Developer Challenge | http://p.sf.net/sfu/RIM-dev2dev | _______________________________________________ | Dspam-user mailing list | Dspam-user@lists.sourceforge.net | https://lists.sourceforge.net/lists/listinfo/dspam-user ------------------------------------------------------------------------------ This SF.net email is sponsored by Make an app they can't live without Enter the BlackBerry Developer Challenge http://p.sf.net/sfu/RIM-dev2dev _______________________________________________ Dspam-user mailing list Dspam-user@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/dspam-user
