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
or
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

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

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.
mysql>

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
quit
Step 5 : Stop and Start the mysql
/etc/init.d/mysql stop
/etc/init.d/mysql start
or
systemctl stop mysqld
systemctl start mysqld
Step 6 : login to mysql with new password
mysql -u root -p yournewpassword

Conclusion:

    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 

Next Post Previous Post
1 Comments
  • gopi baskar
    gopi baskar April 4, 2022 at 11:21 AM

    How to reset the Mysql root password in vicidial

Add Comment
comment url