In this article, I am going to explain How to dump Database without a Password from the Linux Command line?
As we know when someone wants to dump a database from the Linux command line they need a password for the database to dump it. Basically dumping database means exporting the database from the Linux command line.
In a normal way when you want to export a database you need a password for the database to do it. Here is the normal command to dump.
mysqldump -u [user name] -p[password] [database name] > [dump file]
But sometimes people don’t like to give passwords again and again. So here I will tell you how you can do the database dump using a password. To do so just follow the process along with me.
You have to do some configurations on the MySQL configurations to dump the database without a password. You have to set the root user database password in my.cnf file and you can dump a database without a password. To do so first login to your root ssh using an ssh client like bitvise, putty, etc.
Location of my.cnf is different in the case of different operating systems like in the case of Ubuntu it is /etc/mysql/my.cnf and in case of Centos it /etc/my.cnf.
You can open according to your operating system after logging in to root ssh.
No got to my.cnf simply run this command:
sudo nano /etc/mysql/my.cnf
After that paste, this code in the file
user will be root and the password of your root MySQL user.
After doing this just restart MySQL or MariaDB and run any dump command
mysqldump -u root [Database naem] > /dbbackup.sql
Read More: How to Change Upload limit On CyberPanel?