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?

Thanks
Sharon.

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

"ps ax | grep mysql"


mick

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
/usr/sbin/mysqld
╰────

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.

mick


Thanks
Sharon.

--
Key ID    4BFEBB31