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: root@debian:~# 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)
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.
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.
This tutorial was posted today and it would've saved me lots of trouble when I wanted to update MySQL password https://www.howtoforge.com/setting-changing-resetting-mysql-root-passwords
