#1045 - Access denied for user ‘root’@’localhost’ (using password: YES)

[mrchow19910319]

Little background: I used digital ocean to create a wordpress site. 
I used the one click install they provided on their page and now my wordpress site is running. 
And I followed this guide to do some preparation: 

https://www.digitalocean.com/community/tutorials/how-to-use-the-wordpress-one-click-install-on-digitalocean#next-steps

 

And then I followed the last step where they teach you how to install phpMyadmin GUI. 
(this article): 
https://www.digitalocean.com/community/tutorials/how-to-install-and-secure-phpmyadmin-on-ubuntu-16-04

 

However after installing it I cannot log into it, neither from the GUI nor from command line works. 
Both of them gave me this error: 

Quote

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

I did a simple google search and I found that I need to edit this file: 
config.inc.php 
And manually add in mySQL password. 

But I cannot find this file on my Ubuntu server... Where can I find it and can I edit it inside terminal? 
If so, how to do that ? 

I key in pwd in terminal it shows me i am at root. But ls gives me nothing. 
How do I edit that file then? 

Thanks in advance.

[Windows7ge]

I don't know about where you can find it but when you do you can edit it with vi or vim.

[BeefyMeats]

You could install mlocate than run updatedb, than search everywhere for the file.

[Fetzie]

7 hours ago, mrchow19910319 said:

But I cannot find this file on my Ubuntu server... Where can I find it and can I edit it inside terminal? 
If so, how to do that ? 

I key in pwd in terminal it shows me i am at root. But ls gives me nothing. 
How do I edit that file then? 

Thanks in advance.

Is the webserver running as the user "root"? (it shouldn't be, that is a massive security no-no :))

The config.inc.php file for phpmyadmin is located in /etc/phpmyadmin/

 

edit it with vi or vim (ESC then enter " :wq " to save and exit
 

[vorticalbox]

7 hours ago, Fetzie said:

Is the webserver running as the user "root"? (it shouldn't be, that is a massive security no-no :))

So is hard coding a password in a file.