#1045 - Access denied for user 'root'@'localhost' (using pas
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.
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.
-
- Joomla! Apprentice
- Posts: 7
- Joined: Wed Feb 17, 2010 3:28 pm
#1045 - Access denied for user 'root'@'localhost' (using pas
*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
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
- AlexSmirnov
- 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
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
please go to your configuration.php and change the var $password to your new password, like
var $password = '<your_new_password>';
hth
Alex
-
- Joomla! Apprentice
- Posts: 7
- Joined: Wed Feb 17, 2010 3:28 pm
Re: #1045 - Access denied for user 'root'@'localhost' (using pas
cheers i'll give that a go
-
- 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
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)
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)
- Tonie
- Joomla! Master
- Posts: 16553
- Joined: Thu Aug 18, 2005 7:13 am
Re: #1045 - Access denied for user 'root'@'localhost' (using
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?
-
- 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
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'.
-
- 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
I use phpMyAdmin for access to the database.
- Tonie
- Joomla! Master
- Posts: 16553
- Joined: Thu Aug 18, 2005 7:13 am
Re: #1045 - Access denied for user 'root'@'localhost' (using
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?
-
- 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
That is correct - the admin area works fine. The front end produces the error.
- Tonie
- Joomla! Master
- Posts: 16553
- Joined: Thu Aug 18, 2005 7:13 am
Re: #1045 - Access denied for user 'root'@'localhost' (using
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?
-
- 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
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.
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
Regards
Gabriel
-
- 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
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.
Thanks again for all the help.
-----------------------------------
Regards
Gabriel
Regards
Gabriel
-
- Joomla! Guru
- Posts: 801
- Joined: Wed Nov 18, 2009 3:53 pm
Re: #1045 - 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"GabFunVake wrote:The site returns the error: Access denied for user 'root'@'localhost' (using ...
- AlexSmirnov
- 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
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.
Just kidding!
Try deleting a few databases from inside your XAMPP phpMyAdmin and hopefully you will be able to clone your site in there.
- AlexSmirnov
- 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
@ the apprentice,
I just noticed that this thread actually belongs to Joomla 1.5 forum category. Are you still running J! 1.5?
I just noticed that this thread actually belongs to Joomla 1.5 forum category. Are you still running J! 1.5?
-
- Joomla! Guru
- Posts: 801
- Joined: Wed Nov 18, 2009 3:53 pm
Re: #1045 - Access denied for user 'root'@'localhost' (using
Yes, on that particular website yes, and unfortunately can't be updated
- AlexSmirnov
- 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
Fair enough. I hope though that you patched it up: https://watchful.li/end-of-life-securit ... n-ups.html
-
- Joomla! Guru
- Posts: 801
- Joined: Wed Nov 18, 2009 3:53 pm
Re: #1045 - Access denied for user 'root'@'localhost' (using
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.AlexSmirnov wrote:Fair enough. I hope though that you patched it up: https://watchful.li/end-of-life-securit ... n-ups.html
-
- Joomla! Guru
- Posts: 801
- Joined: Wed Nov 18, 2009 3:53 pm
Re: #1045 - Access denied for user 'root'@'localhost' (using
For now I've just installed this: UploadFix15v3AlexSmirnov wrote:Fair enough. I hope though that you patched it up: https://watchful.li/end-of-life-securit ... n-ups.html
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?
-
- Joomla! Fledgling
- Posts: 1
- Joined: Fri Mar 03, 2017 8:41 am
Re: #1045 - Access denied for user 'root'@'localhost' (using pas
proseg karot profesyonel karot ucları beton testereleri