Page 1 of 1

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

Posted: Sat Mar 06, 2010 11:03 am
by jesterson
*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

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

Posted: Sat Mar 06, 2010 1:37 pm
by AlexSmirnov
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

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

Posted: Mon Mar 08, 2010 9:16 am
by jesterson
cheers i'll give that a go :) :)

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

Posted: Sun Jun 09, 2013 8:27 am
by GabFunVake
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)

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

Posted: Sun Jun 09, 2013 8:51 am
by Tonie
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?

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

Posted: Sun Jun 09, 2013 9:01 am
by GabFunVake
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'.

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

Posted: Sun Jun 09, 2013 9:03 am
by GabFunVake
I use phpMyAdmin for access to the database.

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

Posted: Sun Jun 09, 2013 9:44 am
by Tonie
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?

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

Posted: Sun Jun 09, 2013 10:28 am
by GabFunVake
That is correct - the admin area works fine. The front end produces the error.

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

Posted: Sun Jun 09, 2013 5:46 pm
by Tonie
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?

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

Posted: Sun Jun 09, 2013 10:16 pm
by GabFunVake
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.

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

Posted: Mon Jun 10, 2013 12:56 am
by GabFunVake
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.

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

Posted: Fri Mar 18, 2016 10:07 am
by the apprentice
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"

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

Posted: Fri Mar 18, 2016 11:42 am
by AlexSmirnov
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.

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

Posted: Fri Mar 18, 2016 11:43 am
by AlexSmirnov
@ the apprentice,

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

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

Posted: Fri Mar 18, 2016 11:49 am
by the apprentice
Yes, on that particular website yes, and unfortunately can't be updated

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

Posted: Fri Mar 18, 2016 12:06 pm
by AlexSmirnov
Fair enough. I hope though that you patched it up: https://watchful.li/end-of-life-securit ... n-ups.html

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

Posted: Fri Mar 18, 2016 1:44 pm
by the apprentice
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.

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

Posted: Thu Mar 24, 2016 7:31 pm
by the apprentice
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?

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

Posted: Fri Mar 03, 2017 8:58 am
by karotucu
proseg karot profesyonel karot ucları beton testereleri