[wplug] MySQL Root Password Craziness with MediaWiki

[Jason Jerome]

This might be totally off the mark, but have you checked if the root
user is losing their Host information?  This issue has caught me a few
times.

On my test system I don't have the restriction on Host.  When I look at
the user table (in the mysql db) there are 2 entries for the root user,
each one with a different host: one with 'localhost', and the other
with the '%' symbol.  

In the past, I have created users without the correct Host information,
and ran into some problems logging in with that user.  I'm not a MySQL
guru, but maybe this will help.  


 



--- "Michael P. O Connor" <mpop at mikeoconnor.net> wrote:

> I would say create the user and blank database and just give that
> info
> to MediaWiki, there is no reason that any program should be given any
> type of root access, I have setup 2 MediaWiki's with out giving it a
> MySQL root password, just create the user and database first then
> give
> that info to MediaWiki and it will work well from there.
> 
> > Hello wplug. 
> > 
> > I have a Fedora Core 2 server that has lately become a sort of wiki
> 
> > repository for my organization. We're using the MediaWiki PHP/MySQL
> 
> > solution that I've deployed elsewhere without incident. 
> > 
> > I've had a problem with MySQL, though, that I've managed to trace
> back to 
> > the creation of a new wiki. Essentially, after a new wiki is
> configured 
> > (which takes the MySQL root password to make new users), MySQL no
> longer 
> > allows root login, even with the correct password. 
> > 
> > A restart of MySQL solves the problem, but it's something that I'd
> like to 
> > avoid if I can. Obviously the problem is somewhere in MediaWiki,
> but I 
> > don't even really know what to look for in the code. Are there any
> MySQL 
> > gurus who have seen the root password start acting weird like that?
> 
> > 
> > Thanks for the help. 
> > 
> > ---------------
> > Shane J.M. Liesegang
> > Masters Candidate 2006
> > Entertainment Technology Center
> > Carnegie Mellon University
> > 
> > _______________________________________________
> > wplug mailing list
> > wplug at wplug.org
> > http://www.wplug.org/mailman/listinfo/wplug
> > 
> > 
> 
> -- 
> Michael P. O'Connor
> mpop at mikeoconnor.net
> http://www.mikeoconnor.net
> 
> _______________________________________________
> wplug mailing list
> wplug at wplug.org
> http://www.wplug.org/mailman/listinfo/wplug
> 



		
__________________________________ 
Do you Yahoo!? 
Meet the all-new My Yahoo! - Try it today! 
http://my.yahoo.com