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

Do you have any limits for setting up Cron jobs or schedule tasks?

Windows Shared Hosting Plans:We do not offer cron jobs in Windows shared hosting plans. Linux...

MX Records Settings for SpamExperts in cPanel

To enable SpamExperts email filtering service, your domain’s MX records must be set to following...

How to add Swap Space in Centos 7.x?

First, let's understand what swap space is. In a Linux machine, swap space is used when the...

How to Reduce Spam in cPanel Hosting?

Nowadays Spam has become major annoyance with day to day email communications. You may have seen...

What is the URL to access my web based control panel?

For Linux users, the cPanel URL is www.<yourdomainname.com>:2083.For Windows users, the...

  • 0 Users Found This Useful

Was this answer helpful?