Script install how to change myslq password

Discussion in 'Installation/Configuration' started by muekno, Feb 5, 2023.

  1. muekno

    muekno Active Member HowtoForge Supporter

    I did set up a new debian 11 server and installed ISPconfig useing the script. Thumbs Up for the scrip, well made.
    At the end I got password for the panel and mysql. Change the panel password no problem. But for mysql password where is it used, I can login to mysql with "mysql -u root" without beeing asked for a password. I know how to change a password in mysql. But what is the mysql password noted at the end of the for.
    Thank for any explanation.

    Nice sunday

    Rainer
     
  2. till

    till Super Moderator Staff Member ISPConfig Developer

    That's how Debian and Ubuntu set up MySQL in recent versions. The login is bound to your root shell user when using mysql command. That's why it does not ask separately for a password in this specific use case.

    The password is used for logging in as mysql root user, e.g. when you use phpmyadmin. And also ISPConfig is using it. ISPConfig stores the password in the file /usr/local/ispconfig/server/lib/mysql_clientdb.conf, so if you change it in mysql (which is not necessary as the script generated a long random password), then you must change it in that ISPConfig file too.
     
    muekno likes this.

Share This Page