hi
i find root mysql pass in $HESTIA/conf/mysql.conf
but when i got to http://domaine.com/phpyadmin
login : root
pass : password in mysql.conf
i can’t acces
i’m wrong ?
thanks
stéphan
Run:
mysql -e “ALTER USER ‘root’@‘localhost’ IDENTIFIED BY ‘$mpass’; FLUSH PRIVILEGES;”
Where $mpass = rootpass word in config file
1 Like
I noticed that there is
CHARSETS=‘UTF8,LATIN1,WIN1250,WIN1251,WIN1252,WIN1256,WIN1258,KOI8’
in hestia’s mariadb config. Can I add UTF8MB4 to that list by adding it to that conf?
The password is stored at
/usr/local/hestia/conf/mysql.conf
To find out login and password for root access to MySQL you need to connect to the server via SSH, and open the file using a text editor, for example Nano:
nano /usr/local/hestia/conf/mysql.conf
It would look like this:
HOST='localhost' USER='root' PASSWORD='OLDPASSWORD' CHARSETS='UTF8,LATIN1,WIN1250,WIN1251,WIN1252,WIN1256,WIN1258,KOI8' MAX_DB='500' U_SYS_USERS='' U_DB_BASES='0' SUSPENDED='no' TIME='15:44:07' DATE='2023-12-30' PORT='3306'
Changing the MySQL user password in Hestia CP
Use this command to change your password:
mysqladmin -u root -pOLDPASSWORD password 'NEWPASSWORD'
After that, try going back to the mysql server with root privileges, using the new password you just created:
mysql -u root -pNEWPASSWORD
or
I myself have long been hampered by the fact that I can’t control all the bases at the same time. I finally found a solution. I’m glad! 