On Fri, 06 Aug 2010 00:25:37 +0200 news...@acrocat.com wrote: > 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... > don't echo anything back. just run it with something like: sh -x /path/to/the/maintenance/script
> 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 > ------------------------------------------------------------------------------ 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
