Access Denied for User 'root'@'localhost' (using password : NO)


How to fix Access Denied for user ‘root’@’localhost’ ( using password : NO ) on localhost MySQL XAMPP servers

If you ever want to change mySQL database access password then visit

Configure it with the “XAMPP Shell” (command prompt). Open the shell from the XAMPP control pane and execute this command:

mysqladmin.exe -u root password secret

This sets the root password to ‘secret’.

For more how to videos subscribe to RankYa YouTube channel here:


Xem thêm bài viết khác:


  1. Thank you! Great help! You have the only helpful solution I found. You saved me a lot of time!

  2. If the error persists
    Open xampp and Click on the “tick mark” on the left of MySQL
    Then it will be prompted whether to uninstall service
    Click yes and uninstall it
    Now you can see the MySQL starts in xampp

  3. hi i can the access to login by you method but when i tray to change the password logout it by it self so help me what is the next to do pleas


Please enter your comment!
Please enter your name here