Unable to start mysql

bzero

Hello,

I am using Mariadb 10.3.22, but i am unable to start mysql service.
The slowlog show as below from panel:
/www/server/mysql/bin/mysqld, Version: 10.3.22-MariaDB-log (Source distribution). started with: Tcp port: 3306 Unix socket: /tmp/mysql.sock Time Id Command Argument /www/server/mysql/bin/mysqld, Version: 10.3.22-MariaDB-log (Source distribution). started with: Tcp port: 3306 Unix socket: /tmp/mysql.sock Time Id Command Argument /www/server/mysql/bin/mysqld, Version: 10.3.22-MariaDB-log (Source distribution). started with: Tcp port: 3306 Unix socket: /tmp/mysql.sock Time Id Command Argument /www/server/mysql/bin/mysqld, Version: 10.3.22-MariaDB-log (Source distribution). started with: Tcp port: 3306 Unix socket: /tmp/mysql.sock Time Id Command Argument

This is fresh install, aaPanel 6.6.6

Please advice how to fix the issue.
Thank you.

bzero

i think i found the issue, it's cause of root database password was not changed properly.
It's always reset to empty one. i tried with password without '@' , but none of them works.

Any idea how to correct the issue.
Thank you.

bzero

i found another thread which was similar issue.
https://www.aapanel.com/forum/d/259-database-password-is-incorrect-problem/23

I am using aaPanel 6.6.6 (fresh install) on CentOs 8 with Mariadb 10.3.22

bzero

i found a workaround way to fix the issue, by flushing privilege in mysql console.
Then, going back to aaPanel and change mysql password.

TheWormsUnited

bzero have you got the mail server app running?

bzero

TheWormsUnited , no it's not been installed.

aaPanel_Jose

bzero
Thanks for the information you provided, we will check this issue

bzero

perfect, thanks aaPanel_Jose
I'd update more info. If i created new database, then the root password is been reseted. I have to change it back again for each time new database is created.

aaPanel_Jose

bzero
Can I log in to your panel? I didn't find this problem in the code

bzero

aaPanel_Jose sure, how could i send you login info? i can't find PM feature.

By the way, this issue is still happening to me with 6.6.7, fresh install.

Thank you.

aaPanel_Jose

bzero
Please send to jose@aapanel.com

bzero

@aaPanel_Jose , i have sent you login info.
Thank you.

bzero

Today, i am facing another issue. All databases have been reseted/deleted password
i don't know why it's happening since it worked few days ago, but the log show database connection error for all of the web, it says wrong password.

It could be a bug ...

bzero

i stop and start mysql service from aaPanel, then "Sync All" and everything is back

bzero

@aaPanel_Jose have you found any thing? 🙂
thank you.