The Community Forums

Interact with an entire community of cPanel & WHM users!
  1. This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn More.

mysqlopt throwing errors

Discussion in 'General Discussion' started by linux.newbie, Nov 3, 2008.

  1. linux.newbie

    linux.newbie Well-Known Member

    Joined:
    Sep 8, 2006
    Messages:
    73
    Likes Received:
    0
    Trophy Points:
    6
    Getting the following message via email :

    /etc/cron.weekly/mysqlopt:

    /usr/bin/mysqlcheck: Got error: 1045: Access denied for user 'root'@'localhost' (using password: NO) when trying to connect

    I have checked the /root/.my.cnf file and used the password listed there to update mysql password via WHM multiple times. Running the script manually via shell works fine. Please help.

    Thanks
     
  2. linux.newbie

    linux.newbie Well-Known Member

    Joined:
    Sep 8, 2006
    Messages:
    73
    Likes Received:
    0
    Trophy Points:
    6
    please give me any leads
     
  3. dave9000

    dave9000 Well-Known Member

    Joined:
    Apr 7, 2003
    Messages:
    891
    Likes Received:
    1
    Trophy Points:
    16
    Location:
    arkansas
    cPanel Access Level:
    Root Administrator
    Without seeing how /etc/cron.weekly/mysqlopt is done its hard to say why its not picking up the /root/.my.cnf info.

    But a simple solution would be to add the host,user,pass,db info to the mysqlcheck statement inside the /etc/cron.weekly/mysqlopt file
     
Loading...

Share This Page