Web lists-archives.com

Re: unable to connect to database in MediaWiki 1.27.4 installation

On 2018-07-08 17:53, Sharon Kimble wrote:
mick crane <mick.crane@xxxxxxxxx> writes:

On 2018-07-08 08:53, Sharon Kimble wrote:
I'm unable to get mediawiki from the repos working as it is consistently
failing at accessing the database as part of its configuration at the
beginning. I say 'consistently' as the same problem has occurred when
trying to install mediawiki from source, and this is a clean fresh
install so I think that it must be something in my /home because it is a
completely new fresh install. But what?

Can anyone give me some guidance here please, as I've been looking in my
/home for anything 'mariadb' or 'mysql'-like but without any success.

When I input my database details into
'http://localhost/mediawiki/mw-config/index.php?page=DBConnect' I get an
error message saying -

│DB connection error: Access denied for user 'root'@'localhost' (localhost).
│Check the host, username and password and try again.

To my thinking, its obviously comparing what I'm inputting into
something, and deciding that they don't match, so therefore giving me an
error message. But what is it comparing to?


I don't know what error you get if mysqld is not running but best see if it is

"ps ax | grep mysql"


Thanks for replying Mick.

This is what I get using a slightly better command than yours (you
missed out the 'u' in aux :)

a u x are options
│$ ps aux | grep mysql
│mysql      962  0.0  0.0 698580 65656 ?        Ssl  Jul07   0:59

Which is about right as I rebooted yesterday.

And I've just checked and I'm still not able to get past the 'Connect to
database' page in the mediawiki setup process.

I dunno what you've done or what mediawiki setup does, I think I might have installed it once for curiosity. I know little about mediawiki what I would do is look about for handy mysql commands so you can see what is what.

believe you can logon from system root to the root mysql account without a password and have a look what users and databases there are I'd probably do that and delete any mediawiki database and mediawiki users, create new ones with passwords I write down and input that to the mediawiki setup. What I'm uncertain about is changing the mysql root password if I might have told other things what it is.



Key ID    4BFEBB31