Advanced Search

— Forum Scope —




— Match —





— Forum Options —





Minimum search word length is 3 characters - maximum search word length is 84 characters

mail_open
SQLSTATE[28000] [1045] Access denied for user
christopher.oliver

Excellent
July 18, 2014 - 9:52 am
Member Since: June 27, 2014
Forum Posts: 18
sp_UserOfflineSmall Offline

Hi,

I am running an import and I am coming across this error:

error 1:SQLSTATE[28000] [1045] Access denied for user ‘XXXDATABASENAMEXXX’@’localhost’ (using password: YES) –

Could you please advise on how this is resolved?

Thanks
Chris

christopher.oliver

Excellent
July 18, 2014 - 10:05 am
Member Since: June 27, 2014
Forum Posts: 18
sp_UserOfflineSmall Offline

Fixed It!! Apologies for wasting any time you may have put into this!

Fix:
in app/etc/local.xml
my database name, username did not match with what was in MySQL or Magmi.

No idea how they changed but all the same now and working!!

NB in one they looked the same but after copy and paste it worked (must have been a mystery space)!

Cheers
Chris

Avatar
Matthew Ogborne

Founder
July 18, 2014 - 10:06 am
Member Since: July 18, 2013
Forum Posts: 4565
sp_UserOfflineSmall Offline

Howdy Chris,

Oh ace to hear.

And you’re not alone that’s caught me out in the past too :)

Matt

"Selling an item online is easy, but making living from a business that sells online, well that’s something different entirely!"

Ultimo Magento Theme

meirk

Not so New
June 16, 2015 - 5:35 pm
Member Since: March 27, 2015
Forum Posts: 7
sp_UserOfflineSmall Offline

Hi,

I`m getting the same error now, but I`m not sure how to fix. Can you kindly advise?

Thanks

Avatar
Jim @ Moogento
Global

Partner
June 17, 2015 - 2:01 am
Member Since: November 7, 2013
Forum Posts: 688
sp_UserOfflineSmall Offline

meirk said
I`m getting the same error now, but I`m not sure how to fix. Can you kindly advise?

As Christopher said above, open up app/etc/local.xml and check your database connection details match what your server control panel says it thinks they should be.

  • pickPack - smarter Magento packing sheets and warehouse picklists
  • shipEasy - process multiple orders with no sweat & get a visual sales overview easily

 

Why Should You Join UnderstandingE?

 
  • Access to over 500 step-by-step video tutorials
  • +20 video courses available
  • Magento, M2E Pro, Magmi, eBay, Amazon & Design all covered
  • Everything is in 100% Plain English
  • Learn how to build your own multi-channel software for eBay & Amazon
  • Access to the community forums, meet fellow business owners like yourself

Join Now with 2 Clicks

 

Join now for less that £1 per day you can gain access to over 400 step-by-step video tutorials & learn how to build your very own multi-channel software.

 

Forum Timezone: Europe/London

Most Users Ever Online: 1012

Currently Online:
26 Guest(s)

Currently Browsing this Page:
1 Guest(s)

Top Posters:

Jim @ Moogento: 688

Steve Froggatt: 514

Badeth - UE: 513

Jimbob: 453

Paul Cartwright: 414

Forum Stats:

Groups: 6

Forums: 37

Topics: 5221

Posts: 27485

Administrators: Matthew Ogborne: 4565, Dave Furness: 4606