Please whitelist cPanel in your adblocker so that you’re able to see our version release promotions, thanks!

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:
    156
    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:
    156
    please give me any leads
     
  3. dave9000

    dave9000 Well-Known Member

    Joined:
    Apr 7, 2003
    Messages:
    891
    Likes Received:
    1
    Trophy Points:
    168
    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...
Similar Threads - mysqlopt throwing errors
  1. Kamal Singh Bora
    Replies:
    3
    Views:
    913

Share This Page