Post #282,729
4/23/07 10:48:27 AM
|
phpmyadmin weirdness
This specific form of weridness is definiately a Linux problem...
I've tried to log in to phpmyadmin with the user I created for it, and I get this error message:
#1045 - Access denied for user 'www-data'@'localhost' (using password: YES)
www-data is the group for /var/www... so... wha?
"We are all born originals -- why is it so many of us die copies?" - Edward Young
|
Post #282,840
4/23/07 9:29:15 PM
|
That's a MySQL error, not a Linux error.
You are attempting to connect to MySQL with the user 'www-data' and it's telling you that you can't. It won't tell you why, however, so it will be one of: that user doesn't exist in MySQL, that user cannot connect from localhost, or you got the password wrong.
MySQL has it's own user database, in case I have to mention that.
Wade.
Is it enough to love Is it enough to breathe Somebody rip my heart out And leave me here to bleed
| | Is it enough to die Somebody save my life I'd rather be Anything but Ordinary Please
|
-- "Anything but Ordinary" by Avril Lavigne. | · my · · [link|http://staticsan.livejournal.com/|blog] · · [link|http://yceran.org/|website] · |
|
Post #282,870
4/24/07 9:29:34 AM
|
I am much too talented for you lot. :)
Guess what I did. No, seriously. Guess.
nevermind, I'll tell you.
I managed to delete ALL my mysql login accounts.
Including the root account.
Damn I'm good.
Now the "www-data" error is a COMPLETE NONISSUE. Problem solved.
...
"We are all born originals -- why is it so many of us die copies?" - Edward Young
|
Post #282,879
4/24/07 9:55:52 AM
|
Fodder for your comic, perhaps? :-)
Sounds like something that could appear in Kernel Panic. It's a good trick, deleting all the MySQL accounts. In really old versions of MySQL it was quite difficult to recover from, too.
Wade.
P.S. I work with MySQL for a living, can't ya tell? :-D
Is it enough to love Is it enough to breathe Somebody rip my heart out And leave me here to bleed
| | Is it enough to die Somebody save my life I'd rather be Anything but Ordinary Please
|
-- "Anything but Ordinary" by Avril Lavigne. | · my · · [link|http://staticsan.livejournal.com/|blog] · · [link|http://yceran.org/|website] · |
|
Post #282,881
4/24/07 9:57:40 AM
|
DEFINITELY fodder for KP
... so how exactly *would* I fix this? I have no clue. I guess there's a file somewhere I need to edit?
"We are all born originals -- why is it so many of us die copies?" - Edward Young
|
Post #282,897
4/24/07 11:18:13 AM
|
I figured it out...
... although phpmyadmin STILL thinks I'm logging in as 'www-data'@'localhost' when I use the non-root login.
"We are all born originals -- why is it so many of us die copies?" - Edward Young
|
Post #282,905
4/24/07 12:31:36 PM
|
Fixed it.
And by "fixed it" I mean "reinstalled it." But it's fixed all the same.
"We are all born originals -- why is it so many of us die copies?" - Edward Young
|
Post #282,988
4/24/07 10:25:20 PM
|
Sorry, I thought you'd fixed it earlier.
Definitely the easiest way to fix that problem if you have an otherwise empty database is just re-install it. But there is a script installed with MySQL that creates the empty permissions tables so you can recover. I can't find it mentioned in the online docs, that's all.
As for the problem with phpMyAdmin; that's the configuration of phpMyAdmin. It can do security a few different ways. It sounds like you want it to use the MySQL users, which by default I don't think it does. The configuration file has the information to change it.
Wade.
Is it enough to love Is it enough to breathe Somebody rip my heart out And leave me here to bleed
| | Is it enough to die Somebody save my life I'd rather be Anything but Ordinary Please
|
-- "Anything but Ordinary" by Avril Lavigne. | · my · · [link|http://staticsan.livejournal.com/|blog] · · [link|http://yceran.org/|website] · |
|
Post #283,023
4/25/07 7:50:46 AM
|
The funny thing is...
... I thought when I uninstalled phpmyadmin and then uninstalled mysql it would nuke all my existing databases (so I backed them up first!)
But when I reinstalled both I found that not only were the databases still intact, but all my users were still there as well -- only without the odd permissions problems!
All I had to do was give the root login a password.
"We are all born originals -- why is it so many of us die copies?" - Edward Young
|
Post #283,078
4/25/07 5:24:09 PM
|
That is a setup question it asks you...
Debconf specifically asks if you want it to remove all data if you remove and purge the config. Unfortunately, it is a question at *INSTALLATION* and not at removal... DUH!
-- [link|mailto:greg@gregfolkert.net|greg], [link|http://www.iwethey.org/ed_curry|REMEMBER ED CURRY!] @ iwetheyFreedom is not FREE. Yeah, but 10s of Trillions of US Dollars? SELECT * FROM scog WHERE ethics > 0;
0 rows returned.
|
Post #286,937
6/13/07 3:02:42 AM
|
Re: I am much too talented for you lot. :)
hi, im wondering.. how do you manage to delete ALL your mysql login accounts?
|