Technobezz

#1044 – Access denied for user ‘username1’@’localhost’ to database ‘wrdp9

#1044 – Access denied for user ‘username1’@’localhost’ to database ‘wrdp9 and #1044 – Access denied for user ‘username1’@’localhost’ to database ‘user2_wrdp9’   is a very popular error that’s found among most the popluar web hosting like –godaddy, hostgator 

 

the main reason why you getting 1044 access denied for user to database phpmyadmin  when importing an sql file to a database via phpMyAdmin is because of “The username of the SQL  do not match of that for the Username of you Database(host)”

I heard people complaining – They are exporting an SQL database from another host, then import it to their new host database via phpmyadmin and getting this error” #1044 - Access denied for user 'root'@'localhost' to database 'information_schema'"

 

How to fix #1044 – Access denied for user

In this case i am transferring database SQL from IPage to Godady

>Login to your host where you are exporting the Databse SQL from (IPAGE)

>Export your database.Make sure to check -Enclose Export in a transaction

#1044 - Access denied for user 'username1'@'localhost' to database 'wrdp9

>Save as NONE, and press go

SASASAS

 

>Locate the username of that Database from where you exporting the SQL From (IPAGE)

  • (pncvuEsiE6a) is mines

>Now, move over to your next host where you want to import the SQl database

>IMPORTANT- Create a new database with the same username  as your SQL Exported Database..In this case i will be using -pncvuEsiE6a

#1044 - Access denied for user 'username1'@'localhost' to database 'wrdp9

 

You can see here i do not get the -#1044 – Access denied for user ‘username1’@’localhost’ to database ‘wrdp9 error  because i have matched the Godday database username with my Ipgae Exported SQL Database

Few people suggest manually editing the SQL file to alter the username to match the created database on the sever..But that can cause some error,only do if you have expertise in SQL.

More on this topic

Best Smoothie Makers in 2020

We all need a blender in the kitchen for whipping up smoothies and shakes. Check out some of the best smoothie makers available today. There are many reliable, commercial-grade blenders

Best stand mixers in 2020

Stand mixers are useful appliances that make life easier in the average household. With these, you can come up with enough dough to make dozens of cookies or make milkshakes

Top Best Blenders to buy in 2020

A blender is a cool unit to feature in your perfect kitchen. Blenders are ideally used to crush, grind or make a pulpy, fresh juice out of any ingredient that

Best Laptops for Freelancers To Buy In 2020

Freelancing is a fun way to make a living because most freelancers get to work at their own pace, from their choice of location. Being always on the move demands

Best Ultrabooks Under $500 Of 2020

The laptops and ultrabooks have come a long way since the assumption that those that are budget-friendly aren’t good. Google changed this view with their cheap Chromebooks with amazing build

Leave a Reply

2 Comments

  1. Kashif Latif October 10, 2014
  2. Kashif Latif October 10, 2014