Posts

Showing posts with the label Reset MySQL password

How to reset password for MySQL MaiaDB

Have you forgotten your MySQL root password? Don’t worry, it happens to all of us. In this article, we will show you how to reset the MySQL root password from the command line. Identify the Server Version Depending on the MySQL or MariaDB server version you are running on your system, you will need to use different commands to recover the root password. You can find your server version by issuing the following command: mysql --version If you have MySQL installed in your system the output will look something like this: mysql Ver 14.14 Distrib 5.7.22, for Linux (x86_64) using EditLine wrapper Or output like this for MariaDB: mysql Ver 15.1 Distrib 10.1.33-MariaDB, for debian-linux-gnu (x86_64) using readline 5.2 Be sure to make a note of which version of MySQL or MariaDB you’re running. How to Reset MySQL or MariaDB Root Password Follow these steps to reset your MySQL/MariaDB root password: 1. Stop the MySQL/MariaDB service  # To change the root passw