How to reset Xtream Codes MySQL Root Password?

[redhat]

Once you don't remember the Xtream Codes MySQL Root Password you set during the Main Server installation, you can reset it with the following steps.


Reset a MySQL root password


Connect to your Main Server with putty


Stop the MySQL service

(Ubuntu and Debian) Run the following command:

sudo /etc/init.d/mysql stop

(CentOS, Fedora, and Red Hat Enterprise Linux) Run the following command:

sudo /etc/init.d/mysqld stop

Start MySQL without a password

Run the following command. The ampersand (&) at the end of the command is required.

sudo mysqld_safe --skip-grant-tables &

Connect to MySQL

Run the following command:

mysql -uroot

Set a new MySQL root password

Run the following command:

use mysql;
update user set authentication_string=PASSWORD("mynewpassword") where User='root';
flush privileges;
quit

Note: Change mynewpassword with your own password

Stop and start the MySQL service
(Ubuntu and Debian) Run the following commands:

sudo /etc/init.d/mysql stop
...
sudo /etc/init.d/mysql start

(CentOS, Fedora, and Red Hat Enterprise Linux) Run the following commands:

sudo /etc/init.d/mysqld stop
...
sudo /etc/init.d/mysqld start

Log in to the database

Test the new password by logging in to the database.

mysql -u root -p

Enter your new password when prompted.

 

[dafreak]

is this also for
latest version ?

 

[DM 3]

Please note that if you change your password then you will also need to 'remake' your main panel server with the updated MySQL password otherwise you will have a dead panel.

 

[redhat]

is this also for
latest version ?

Yes

 

[brainzr]

Hey @redhat , seeing we dont have a panel anymore , do you think we can reset the mysql password?
Id like to change a few things into database (like expiry dates) but the MySql password was put in by XC itself..

 

[redhat]

Hey @redhat , seeing we dont have a panel anymore , do you think we can reset the mysql password?
Id like to change a few things into database (like expiry dates) but the MySql password was put in by XC itself..

Yes you can as long as you have ssh access

 

[didar]

Once you don't remember the Xtream Codes MySQL Root Password you set during the Main Server installation, you can reset it with the following steps.


Reset a MySQL root password


Connect to your Main Server with putty


Stop the MySQL service

(Ubuntu and Debian) Run the following command:

sudo /etc/init.d/mysql stop

(CentOS, Fedora, and Red Hat Enterprise Linux) Run the following command:

sudo /etc/init.d/mysqld stop

Start MySQL without a password

Run the following command. The ampersand (&) at the end of the command is required.

sudo mysqld_safe --skip-grant-tables &

Connect to MySQL

Run the following command:

mysql -uroot

Set a new MySQL root password

Run the following command:

use mysql;
update user set authentication_string=PASSWORD("mynewpassword") where User='root';
flush privileges;
quit

Note: Change mynewpassword with your own password

Stop and start the MySQL service
(Ubuntu and Debian) Run the following commands:

sudo /etc/init.d/mysql stop
...
sudo /etc/init.d/mysql start

(CentOS, Fedora, and Red Hat Enterprise Linux) Run the following commands:

sudo /etc/init.d/mysqld stop
...
sudo /etc/init.d/mysqld start

Log in to the database

Test the new password by logging in to the database.

mysql -u root -p

Enter your new password when prompted.

thanks for the info

 

[heaveframe]

Is this safe to do after xc shutdown?

We need to change our database passwords to be safe now!!

 

[webgon]

hello good morning, it doesn't work for me in the second command and my server is giving me an error with ubuntu 18

 

[swanlove22]

Thanks a lot for most important thing . always must remember that we can back our sql password

 

[jake321]

Thank you. Really helpful.