How to Connect to MySQL Without Root Password on Terminal

Normally while installing MySQL/MariaDB database server on Linux, it’s recommended to set a MySQL root user password to secure it, and this password is required to access the database server with root user privileges.

Suggested Read: How to Install and Secure MariaDB 10 in CentOS 7

In this guide, we will show you how to connect and run MySQL commands without entering a password (mysql passwordless root login) on the Linux terminal.

How to Set MySQL Root Password

In case you have freshly installed the MySQL/MariaDB server, then it doesn’t require any password to connect to it as root user. To secure it, set the MySQL/MariaDB password for root user with the following command.

Note that this command is just one of the many MySQL (Mysqladmin) Commands for Database Administration in Linux.

# mysqladmin -u root password YOURNEWPASSWORD

How to Connect or Run MySQL Without Root Password

To run MySQL commands without entering password on the terminal, you can store your user and password in the ~/.my.cnf user specific configuration file in user’s home directory as described below.

Now create the config file ~/.my.cnf and add configurations below in it (remember to replace mysqluser and mysqlpasswd with your own values).

[mysql]
user=user
password=password

Save and close the file. Then set the suitable permissions on it, to make it only readable and writable by you.

# chmod 0600 .my.cnf

Once you have set user and password in the Mysql configuration file, from now on when you run mysql commands such as mysql, mysqladmin etc, they will read the mysqluser and mysqlpasswd from the above file.

# mysql 
# mysql -u root 
Run Mysql- Commands Without Root Password
Run Mysql- Commands Without Root Password

You may also like to read these related articles about MySQL/MariaDB:

    1. 20 MySQL (Mysqladmin) Commands for Database Administration in Linux
    2. How to Change Root Password of MySQL or MariaDB in Linux
    3. How to Reset MySQL or MariaDB Root Password in Linux
    4. 15 Useful MySQL/MariaDB Performance Tuning and Optimization Tips
    5. 4 Useful Commandline Tools to Monitor MySQL Performance in Linux

In this guide, we showed how to run MySQL commands without entering root password on the terminal. If you have any queries or thoughts to share, do hit us up via the feedback form below.

Hey TecMint readers,

Exciting news! Every month, our top blog commenters will have the chance to win fantastic rewards, like free Linux eBooks such as RHCE, RHCSA, LFCS, Learn Linux, and Awk, each worth $20!

Learn more about the contest and stand a chance to win by sharing your thoughts below!

Aaron Kili
Aaron Kili is a Linux and F.O.S.S enthusiast, an upcoming Linux SysAdmin, web developer, and currently a content creator for TecMint who loves working with computers and strongly believes in sharing knowledge.

Each tutorial at TecMint is created by a team of experienced Linux system administrators so that it meets our high-quality standards.

Join the TecMint Weekly Newsletter (More Than 156,129 Linux Enthusiasts Have Subscribed)
Was this article helpful? Please add a comment or buy me a coffee to show your appreciation.

6 Comments

Leave a Reply
  1. It didn’t work. I had created the user from cPanel in shared hosting. It did work with:

    [client]
    user=mysqluser
    password=mysqluser-password
    

    as my my.cnf file.

    Reply
  2. Hi

    Sorry, I’m here again

    I am getting below error when trying to connect to MySQL.

    ERROR 1045 (28000): Access denied for user ‘root’@’localhost’ (using password: NO) or … YES)

    mysqld_safe --skip-grant-tables does it works? the procedure as above was going normally, no remarks!

    What about the file /etc/mysql/.my.cnf? and the command chmod 0600 .my.cnf?

    (Mysql 10.3 / RPI 4 Mod B Buster)

    thank you for your help

    Max

    Reply
  3. “In case you have freshly installed the MySQL/MariaDB server, then it doesn’t require any password to connect to it as root user.”

    This is not the case for MySQL 5.7 on CentOS 7.x the MySQL server generate a random password that you need to figure it out with:

    # grep -i password /var/log/mysqld.log
    
    Reply

Got Something to Say? Join the Discussion...

Thank you for taking the time to share your thoughts with us. We appreciate your decision to leave a comment and value your contribution to the discussion. It's important to note that we moderate all comments in accordance with our comment policy to ensure a respectful and constructive conversation.

Rest assured that your email address will remain private and will not be published or shared with anyone. We prioritize the privacy and security of our users.