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.

Best Affordable Linux and WordPress Services For Your Business
Outsource Your Linux and WordPress Project and Get it Promptly Completed Remotely and Delivered Online.

If You Appreciate What We Do Here On TecMint, You Should Consider:

  1. Stay Connected to: Twitter | Facebook | Google Plus
  2. Subscribe to our email updates: Sign Up Now
  3. Get your own self-hosted blog with a Free Domain at ($3.45/month).
  4. Become a Supporter - Make a contribution via PayPal
  5. Support us by purchasing our premium books in PDF format.
  6. Support us by taking our online Linux courses

We are thankful for your never ending support.

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.

Your name can also be listed here. Got a tip? Submit it here to become an TecMint author.

RedHat RHCE and RHCSA Certification Book
Linux Foundation LFCS and LFCE Certification Preparation Guide

You may also like...

4 Responses

  1. Max says:

    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

  2. Syafiq says:

    Thank you, you helped me

  3. sedlav says:

    “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
    

Got something to say? Join the discussion.

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.