err 1045: Access denide for user 'root'

In article , mail@bananas-
playground.net says...
>
> -----BEGIN PGP SIGNED MESSAGE-----
> Hash: SHA1
>
> IT wrote:
> > In article , mail@bananas-
> > playground.net says...
> > IT wrote:
> >>>> Hi,
> >>>> I have script that trying dump my database. But always I got this error:
> >>>> err 1045: Access denied for user 'root'@'localhost' (using password:
> >>>> YES) when trying to connect.
> >>>> I copied and run in terminal and when I tried from terminal everything
> >>>> is Ok.
> >>>>
> >>>> Here is that line from bacula-dir.conf file
> >>>> BeforeJob ="/usr/bin/mysqldump -u root -h localhost --
> >>>> password="myrootpassword" -C -Q -e -a databasename >/home/me/name.sql"
> > Hello,
> >
> > from where do you run this script ?
> > Via Browser, Application ?
> >
> > It could be the "Host" setting. The root user could be configured to be only
> > allowed to connect from localhost and not from any other PC over the network.
> >
> > j.keßler
>
> > Hello,
> > I run this from localhost. In both cases.
> > In backup program I set schedule for backup file and need to dump
> > database.
> > Backup program is bacula, and in this case mysql database is on the
> > server together with bacula.
> Hello,
>
> and what happens if you use the IP instaed of localhost ?
>
> j.keßler
> -----BEGIN PGP SIGNATURE-----
> Version: GnuPG v2.0.10 (GNU/Linux)
> Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org
>
> iEYEARECAAYFAknkkvQACgkQE++2Zdc7Etej5gCfQkkVrML7FSzugevuctY70fFB
> pKcAn0FFwe/f1yLmLaGmVqnFJRu+ITCR
> =LaJf
> -----END PGP SIGNATURE-----

If I use IP then got error 1130: host 'IPaddress' is not allowed to
connect to this MySQL server when trying to connect
 >> Stay informed about: err 1045: Access denide for user 'root' 

Hi,

IT wrote:
> Hi,
> I have script that trying dump my database. But always I got this error:
> err 1045: Access denied for user 'root'@'localhost' (using password:
> YES) when trying to connect.
> I copied and run in terminal and when I tried from terminal everything
> is Ok.
>
> Here is that line from bacula-dir.conf file
> BeforeJob ="/usr/bin/mysqldump -u root -h localhost --
> password="myrootpassword" -C -Q -e -a databasename >/home/me/name.sql"


Looks like the quotes are creating your problem: you are using
double-quotes for the outer quotes (begin and end of the whole
BeforeJob) and also for the inner quotes (begin and end of the password)
so that bacula reads only

BeforeJob ="/usr/bin/mysqldump -u root -h localhost --password="

and expects the BeforeJob directive to end with the =. mysqldump
connects with an empty password, which is rejected by mysql.

If you nest quotes, you have to use different quotes, for example:

BeforeJob ='/usr/bin/mysqldump -u root -h localhost
--password="myrootpassword" -C -Q -e -a databasename >/home/me/name.sql'

Since I am not familiar with bacula, I am not sure if this syntax is
correct, but I hope you get the idea.

Good luck,
Kerstin
 >> Stay informed about: err 1045: Access denide for user 'root' 

IT wrote:
> Hi,
> I have script that trying dump my database. But always I got this error:
> err 1045: Access denied for user 'root'@'localhost' (using password:
> YES) when trying to connect.
> I copied and run in terminal and when I tried from terminal everything
> is Ok.
>
> Here is that line from bacula-dir.conf file
> BeforeJob ="/usr/bin/mysqldump -u root -h localhost --
> password="myrootpassword" -C -Q -e -a databasename >/home/me/name.sql"

Can you connect to the database with the MySQL CLI using this userid and
password?

--
==================
Remove the "x" from my email address
Jerry Stuckle
JDS Computer Training Corp.
jstucklex RemoveThis @attglobal.net
==================
 >> Stay informed about: err 1045: Access denide for user 'root' 

