How to reset mysql root password in vicidial

    Step by step guide to reset the MySQL root password in vicidial, if you have forget the vicidial MySQL root password and looking for the way to reset then this article is for you.

    The Default for Root password of Vicibox is none that is no password is set , for security purpose if you have changed and forget the password ,then you can follow below steps to reset the MySQL root password.  Apart from root access the vicidial uses default credentials like cron and password of 1234.

Vicidial mysql root password reset

What is MySQL?

    MySQL is an open-source relational database management system (RDBMS),
MariaDB is a fork of the MySQL database management system.
Vicidial use either MySQL or MariaDB as there default database software.

MySQL root password

In the MySQL ecosystem, root is the default user created during installation.
What to do when you forgot the root password of MySQL
Follow the below steps to reset the mysql root password.

Steps: Reset mysql root password

    Follow the below steps to reset the MySQL root password in vicidial

Step 1 : stop the mysql
/etc/init.d/mysql stop
systemctl stop mysqld

it will outputs 
stopping MySQL database server : mysqld

Step 2 : starting the mysql in safemode

run the below command to start MySQL in safe mode

mysqld_safe --skip-grant-tables &

the above command outputs as

Starting mysqld daemon with databases from /var/lib/mysql
mysqld_safe[6025]: started
Step 3 : logging to MySQL
mysql -u root 

Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 1 to server version: 4.1.15-Debian_1-log
Type 'help;' or '\h' for help. Type '\c' to clear the buffer.

Step 4 : updating new password for MySQL root

copy paste the below MySQL commands
use mysql
update user set password=PASSWORD("yournewpassword") where user='root';
flush privileges
Step 5 : Stop and Start the mysql
/etc/init.d/mysql stop
/etc/init.d/mysql start
systemctl stop mysqld
systemctl start mysqld
Step 6 : login to mysql with new password
mysql -u root -p yournewpassword


    Hope with this article you are able to reset your forgotten MySQL root password in vicidial. For professional support reach me on skype or telegram id: striker24x7 

  • Ajit Kumar
    Ajit Kumar April 4, 2022 at 11:21 AM

    How to reset the Mysql root password in vicidial

Add Comment
comment url