Ubuntu – How to reset thesql root password without logging into thesql

MySQLpassword

I want to reset mysql root password but I don't want to log into mysql and then reset the password just as follows,

  mysql -u root
  FLUSH PRIVILEGES;
  SET PASSWORD FOR root@'localhost' = PASSWORD('password');
  UPDATE mysql.user SET Password=PASSWORD('newpwd') WHERE User='root';

Is there a way to achieve this using external command or something?

Best Answer

sudo dpkg-reconfigure mysql-server-x.x

Replace x.x with your current mysql server version.

Than it will prompt for a new password.

Related Solutions

Ubuntu – Can’t log into MySQL

This works whenever I need to do this ...

Stop the MySQL Server:

sudo /etc/init.d/mysql stop

Start the mysqld configuration.

sudo mysqld --skip-grant-tables &

mysql -u root mysql

Replace YOURNEWPASSWORD with your new password!

UPDATE user SET Password=PASSWORD('YOURNEWPASSWORD') WHERE User='root'; FLUSH PRIVILEGES; exit;

How to Reset MySQL Root Password

Try

sudo mysql -u root

MariaDB uses Unix socket authentication, which means you're authenticated as the user starting the mysql client.

You can read more about it in MariaDB's documentation.

Best Answer

Related Solutions

Ubuntu – Can’t log into MySQL

How to Reset MySQL Root Password

Related Question