TIPS & TRICKS BLOG

Today, In this article we are going to learn how to “ Reset MySQL Root Password “. It is a good option to use this method only for resetting the password but it is highly insecure. So make sure after resetting the password, you also revert the changes from my.cnf file. Note: For Centos and Fedora Based OS sudo service mysqld stop sudo service mysqld start For Debian and Ubuntu OS sudo service mysql stop sudo service mysql start Steps Here i am using amazon linux 2 OS (based on centos) Stop mysql service – sudo service mysqld stop Open /etc/my.cnf file – sudo nano /etc/my.cnf Add skip-grant-tables under [mysqld] section Start MySql Service – sudo service mysqld start Open terminal and type mysql and type following query and press enter UPDATE mysql.user SET authentication_string=PASSWORD(‘Your new password’) WHERE User=’root’; Then write FLUSH PRIVILEGES; and press enter Now type – exit; Stop mysql service again – sudo service mysqld stop Open my.cnf file – sudo nano /etc/my.cnf

Today in this article “ Restore MySQL Database Without SQL Dump ” we will discuss how you can restore your database when you don’t have SQL dump file. This happens when your MYSQL gets corrupted. In that case, if you want to make a back up of your database you can simply copy following files and then restore them after a fresh installation Let’s Start Generally MySQL gets installed on following location /var/lib/mysql On this location it create folders of your databases. For instance, if you have databases like test, test1, test2 Then on this location /var/lib/mysql – You will have three folders test, test1, test2. And each of these folders will contain database files for the MyISAM database. It will have three main files with the following extensions frm myi myd And another three files which will be inside in /var/lib/mysql. These files are for INNO DB database. ibdata1 ib_logfile0 ib_logfile1 Steps: Stop Mysql Service using – sudo service mysqld stop Copy folder to /var/lib/mysql