#1045 - Access denied for user 'root'@'localhost' (using pas

Joomla version 1.5 is end-of-life and are no longer supported. Please use Joomla 3.x instead.

Moderator: General Support Moderators

Forum rules
Forum Rules
Absolute Beginner's Guide to Joomla! <-- please read before posting, this means YOU.
Forum Post Assistant - If you are serious about wanting help, you will use this tool to help you post.
Locked
jesterson
Joomla! Apprentice
Joomla! Apprentice
Posts: 7
Joined: Wed Feb 17, 2010 3:28 pm

#1045 - Access denied for user 'root'@'localhost' (using pas

Post by jesterson » Sat Mar 06, 2010 11:03 am

*sigh* - I think I did something I shouldn't have.

I went into phpmyadmin and there was some warning about the root password not being set. So I set a password for it and when I go back in I have the following message;

Error
MySQL said:

#1045 - Access denied for user 'root'@'localhost' (using password: NO)

Connection for controluser as defined in your configuration failed.
phpMyAdmin tried to connect to the MySQL server, and the server rejected the connection. You should check the host, username and password in your configuration and make sure that they correspond to the information given by the administrator of the MySQL server.


:'( :'(


Is there a work around - I know what I have set the password to

User avatar
AlexSmirnov
Joomla! Hero
Joomla! Hero
Posts: 2682
Joined: Fri Sep 18, 2009 6:33 pm
Location: United Kingdom
Contact:

Re: #1045 - Access denied for user 'root'@'localhost' (using pas

Post by AlexSmirnov » Sat Mar 06, 2010 1:37 pm

hi jesterson,

please go to your configuration.php and change the var $password to your new password, like
var $password = '<your_new_password>';

hth

Alex

jesterson
Joomla! Apprentice
Joomla! Apprentice
Posts: 7
Joined: Wed Feb 17, 2010 3:28 pm

Re: #1045 - Access denied for user 'root'@'localhost' (using pas

Post by jesterson » Mon Mar 08, 2010 9:16 am

cheers i'll give that a go :) :)

GabFunVake
Joomla! Apprentice
Joomla! Apprentice
Posts: 19
Joined: Sun Jun 09, 2013 8:06 am
Location: Sydney, Australia
Contact:

Re: #1045 - Access denied for user 'root'@'localhost' (using

Post by GabFunVake » Sun Jun 09, 2013 8:27 am

I have a similar error, but cannot figure out the solution. I have reviewed this forum, and most similar issues seems related to config.php errors, but I cannot see any issues in mine. Here's how it happened:
1. I developed a new site on Localhost.
2. I moved it online by doing the following:
2.1. I copied all the files and folders.
2.2. I created a SQL backup and used that to create my new database. No Errors.
2.3. I updated all the db and path settings in the config.php file including settings for user, database, password, logs and tmp.

Results:
1. The admin site is up and running no problems. All information seems to be intact.
2. The site returns the error: Access denied for user 'root'@'localhost' (using ...

I will appreciate any assistance.
(File is attached)

User avatar
Tonie
Joomla! Master
Joomla! Master
Posts: 16553
Joined: Thu Aug 18, 2005 7:13 am

Re: #1045 - Access denied for user 'root'@'localhost' (using

Post by Tonie » Sun Jun 09, 2013 8:51 am

Are you sure the Mysql account online is 'root'? Root is not used online normally for access to the Mysql database. What is you database admin tool online?

GabFunVake
Joomla! Apprentice
Joomla! Apprentice
Posts: 19
Joined: Sun Jun 09, 2013 8:06 am
Location: Sydney, Australia
Contact:

Re: #1045 - Access denied for user 'root'@'localhost' (using

Post by GabFunVake » Sun Jun 09, 2013 9:01 am

No, I don't use the root account - by user account is 'wbusr' and that is what is in the config file. Yet the error refers to 'root'.

GabFunVake
Joomla! Apprentice
Joomla! Apprentice
Posts: 19
Joined: Sun Jun 09, 2013 8:06 am
Location: Sydney, Australia
Contact:

Re: #1045 - Access denied for user 'root'@'localhost' (using

Post by GabFunVake » Sun Jun 09, 2013 9:03 am

I use phpMyAdmin for access to the database.

User avatar
Tonie
Joomla! Master
Joomla! Master
Posts: 16553
Joined: Thu Aug 18, 2005 7:13 am

Re: #1045 - Access denied for user 'root'@'localhost' (using

Post by Tonie » Sun Jun 09, 2013 9:44 am

Now that I reread your original post, is it true that you can enter the Joomla administrator backend, but that the error is visibile when watching the frontpage?

GabFunVake
Joomla! Apprentice
Joomla! Apprentice
Posts: 19
Joined: Sun Jun 09, 2013 8:06 am
Location: Sydney, Australia
Contact:

Re: #1045 - Access denied for user 'root'@'localhost' (using

Post by GabFunVake » Sun Jun 09, 2013 10:28 am

That is correct - the admin area works fine. The front end produces the error.

User avatar
Tonie
Joomla! Master
Joomla! Master
Posts: 16553
Joined: Thu Aug 18, 2005 7:13 am

Re: #1045 - Access denied for user 'root'@'localhost' (using

Post by Tonie » Sun Jun 09, 2013 5:46 pm

Ok, than it's another issue. Since the backend is fine, it means that Joomla's configuration.php is ok and the settings in there are fine too. This means that those settings are done elsewhere. It there a possibility that there is an extension/module/plugin that required the database settings to be set? Any bridge to other software like an external forum?

GabFunVake
Joomla! Apprentice
Joomla! Apprentice
Posts: 19
Joined: Sun Jun 09, 2013 8:06 am
Location: Sydney, Australia
Contact:

Re: #1045 - Access denied for user 'root'@'localhost' (using

Post by GabFunVake » Sun Jun 09, 2013 10:16 pm

Hi
Thanks for all the help so far - you have narrowed down the issue.

I am using a template I bought (Joomlage0064-capture - Default). When I change the site template to something else - the site works!
So the issue must lie with the template. I will have a look and report what I find. I will also see if I can get support from Joomlage.

Thanks again.
-----------------------------------
Regards
Gabriel

GabFunVake
Joomla! Apprentice
Joomla! Apprentice
Posts: 19
Joined: Sun Jun 09, 2013 8:06 am
Location: Sydney, Australia
Contact:

Re: #1045 - Access denied for user 'root'@'localhost' (using

Post by GabFunVake » Mon Jun 10, 2013 12:56 am

OK - I sorted it out. I had a module that was assigned under the Joomlage0064-capture template, this failed to read the config file. I unloaded it and now everything works.

Thanks again for all the help.
-----------------------------------
Regards
Gabriel

the apprentice
Joomla! Guru
Joomla! Guru
Posts: 801
Joined: Wed Nov 18, 2009 3:53 pm

Re: #1045 - Access denied for user 'root'@'localhost' (using

Post by the apprentice » Fri Mar 18, 2016 10:07 am

GabFunVake wrote:The site returns the error: Access denied for user 'root'@'localhost' (using ...
I've tried many options but can't work out the issue I'm finding to overcome this Access denied error. I'm doing the reverse, from online to local, but if I use the simple PhpMyAdmin it says the database is too big, if I use BigDump it gives the 1045 error "Warning: mysqli::mysqli(): (HY000/1045): Access denied for user 'dbname'@'localhost' (using password: YES) in C:\xampp\htdocs\joomla15\bigdump.php on line 394"

User avatar
AlexSmirnov
Joomla! Hero
Joomla! Hero
Posts: 2682
Joined: Fri Sep 18, 2009 6:33 pm
Location: United Kingdom
Contact:

Re: #1045 - Access denied for user 'root'@'localhost' (using

Post by AlexSmirnov » Fri Mar 18, 2016 11:42 am

So, you say you are "The Apprentice", aha? Mmm, okey then. You are fired!

Just kidding!

Try deleting a few databases from inside your XAMPP phpMyAdmin and hopefully you will be able to clone your site in there.

User avatar
AlexSmirnov
Joomla! Hero
Joomla! Hero
Posts: 2682
Joined: Fri Sep 18, 2009 6:33 pm
Location: United Kingdom
Contact:

Re: #1045 - Access denied for user 'root'@'localhost' (using

Post by AlexSmirnov » Fri Mar 18, 2016 11:43 am

@ the apprentice,

I just noticed that this thread actually belongs to Joomla 1.5 forum category. Are you still running J! 1.5?

the apprentice
Joomla! Guru
Joomla! Guru
Posts: 801
Joined: Wed Nov 18, 2009 3:53 pm

Re: #1045 - Access denied for user 'root'@'localhost' (using

Post by the apprentice » Fri Mar 18, 2016 11:49 am

Yes, on that particular website yes, and unfortunately can't be updated

User avatar
AlexSmirnov
Joomla! Hero
Joomla! Hero
Posts: 2682
Joined: Fri Sep 18, 2009 6:33 pm
Location: United Kingdom
Contact:

Re: #1045 - Access denied for user 'root'@'localhost' (using

Post by AlexSmirnov » Fri Mar 18, 2016 12:06 pm

Fair enough. I hope though that you patched it up: https://watchful.li/end-of-life-securit ... n-ups.html

the apprentice
Joomla! Guru
Joomla! Guru
Posts: 801
Joined: Wed Nov 18, 2009 3:53 pm

Re: #1045 - Access denied for user 'root'@'localhost' (using

Post by the apprentice » Fri Mar 18, 2016 1:44 pm

AlexSmirnov wrote:Fair enough. I hope though that you patched it up: https://watchful.li/end-of-life-securit ... n-ups.html
Not that it's got to do anything with the thread but it's the 1st time I hear about this, I will look into it.

the apprentice
Joomla! Guru
Joomla! Guru
Posts: 801
Joined: Wed Nov 18, 2009 3:53 pm

Re: #1045 - Access denied for user 'root'@'localhost' (using

Post by the apprentice » Thu Mar 24, 2016 7:31 pm

AlexSmirnov wrote:Fair enough. I hope though that you patched it up: https://watchful.li/end-of-life-securit ... n-ups.html
For now I've just installed this: UploadFix15v3

But I didn't find a lot of info about that supposed end of life patch 20151221PATCH, are you sure this is safe and with no strings attached?

karotucu
Joomla! Fledgling
Joomla! Fledgling
Posts: 1
Joined: Fri Mar 03, 2017 8:41 am

Re: #1045 - Access denied for user 'root'@'localhost' (using pas

Post by karotucu » Fri Mar 03, 2017 8:58 am

proseg karot profesyonel karot ucları beton testereleri


Locked

Return to “Installation 1.5”