In article , k.puschke DeleteThis @fu-berlin.de
says...
>
> Hi,
>
> IT wrote:
> > Hi,
> > I have script that trying dump my database. But always I got this error:
> > err 1045: Access denied for user 'root'@'localhost' (using password:
> > YES) when trying to connect.
> > I copied and run in terminal and when I tried from terminal everything
> > is Ok.
> >
> > Here is that line from bacula-dir.conf file
> > BeforeJob ="/usr/bin/mysqldump -u root -h localhost --
> > password="myrootpassword" -C -Q -e -a databasename >/home/me/name.sql"
>
>
> Looks like the quotes are creating your problem: you are using
> double-quotes for the outer quotes (begin and end of the whole
> BeforeJob) and also for the inner quotes (begin and end of the password)
> so that bacula reads only
>
> BeforeJob ="/usr/bin/mysqldump -u root -h localhost --password="
>
> and expects the BeforeJob directive to end with the =. mysqldump
> connects with an empty password, which is rejected by mysql.
>
> If you nest quotes, you have to use different quotes, for example:
>
> BeforeJob ='/usr/bin/mysqldump -u root -h localhost
> --password="myrootpassword" -C -Q -e -a databasename >/home/me/name.sql'
>
> Since I am not familiar with bacula, I am not sure if this syntax is
> correct, but I hope you get the idea.
>
> Good luck,
> Kerstin
It's not problem with quotes. I used first "''" and then '""', but in
both cases the error is the same.
 >> Stay informed about: err 1045: Access denide for user 'root' 

In article , jstucklex RemoveThis @attglobal.net
says...
>
> IT wrote:
> > Hi,
> > I have script that trying dump my database. But always I got this error:
> > err 1045: Access denied for user 'root'@'localhost' (using password:
> > YES) when trying to connect.
> > I copied and run in terminal and when I tried from terminal everything
> > is Ok.
> >
> > Here is that line from bacula-dir.conf file
> > BeforeJob ="/usr/bin/mysqldump -u root -h localhost --
> > password="myrootpassword" -C -Q -e -a databasename >/home/me/name.sql"
>
> Can you connect to the database with the MySQL CLI using this userid and
> password?


I was using different user with MySQL CLI.
Today I try witho 'roo't & Password for root but can't connect.
 >> Stay informed about: err 1045: Access denide for user 'root' 

IT wrote:
> In article , jstucklex.RemoveThis@attglobal.net
> says...
>> IT wrote:
>>> Hi,
>>> I have script that trying dump my database. But always I got this error:
>>> err 1045: Access denied for user 'root'@'localhost' (using password:
>>> YES) when trying to connect.
>>> I copied and run in terminal and when I tried from terminal everything
>>> is Ok.
>>>
>>> Here is that line from bacula-dir.conf file
>>> BeforeJob ="/usr/bin/mysqldump -u root -h localhost --
>>> password="myrootpassword" -C -Q -e -a databasename >/home/me/name.sql"
>> Can you connect to the database with the MySQL CLI using this userid and
>> password?
>
>
> I was using different user with MySQL CLI.
> Today I try witho 'roo't & Password for root but can't connect.

Looks like you found your problem.

--
==================
Remove the "x" from my email address
Jerry Stuckle
JDS Computer Training Corp.
jstucklex.RemoveThis@attglobal.net
==================
 >> Stay informed about: err 1045: Access denide for user 'root' 

In article , jstucklex.TakeThisOut@attglobal.net
says...
>
> IT wrote:
> > In article , jstucklex.TakeThisOut@attglobal.net
> > says...
> >> IT wrote:
> >>> Hi,
> >>> I have script that trying dump my database. But always I got this error:
> >>> err 1045: Access denied for user 'root'@'localhost' (using password:
> >>> YES) when trying to connect.
> >>> I copied and run in terminal and when I tried from terminal everything
> >>> is Ok.
> >>>
> >>> Here is that line from bacula-dir.conf file
> >>> BeforeJob ="/usr/bin/mysqldump -u root -h localhost --
> >>> password="myrootpassword" -C -Q -e -a databasename >/home/me/name.sql"
> >> Can you connect to the database with the MySQL CLI using this userid and
> >> password?
> >
> >
> > I was using different user with MySQL CLI.
> > Today I try witho 'roo't & Password for root but can't connect.
>
> Looks like you found your problem.

Yes, thanks to all.
 >> Stay informed about: err 1045: Access denide for user 'root'