How to Reset Change MySQL Root Password

How to Reset Change MySQL Root Password on Ubuntu or Debian or CentOS. Ever forgotten your MySQL root password or fixing a MySQL installation on a new server we have all been there. .

In this guide you are going to learn how to reset or change or update MySQL root password in MySQL 8 MySQL 5.7 and MySQL 5.6.

This guide is tested on MySQL versions running on virtual machine created on Google cloud with Ubuntu.

Choose Best Hosting for your Business.

Root access to server or a user with sudo privileges.

SSH into your server to check the version of MySQL server installed. Each version has their own method of resetting passwords.

To check the MySQL version use the following command.

If you are on MySQL 8.0 you will get an out put similar to this.

If you are on MySQL 5. you will get an out put similar to this.


Read Full Post

News Link:
RSS Link:

Linux Chatter is a news aggregator service that curates some of the best Linux, Cloud, Technical Guides, Hardware and Security news. We display just enough content from the original post to spark your interest. If you like the topic, then click on the 'read full post' button to visit the author's website. Use Linux Chatter to find content from amazing authors!

Note: The content provided has been modified and is not displayed as intended by the author. Any trademarks, copyrights and rights remain with the source.

Disclaimer: Linux Chatter sources content from RSS feeds and personal content submissions. The views and opinions expressed in these articles are those of the authors and do not necessarily reflect those of Linux Chatter.