What is my root password for MySQL?

last updated in Categories

Q. I have just installed mysql. I don’t know how to connect as well as what is my root or mysql admin password for MySQL?

A. Your default mysql password is empty (i.e. no password). For example:

  • Username: root
  • Password: empty

However if you use something like Plesk software use following information:

  • User: admin
  • Password: admin

Above is just a default password. If you are not sure about password, it is best to ask to person who has installed mysql for you.

Get 15% off on Linux Foundation certified SysAdmin, Progamming, Kubernetes/Containers and Open Stack certification & course. Use "SPLASH15" coupon code. Offer expires on August 27, 2018
training.linuxfoundation.org

Posted by: Vivek Gite

The author is the creator of nixCraft and a seasoned sysadmin, DevOps engineer, and a trainer for the Linux operating system/Unix shell scripting. Get the latest tutorials on SysAdmin, Linux/Unix and open source topics via RSS/XML feed or weekly email newsletter.

3 comment

  1. I have forgot the root passwd pls help if i edit i am getting the following details
    kernel /boot/vmlinuz-2.4.22 ro root=LABEL=/
    initrd/boot/initrd -2.4.22.img
    pls help

  2. Nice. I just got gifted a database in which NO-ONE knows the root password. I shall now have to scour the web to find a way around it. Just thought you should know that you’re not alone.

  3. my sql is the best known database … then why is there to reset the password of the database … it can be a big security risk.

    Have a question? Post it on our forum!