Can't contact the database server: Access denied for user 'wikiuser'@'localhost' (using password: NO) (localhost))

Jump to: navigation, search

Hi All,

I have installed the mediawiki in Redhat linux environment and all the installation with configuration are went fine, but in the end when I tried to access the mediawike i getting below error message:

Can't contact the database server: Access denied for user 'wikiuser'@'localhost' (using password: NO) (localhost)) I am not sure what was the problem i was able to login as wikiuser at wikidb (database).

Can someone help me what will be the issue and where I am wrong.

thanks in advance.

best Regards

Sriniu (talk)18:24, 29 October 2012

The error message states that you're trying to connect to the database in localhost using the 'wikiuser' user account but without specifying a password.

Be sure you specify a valid password for connecting to the database (configured in LocalSettings.php).

Ciencia Al Poder (talk)10:18, 30 October 2012

thanks for your reply.

yes i have give wikiuser password only. i tried to login in mysql with wikiuser and its password and it is working fine.

but not sure i am getting access denied error for wikiuser.

Sriniu (talk)20:43, 30 October 2012

Please, be sure that you've configured $wgDBpassword. It's not clear from your reply that you've done that.

Ciencia Al Poder (talk)19:57, 31 October 2012
    1. Database settings

$wgDBtype = "mysql"; $wgDBserver = "localhost"; $wgDBname = "wikidb"; $wgDBuser = "wikiuser"; $wgDBpassword = "wikiuser";


just want to recheck with you, i have copied LocalSettings.php file under /var/www/devwiki/ path, is it ok?

because all the mediawiki folder and files are under devwiki.

160.62.13.19010:08, 2 November 2012

Those settings seem okay.

Maybe the problem is the user. Note that on mysql the user is also associated to a host (localhost in this case). Try resetting the password: http://dev.mysql.com/doc/refman/5.0/en/assigning-passwords.html

You should do that for 'wikiuser'@'localhost', 'wikiuser'@'%' and 'wikiuser'@'yourhost', where "yourhost" is the hostname of the database.

Ciencia Al Poder (talk)10:20, 2 November 2012