Yep - crystal clear... So I get the grant thing... And I can connect to the db from the machine with the command line you and Stevan gave... I will try to echo back the command from the script and see what's happening...
On 8/6/2010 12:01 AM, Imposit.com - webmaster wrote: > 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 > > !DSPAM:1,4c5b35f0156801186620146! > ------------------------------------------------------------------------------ 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
