How to Connect to MySQL Without Root Password on Terminal

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.95/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...

2 Responses

  1. 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 *