How to Fix PhpMyAdmin Error 1044 Access denied for user

Hi, If you just trying to deploy your locally developed OpenCart, WordPress or Magento site on the live server and facing issue look like:

 #1044 - Access denied for user 'himstar'@'localhost' to database 'tricksway_cart'

or

CREATE DATABASE IF NOT EXISTS `tricksway_cart` DEFAULT CHARACTER SET latin1 COLLATE latin1_swedish_ci;.

Then you are at a right place, I'm going to share a complete tutorial about fixing such PhpMyAdmin issue.

Reason behind PhpMyAdmin #1044 - Access denied for user Error-

Let's assume you are creating an OpenCart eCommerce website, at the starting, you have to enter your database details in process of installation. Our first step to creating a database from local server, is it ? Definitely 'Yes'.

1044 - Access denied for user

 

After that, we simply enter 'root' as username and almost all of us leave password field for local server. When our task completed we uploaded every file easily on server but start getting error while uploading on database file, because-

1- You can't create direct database name on your live server (at least for shared server), for example, if your Cpanel username is 'name' then your database name will be somewhat-

name_*

2- In your local server your username is 'root', but still as above you can't create username root for a live server in PhpMyAdmin.

I think I cleared the actual point now we have to move on the solution.

Fix PhpMyAdmin Error 1044 Access denied

Process is very simple, just follow few steps carefully-

1- Login your Cpanel and create database and user (try to keep both names same) and provide user to all privileges for the same database.

mysql database user add

For Example:

Database: cpanelusername_test

Username: cpanelusername_test

2- Open your .sql file in any advanced text editor (Ex- Notepad++, Sublime Text etc).

3- Change .sql local database value as recently created live Cpanel username and database value, as below image.

1044 - Access denied for user -fixed

4- Import .sql file in live PhpMyAdmin above created database.

It Works !!, Let me know your feedback about this tutorial.

Himanshu is a young engineer living in India. Currently working at Cognizant as a Senior Engineer. He is an ethical hacker & blogger too, doing lots of crazy stuff... If you seem interesting, go through his portfolio: www.himstar.info : "Open Source. Millions of open minds can't be wrong!

One comment: On How to Fix PhpMyAdmin Error 1044 Access denied for user

Leave a reply:

Your email address will not be published.

This site uses Akismet to reduce spam. Learn how your comment data is processed.

Site Footer

Sliding Sidebar

We are India’s largest Startup Community


We are team of ' Delhi Startups ' , most active startup community with strict spam policy.
We are making !deas happen..for future, business and jobs without charging anything, with connecting entrepreneurs.. It's a reason to trust on us.
Come and join or subscribe, we will defiantly give a reason to like us.

Our Facebook Page