Debian 9 (Stretch) - MySQL root password change

Discussion in 'ISPConfig 3 Priority Support' started by JohnnyBeGood, Oct 4, 2017.

  1. JohnnyBeGood

    JohnnyBeGood Member HowtoForge Supporter

    Hello,

    I downloaded virtual machine image that followed this tutorial https://www.howtoforge.com/tutorial...-9-stretch-apache-bind-dovecot-ispconfig-3-1/
    I was able to change keyboard from German to English, network, hostname etc. setting.
    When I got to the part about changing MySQL Login things started to go down and I was not able to login
    "Username or Password wrong."
    into https://server1.example.com:8080/
    I've tried using these commands https://www.faqforge.com/linux/controlpanels/ispconfig2/how-to-reset-the-mysql-root-password/
    Initially I thought issue was my new password because it had capital letter in it and special character !
    But even oversimplifying my password it I'm still unable to login.

    Changed passwords here /usr/local/ispconfig/server/lib/mysql_clientdb.conf
    and here /etc/mysql/debian.cnf

    any ideas?
    Code:
    [email protected]:~# service mysql status
    ● mariadb.service - MariaDB database server
       Loaded: loaded (/lib/systemd/system/mariadb.service; enabled; vendor preset: enabled)
       Active: active (running) since Tue 2017-10-03 23:40:53 CDT; 2min 6s ago
      Process: 1142 ExecStartPost=/bin/sh -c systemctl unset-environment _WSREP_START_POSITION (code=exited, status=0/SUCCESS)
      Process: 1139 ExecStartPost=/etc/mysql/debian-start (code=exited, status=0/SUCCESS)
      Process: 539 ExecStartPre=/bin/sh -c [ ! -e /usr/bin/galera_recovery ] && VAR= ||   VAR=`/usr/bin/galera_recovery`; [ $? -eq 0 ]   && systemctl set-environment _WSRE
      Process: 536 ExecStartPre=/bin/sh -c systemctl unset-environment _WSREP_START_POSITION (code=exited, status=0/SUCCESS)
      Process: 492 ExecStartPre=/usr/bin/install -m 755 -o mysql -g root -d /var/run/mysqld (code=exited, status=0/SUCCESS)
    Main PID: 774 (mysqld)
       Status: "Taking your SQL requests now..."
        Tasks: 28 (limit: 4915)
       CGroup: /system.slice/mariadb.service
               └─774 /usr/sbin/mysqld
    
    Oct 03 23:40:40 debian systemd[1]: Starting MariaDB database server...
    Oct 03 23:40:50 debian mysqld[774]: 2017-10-03 23:40:50 140440638325312 [Note] /usr/sbin/mysqld (mysqld 10.1.26-MariaDB-0+deb9u1) starting as process 774 ...
    Oct 03 23:40:53 debian systemd[1]: Started MariaDB database server.
    lines 1-17/17 (END)
    
    
     
  2. till

    till Super Moderator Staff Member ISPConfig Developer

    This is the ISPConfig login that you talk about? The ISPConfig logn does not use the MySQL root password. Maybe you changed the password of the MySQL user 'ispconfig', as thats the password that is used by ISPConfig interface.

    Regarding MySQL root password: Are you able to login with your new password in phpmyadmin and with the command 'mysql -h localhost -u root -p'? I assume that you changed the root password in MySQL already and not just in thes etwo config files.
     
  3. JohnnyBeGood

    JohnnyBeGood Member HowtoForge Supporter

    Thanks for the reply! Yes, this is ISPConfig login.
    After doing some troubleshooting using this command "mysql -u root -p" it was accepting my newly changed password. When I used this "mysql -u
    dbispconfig -p" it did not recognize clear passwod from /usr/local/ispconfig/server/lib/mysql_clientdb.conf
    So I used this https://blog.giuseppeurso.net/how-to-change-ispconfig-admin-password/ to update it and I was able to login right away!
    Hope it helps someone.
     
  4. JohnnyBeGood

    JohnnyBeGood Member HowtoForge Supporter

Share This Page