MySQL : Access denied for user 'Mysql_dbuser'@'localhost' (using password: YES) in /home/cPanel_user/public_html/file path.php

You may face this error while using mysqli_connect function on your website.

Cause :

This may be an issue with all privileges of your mysql db user on database.

Fix :

You can fix this issue by entering the command through ssh or from cPanel.

(1) Command Line :

Below command will provide all the privilages to user on the database

grant all on .* to [email protected]; flush privileges;

(2) cPanel :

Please refer to the; below steps to fix this error if you have cPanel at your end.

  1. Login to your cPanel.

  2. Click on MySQL Databases.



  3. Go to Add User To Database section. Select your user and database in respective Drop-down and click on Add Button.



  4. Tick on All Privileges and click on Make Changes Button. It will provide all the permission for your database user to your database.



         This should fix your issue of Access denied for user 'Mysql_dbuser'@'localhost'

Related Articles

How do I create SRV record for my domain?

This article will assist you to add an SRV record to your domain. Services Resource Record (SRV)...

How to change Database Collation in MySQL Server from phpMyAdmin?

Collation is a configuration level setting in the MySQL. It directs how the character data will...

What is the Max_execution_time allowed for Linux shared server?

Default Max_execution_time on our Linux Shared Server is 30 seconds. We can set it to 60 Seconds...

Parse ASP pages as normal Text/HTML in cPanel server using MIME type

Problem statement One of our customers had some old .ASP file names on his website. The web...

How to install Invoice Ninja using Softaculous?

Softaculous is an application installer of cPanel. We can install Invoice Ninja through...

  • 0 Users Found This Useful

Was this answer helpful?