How to Fix Access Denied for User ‘root’@’localhost’ Error on MySQL

MySQL is an open source Database Management system based on the “SQL” language. MySQL comes bundled with the XAMPP Control Panel which is also an open source and free to use application. However, quite recently a lot of reports have been coming in of users who are unable to access their “MySQL” database from their browser and the “Access Denied for Use ‘root’@’localhost‘” Error is displayed when doing so.

Error Message

In this article, we will guide you with the easiest way to fix this problem and also inform you of the reason due to which this error is triggered. Make sure to follow the guide carefully and in order to avoid further issues.

What Causes the Access Denied for User ‘root’@’localhost’ Error on MySQL?

After receiving numerous reports from multiple users, we decided to investigate the issue and devised a solution after experimenting with many known troubleshooting processes. Also, we looked into the reason due to which this issue is triggered and listed it below.

  • Invalid “.ini” Configuration: The “.ini” file stores certain launch configurations for the “MySQL” server. It acts as a gateway in the way of loading the database. In some cases, it was seen that a certain sequence of code was missing from the “.ini” file due to which this error was being triggered.

Now that you have a basic understanding of the nature of the problem, we will move on towards the solution.

Solution: Re-configuring “.ini” File

If the “.ini” file for XAMPP control panel isn’t configured properly, it can prevent the establishment of a secure connection with the MySQL database. Therefore, in this step, we will be reconfiguring the file by adding an additional command. In order to do that:

  1. Open XAMPP control panel and click on the “Stop” button for both “Apache” and “MySQL“.
    Pressing the stop buttons for both MySQL and Apache
  2. Navigate to the installation directory for “XAMPP” and double click on the “MySQL” folder.
    Opening the “MySQL” folder
  3. Double click on the “bin” folder and right-click on the “my.ini” file.
  4. Click on the “Edit” option.
  5. Locate the words “[mysqld]” in the list.
  6. Add the following command below the “[mysqld]” line and above the “Port=….” line.
  7. Click on “File” and select “Save“.
  8. Close the document and open the XAMPP control panel.
  9. Click on the “Start” button for both “Apache” and “MySQL“.
    Clicking the start buttons for both MySQL and Apache
  10. Open the browser, try to login to MySQL and check to see if the issue persists.
Kevin Arrows
Kevin is a dynamic and self-motivated information technology professional, with a Thorough knowledge of all facets pertaining to network infrastructure design, implementation and administration. Superior record of delivering simultaneous large-scale mission critical projects on time and under budget.

Expert Tip

How to Fix Access Denied for User ‘root’@’localhost’ Error on MySQL

If the issue is with your Computer or a Laptop you should try using Restoro which can scan the repositories and replace corrupt and missing files. This works in most cases, where the issue is originated due to a system corruption. You can download Restoro by clicking the Download button below.

Download Now

I'm not interested