Unable to find the phpmyadmin password

Abi · December 10, 2020, 5:22pm

Unable to find the phpmyadmin password in this path /usr/local/hestia/conf/mysql.conf

the config folder is empty. Can anyone help me to find the password or tell me why is it empty do I need to set the password ?

jtdoank · December 10, 2020, 8:46pm

did you mean root password or user?

if you mean is root please check Set mysql root password

if you mean an user, you should set manually when you creating db

hope it help
thanks

Raphael · December 11, 2020, 6:43am

I would not suggest to change the root password manualy, otherwise you’ll break hestia without updating it in your conf.

The pass will be added to this:

github.com

hestiacp/hestiacp/blob/22cab5d6a88935ffefb1c3847dc35d5ea29597e3/install/hst-install-ubuntu.sh#L1404


cp -f $HESTIA_INSTALL_DIR/mysql/$mycnf /etc/mysql/my.cnf
mysql_install_db >> $LOG
update-rc.d mysql defaults > /dev/null 2>&1
systemctl start mysql >> $LOG
check_result $? "mariadb start failed"
# Securing MariaDB installation
mpass=$(gen_pass)
mysqladmin -u root password $mpass >> $LOG
echo -e "[client]\npassword='$mpass'\n" > /root/.my.cnf
chmod 600 /root/.my.cnf
# Clear MariaDB Test Users and Databases
mysql -e "DELETE FROM mysql.user WHERE User=''"
mysql -e "DROP DATABASE test" > /dev/null 2>&1
mysql -e "DELETE FROM mysql.db WHERE Db='test' OR Db='test\\_%'"
mysql -e "DELETE FROM mysql.user WHERE user='';"
mysql -e "DELETE FROM mysql.user WHERE password='' AND authentication_string='';"
# Configuring phpMyAdmin

and here

github.com

hestiacp/hestiacp/blob/22cab5d6a88935ffefb1c3847dc35d5ea29597e3/install/hst-install-ubuntu.sh#L1820


        echo "  RemoteIPInternalProxy $pub_ip" >> remoteip.conf
    fi
    echo "</IfModule>" >> remoteip.conf
    sed -i "s/LogFormat \"%h/LogFormat \"%a/g" /etc/apache2/apache2.conf
    a2enmod remoteip >> $LOG
    systemctl restart apache2
fi
# Configuring MariaDB host
if [ "$mysql" = 'yes' ]; then
    $HESTIA/bin/v-add-database-host mysql localhost root $mpass
fi
# Configuring PostgreSQL host
if [ "$postgresql" = 'yes' ]; then
    $HESTIA/bin/v-add-database-host pgsql localhost postgres $ppass
fi
# Adding default domain
$HESTIA/bin/v-add-web-domain admin $servername
check_result $? "can't create $servername domain"

github.com

hestiacp/hestiacp/blob/22cab5d6a88935ffefb1c3847dc35d5ea29597e3/bin/v-add-database-host#L113-L115


# Adding host to conf
echo "$str" >> $HESTIA/conf/$type.conf
chmod 660 $HESTIA/conf/$type.conf

So the mysql.conf should not be empty, otherwise you probaly have removed it by mistake and you’lk need to reset the pw and trigger v-add-database-host again manually.

K.Hardy · April 8, 2021, 11:44am

Have you check the lines in config.inc.php in phpmyadmin directory? If your root account dont use any password set ‘AllowNoPassword’ to ‘TRUE’.