Ubuntu – Thesqladmin error while attempting to install MediaWiki on 14.10


I've been following this installation guide for MediaWiki on Ubuntu (https://www.mediawiki.org/wiki/Manual:Running_MediaWiki_on_Ubuntu#Step-By-Step) and I managed to get up to Configure MySQL->Regular Setup before I received an error. See I ran

mysqladmin -u root password "..."

(where … is my password) in the terminal and received the error:

mysqladmin: connect to server at 'localhost' failed
error: 'Access denied for user 'root'@'localhost' (using password: NO)'

I then tried changing root in this command to my username and this too failed. I then ran mysql_secure_installation to ensure I had my username & password right, I didn't so I changed my password and re-ran this command (with root this time, not my username) and this failed, again. Any idea of how I can overcome this error?

Best Answer

  • What i've read on that tutorial is this:

    This step is not necessary if you were prompted to create a mysql root password during MySQL installation.

    I recently reinstalled lamp and i remember having been prompted for MySQL root password during the installation. Most likely you have set your password already. If you don't remember having done so, try to change the password to a new one assuming that the default password ('') has been used:

    mysqladmin -u root -p '' password '<new_password>'
  • Related Question