Topic on Project:Support desk

Installing 1.29.1 on raspberry PI, can't connect to database

5
Windy54 (talkcontribs)

Hi,

I am trying to installing mediawiki 1.29.1 on a raspberry PI using Raspbian stretch by following these instructions

Manual:Running MediaWiki on Debian or Ubuntu

I get to this point

Connect to database

and keep getting the error

Cannot access the database: Access denied for user 'root'@'localhost' (0.0.0.0).

Check the host, username and password and try again.

I have had no errors up to this point, I have tried entering various values for

database host, name, prefix, username and password.

I am assuming that database name and prefix do not matter and the problem is host, username and password.

If I have logged into my PI is 0.0.0.0 okay for localhost?

Is username root okay?

I am convinced I am entering the password I created earlier on.

I have seen one similar question that was answered 3 years ago and the solution seemed to relate to not having a LocalSettins.php file

In the installation instructions I have not been prompted to create one yet, I believe that later on I should be prompted to download one.

After all of this explanation my question is, " do I need to create a LocalSettings.php file now?

thanks

Steve

2003:CC:ABC5:AC00:71D7:FD1D:C6AD:7F83 (talkcontribs)

Hi Steve!

In your error message, the IP address 0.0.0.0 looks strange. For localhost it should be 127.0.0.1.

If you have MySQL on your system, you can use the mysql executable to try logging in from there. That has the advantage that you do not have MediaWiki in between and you can just check that you can access the database correctly. Once you got that working, you can just use exactly the same data for MediaWiki.

Windy54 (talkcontribs)

I think that is going to help, I cant login as root so I am going to start again and make sure the password is correct. Also, when I try and complete the initialisation through chrome it might be trying to log me in as user pi which has not been added to the database.

I will investigate further and post back when I have sorted it.

thanks for the response

82.0.132.113 (talkcontribs)

After following the previous advice I came to the conclusion it is something to so with access rights and have got a vague memory of something changing in Raspbian Stretch.

I reverted to Jessie and have managed to install mediawiki, at some point I will investigate further and try it on JESSIE

97.87.175.49 (talkcontribs)

How can I remove you from my life my home and stop all this for good