How to dump Database without Password from Linux Command line?

By | October 20, 2021

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.

How to dump Database without Password from Linux Command line?

No got to my.cnf simply run this command:

sudo nano /etc/mysql/my.cnf

After that paste, this code in the file

[mysqldump]
user=mysqluser
password=secret

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

Here you can read How to log in to the Rainloop admin dashboard?

Read More: How to Change Upload limit On CyberPanel?

How to Change Upload limit On CyberPanel?

Leave a Reply

Your email address will not be published.