Can't recover or change my MySQL root Password

Discussion in 'Server Operation' started by Keoz, Sep 12, 2018.

  1. Keoz

    Keoz Member

    Hello,
    I wish to migrate my ISP Config 3 (on remote server) to a new remote server, using the migration tool kit !
    When reading the tutorial, I am informed that I may be asked for my MySQL root password, but I have lost it, and it fails when I try to change it from my PC terminal in regard of this tutorial :
    https://support.rackspace.com/how-to/mysql-resetting-a-lost-mysql-root-password/

    *** COMMAND LINE THAT FAILS
    root@vpsNUMBER:~# mysql -u root
    *** RESULT
    ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)

    Why that ?
    Maybe that the password can be changed from a config file ; but I don't know where such this file is located...

    Thanks for any help !
     
  2. Keoz

    Keoz Member

    ID and password recovered !
     

Share This Page