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.

Transfer tool not working getting mysql database error

Discussion in 'General Discussion' started by mywish1, Nov 28, 2016.

Tags:
  1. mywish1

    mywish1 Active Member

    Joined:
    Sep 13, 2014
    Messages:
    25
    Likes Received:
    1
    Trophy Points:
    3
    cPanel Access Level:
    Root Administrator
    hi
    i m trying to transfer old server to new server some accounts and when i try to connect old server and fetch accounts i m getting error here is error

    The “mySQL” server is currently unavailable because of an error: Error while connecting to MySQL: (XID scgvdf) Database Connect Error: Access denied for user 'root'@'localhost' (using password: YES)

    here is screenshot
    upload_2016-11-29_10-20-30.png
     
  2. 24x7server

    24x7server Well-Known Member

    Joined:
    Apr 17, 2013
    Messages:
    1,405
    Likes Received:
    53
    Trophy Points:
    28
    Location:
    India
    cPanel Access Level:
    Root Administrator
    Hi,

    It clearly suggests that MySQL is not accessible to the root use with the default password in the configuration. You have to check if the password is correct for the MYSQL root user. You will need to have working mysql root password to take the dump of the databases..
     
  3. mywish1

    mywish1 Active Member

    Joined:
    Sep 13, 2014
    Messages:
    25
    Likes Received:
    1
    Trophy Points:
    3
    cPanel Access Level:
    Root Administrator
    how i can access mysql actually i think mysql root is not working how i can fix this issue i have no idea can i reinstall mysql 5.6 to fix that issue if yes then i m ready to reinstall tel me how i do that and i have no idea what is root password
    also also tel me where i can check root default password in configuration how to access plz guide me thanks.
     
  4. Infopro

    Infopro cPanel Sr. Product Evangelist
    Staff Member

    Joined:
    May 20, 2003
    Messages:
    15,629
    Likes Received:
    296
    Trophy Points:
    433
    Location:
    Pennsylvania
    cPanel Access Level:
    Root Administrator
    Twitter:
    You can set root MySQL password, here:
    WebHost Manager »SQL Services »MySQL Root Password
     
Loading...

Share This Page