IWETHEY v. 0.3.0 | TODO
1,095 registered users | 1 active user | 0 LpH | Statistics
Login | Create New User
IWETHEY Banner

Welcome to IWETHEY!

New 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] ·

New 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
New 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] ·

New 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
New 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
New 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
New 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] ·

New 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
New 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!] @ iwethey
Freedom is not FREE.
Yeah, but 10s of Trillions of US Dollars?
SELECT * FROM scog WHERE ethics > 0;

0 rows returned.
New Re: I am much too talented for you lot. :)
hi, im wondering.. how do you manage to delete ALL your mysql login accounts?
     phpmyadmin weirdness - (cwbrenn) - (10)
         That's a MySQL error, not a Linux error. - (static) - (9)
             I am much too talented for you lot. :) - (cwbrenn) - (8)
                 Fodder for your comic, perhaps? :-) - (static) - (6)
                     DEFINITELY fodder for KP - (cwbrenn) - (5)
                         I figured it out... - (cwbrenn) - (4)
                             Fixed it. - (cwbrenn) - (3)
                                 Sorry, I thought you'd fixed it earlier. - (static) - (2)
                                     The funny thing is... - (cwbrenn) - (1)
                                         That is a setup question it asks you... - (folkert)
                 Re: I am much too talented for you lot. :) - (ikanku15)

For office use only.
52 ms