How does /usr/local/hestia/conf/mysql.conf get created/modified?

evonet · October 8, 2023, 9:37pm

I’m creating a script to change mysql root password. I see everything I need here:

hestiacp/hestiacp/blob/abbb22dcda89b950a37c93550ca8c4722dcca2c0/install/hst-install-ubuntu.sh#L1554-L1569


      
          # Securing MariaDB installation
          mpass=$(gen_pass)
          echo -e "[client]\npassword='$mpass'\n" > /root/.my.cnf
          chmod 600 /root/.my.cnf
          
          # Ater root password
          mysql -e "ALTER USER 'root'@'localhost' IDENTIFIED BY '$mpass'; FLUSH PRIVILEGES;"
          # Allow mysql access via socket for startup
          mysql -e "UPDATE mysql.global_priv SET priv=json_set(priv, '$.password_last_changed', UNIX_TIMESTAMP(), '$.plugin', 'mysql_native_password', '$.authentication_string', 'invalid', '$.auth_or', json_array(json_object(), json_object('plugin', 'unix_socket'))) WHERE User='root';"
          # Disable anonymous users
          mysql -e "DELETE FROM mysql.global_priv WHERE User='';"
          # Drop test database
          mysql -e "DROP DATABASE IF EXISTS test"
          mysql -e "DELETE FROM mysql.db WHERE Db='test' OR Db='test\\_%'"
          # Flush privileges
          mysql -e "FLUSH PRIVILEGES;"

I’d like update the new password at: /usr/local/hestia/conf/mysql.conf how hestia does it, but I can’t find where that happens in the code.

eris · October 8, 2023, 9:43pm

v-add-database-host does it…

How ever we don’t have edit currently implemented so use sed or do it manually

evonet · October 8, 2023, 9:45pm

Thank you!

system · November 7, 2023, 9:46pm

This topic was automatically closed 30 days after the last reply. New replies are no longer allowed.