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.

Help: weird cpanel sql problem

Discussion in 'Database Discussions' started by Snowman30, Feb 20, 2003.

  1. Snowman30

    Snowman30 Well-Known Member
    PartnerNOC

    Joined:
    Apr 7, 2002
    Messages:
    681
    Likes Received:
    0
    Trophy Points:
    16
    cPanel Access Level:
    DataCenter Provider
    i have a weird problem on a server that was setup with a fresh install of cpanel today.

    I get:

    Databases ERROR 1045: Access denied for user: 'root@localhost' (Using password: YES) 0 / unlimited

    and

    MySQL Disk Usage /usr/bin/mysqladmin: connect to server at 'localhost' failed error: 'Access denied for user: 'root@localhost' (Using password: YES)' 0.00 Megabytes

    in the cpanel.

    Im using cpanel x-skin on R117.

    any ideas what could be the problem here??? or a way to fix it?
     
  2. darksoul

    darksoul Active Member

    Joined:
    Feb 20, 2003
    Messages:
    40
    Likes Received:
    0
    Trophy Points:
    6
    1.Login into your server with ssh
    2.prompt# mysql -u root
    3.mysql> set password for root=password('yourpass');
    4.mysql>\q

    5. login into whm,
    6. go to "Set MySql Root Password" and setup the password above
    (you will get an error)
    7. repeat 6 (all should be fine)
     
  3. carpman1

    carpman1 Member

    Joined:
    Jan 25, 2003
    Messages:
    15
    Likes Received:
    0
    Trophy Points:
    1
    I had simular error for a normal user using webscripts but console ok, upgrading to latest cp 6 version seem tocure it
     
  4. Snowman30

    Snowman30 Well-Known Member
    PartnerNOC

    Joined:
    Apr 7, 2002
    Messages:
    681
    Likes Received:
    0
    Trophy Points:
    16
    cPanel Access Level:
    DataCenter Provider
    i found it seemed to be a x-skin issue, i loaded a new copy of 1.5 and it works now....

    mind you ive had all sorts of weird things happen on this server today :(

    Thanks for the advice
     
Loading...

Share This Page