ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: YES)

Discussion in 'Installation/Configuration' started by Peter Richardson, Aug 1, 2018.

  1. Peter Richardson

    Peter Richardson New Member

    Hi All,
    I'm trying to install ISP Config on Debian 9, I'm using this tutorial:
    The Perfect Server - Debian 9 (Stretch) with Apache, BIND, Dovecot, PureFTPD and ISPConfig 3.1

    Getting stuck here:
    Step 10 - Install Apache2, PHP, FCGI, suExec, Pear, phpMyAdmin, and mcrypt

    and here:
    Step 19 - Install RoundCube

    Same issue for phpMyAdmin as RoundCube - it seems to be a password issue with MySQL / MariaDB (I chose MariaDB). Please see attached screenshot. I know I'm not typing the password wrong and I know it's the right password because it's the same one I've used for the whole install for everything (not safe, I know I know). The password could be blank, which would make sense, but you can't enter a blank password because it offers to create a random password if you just leave it blank - but then on the next section (password confirmation) it says that the passwords don't match! But it created the passwords! I'm neither an expert, nor a total n00b, just learning, so please elaborate on answers. Many thanks!

    PS - I have also attached the output of the command:
    wget -q -O htf-common-issues.php "" && php -q htf-common-issues.php

    Attached Files:

    Last edited: Aug 1, 2018
  2. Peter Richardson

    Peter Richardson New Member

    I figured it out. The problem was that somehow the MySQL password was blank. I logged into MySQL and changed the password, flushed, logged out, logged back in to check that the password change worked, and SHAZAM!!!! If you need any more details or commands, just post and I'll let you know.
    Jesse Norell likes this.

Share This Page