Hi, I have installed ispconfig 3. Then i have forgot database root password. And finally i have successfully change root password. But when i execute service mysqld start. I got this error : ● mariadb.service - MariaDB 10.3.39 database server Loaded: loaded (/lib/systemd/system/mariadb.service; enabled; vendor preset: enabled) Drop-In: /etc/systemd/system/mysql.service.d └─limits.conf Active: failed (Result: exit-code) since Fri 2024-01-26 10:25:30 WIB; 29s ago Docs: man:mysqld(8) https://mariadb.com/kb/en/library/systemd/ Process: 3546 ExecStartPre=/usr/bin/install -m 755 -o mysql -g root -d /var/run/mysqld (code=exited, status=0/SUCCESS) Process: 3557 ExecStartPre=/bin/sh -c systemctl unset-environment _WSREP_START_POSITION (code=exited, status=0/SUCCESS) Process: 3558 ExecStartPre=/bin/sh -c [ ! -e /usr/bin/galera_recovery ] && VAR= || VAR=`cd /usr/bin/..; /usr/bin/galera_recovery`; [ $? -eq 0 ] && systemctl set-environment _WSREP_> Process: 3606 ExecStart=/usr/sbin/mysqld $MYSQLD_OPTS $_WSREP_NEW_CLUSTER $_WSREP_START_POSITION (code=exited, status=1/FAILURE) Main PID: 3606 (code=exited, status=1/FAILURE) Status: "MariaDB server is down" Jan 26 10:24:58 host systemd[1]: Starting MariaDB 10.3.39 database server... Jan 26 10:25:30 host systemd[1]: mariadb.service: Main process exited, code=exited, status=1/FAILURE Jan 26 10:25:30 host systemd[1]: mariadb.service: Failed with result 'exit-code'. Jan 26 10:25:30 host systemd[1]: Failed to start MariaDB 10.3.39 database server.
Is this a single server setup? You need to tell ISPConfig the new database password. I found this with Internet Search Engines using Code: site:howtoforge.com change database password https://forum.howtoforge.com/threads/ispconfig-mysql-root-user-password.79383/ To start database, do not use "But when i execute service mysqld start" , the command is Code: systemctl start mariadb.service If it fails to start, examine Code: systemctl status mariadb.service and read log files and possible error messages the start command shows.
