Web lists-archives.com

Re: unable to connect to database in MediaWiki 1.27.4 installation




On 2018-07-08 19:03, mick crane wrote:
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.

thinking a bit about it
any setup program probably only wants to know the mysql root password to create the users and database and once its done that it doesn't need it anymore so you could probably go ahead and change the mysql password to something you will remember.
I'm sure if given bad advice will be told off.

mick
--
Key ID    4BFEBB31