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

[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

[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

[jesterson]

cheers i'll give that a go

[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)

[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?

[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'.

[GabFunVake]

I use phpMyAdmin for access to the database.

[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?

[GabFunVake]

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

[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?

[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.

[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.

[the apprentice]

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"

[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.

[AlexSmirnov]

@ 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]

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

[AlexSmirnov]

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

[the apprentice]

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]

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]

proseg karot profesyonel karot ucları beton testereleri