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!

MySQL permission denied on all accounts

Discussion in 'General Discussion' started by TSD500, Jul 18, 2004.

  1. TSD500

    TSD500 Member

    Joined:
    May 16, 2004
    Messages:
    7
    Likes Received:
    0
    Trophy Points:
    151
    All mysql users are getting premission denied errors when try try to use mysql including root. I tried to reset the root pass but it didn't work. Running mysql from the shell works though. ANy suggestions?
     
  2. bamasbest

    bamasbest Well-Known Member

    Joined:
    Jan 10, 2004
    Messages:
    531
    Likes Received:
    0
    Trophy Points:
    166
    Have you tried running /scripts/fixmysql ?
     
  3. TSD500

    TSD500 Member

    Joined:
    May 16, 2004
    Messages:
    7
    Likes Received:
    0
    Trophy Points:
    151
    Yep, I ran that, no such luck.
     
  4. mickalo

    mickalo Well-Known Member

    Joined:
    Apr 16, 2002
    Messages:
    774
    Likes Received:
    4
    Trophy Points:
    318
    Location:
    N.W. Iowa
    what type of error are you getting ?

    Mickalo
     
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
  5. TSD500

    TSD500 Member

    Joined:
    May 16, 2004
    Messages:
    7
    Likes Received:
    0
    Trophy Points:
    151
    Its when we try to access it using phpmyadmin or another PHP script. We get Premission Denied from phpmyadmin. For the scripts we get the access denied for user etc. message.
     
  6. Ronny

    Ronny Well-Known Member

    Joined:
    Dec 27, 2002
    Messages:
    63
    Likes Received:
    0
    Trophy Points:
    156
    Try chowning /var/lib/mysql/ mysql:mysql
     
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
Loading...

Share This Page

  1. This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
    By continuing to use this site, you are consenting to our use of cookies.
    Dismiss Notice