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.
...
News Link: https://www.cloudbooklet.com/how-to-reset-change-mysql-root-password/?utm_source=rss&utm_medium=rss&utm_campaign=how-to-reset-change-mysql-root-password.
RSS Link: https://www.cloudbooklet.com/feed/.
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.
