How to reset mysql root password in vicidial

Mysql reset forgotten root password

Topic: How to reset mysql root password in vicidial

Vicidial mysql root password reset

  Overview:

    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.

  Issue: Mysql root password Forgot

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

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