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