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 to Install Sample Data in Magento?

This tutorial will teach you how to install Magento E-Commerce website with sample data (demo...

A subdomain that I have created isn't working.

Please note that subdomain requires DNS propagation and it may take upto 24 hours. If DNS...

How do I change document root folder to some sub-folder using an .htaccess file?

By default, the web-contents of your website will be loaded from the public_html directory. If...

Can I upgrade my shared hosting plan to VPS hosting?

Shared hosting plan cannot be upgraded to VPS hosting directly. You can purchase a separate VPS...

AccuWebHosting Offers PHP 7 Hosting

If you are following recent PHP developments, you must be aware of the latest PHP version (PHP 7)...

  • 0 Users Found This Useful

Was this answer helpful?