Control Web Panel

WebPanel => MySQL => Topic started by: venty on June 02, 2025, 06:18:25 PM

Title: upgraded MariaDB, and to 10.11and does not recognize the database....
Post by: venty on June 02, 2025, 06:18:25 PM

Hi,

I used the instructions here:

https://kb.starburstservices.com/control-web-panel-cwp/control-web-panel-cwp-admin-tutorials/upgrade-mariadb-10-x-to-10-11-with-cwp-on-almalinux-9/

and upgraded MariaDB to 10.11....

Today, I had to create a new database with a user through the user panel. Everything went normally, but when I tried to use the database during WordPress installation, I encountered an error stating that it could not access the database.

I tested it several times, but it didn't work.. Then again, through the user panel, I "changed" the password of the database user (I copied and pasted the same one that I had set when creating the database), and everything worked - the WordPress installation accessed the database???

I haven't made any changes to the server, except that on 25.05 MariaDB was updated to 10.11.13 and I changed the root password.

When checking the status of the MySQL Database Server, I found the following entries:

Jun 02 20:59:19 hosting.mydomain.com mariadbd[1123]: 2025-06-02 20:59:19 682 [Warning] Aborted connection 682 to db: 'postfix' user: 'postfix' host: 'localhost' (Got an error reading communication packets)
Jun 02 21:03:04 hosting.mydomain.com  mariadbd[1123]: 2025-06-02 21:03:04 1234 [Warning] Aborted connection 1234 to db: 'postfix' user: 'postfix' host: 'localhost' (Got an error reading communication packets)
Jun 02 21:04:08 hosting.mydomain.com  mariadbd[1123]: 2025-06-02 21:04:08 1693 [Warning] Access denied for user 'hosmyd_k92test'@'localhost' (using password: YES)

Please help, what should I do?

BR
Venty

Title: Re: upgraded MariaDB, and to 10.11and does not recognize the database....
Post by: overseer on June 03, 2025, 12:09:58 AM

You didn't miss the last step? And you are indeed on EL9 (AlmaLinux 9)?

Code: [Select]

mysql_upgrade --force

Title: Re: upgraded MariaDB, and to 10.11and does not recognize the database....
Post by: venty on June 03, 2025, 04:35:39 AM

Hi,

What do you mean-.....miss the last step?????

 And you are indeed on EL9 (AlmaLinux 9)?
Yes, I use AlmaLinux 9.6....

BR
VK

Title: Re: upgraded MariaDB, and to 10.11and does not recognize the database....
Post by: Starburst on June 04, 2025, 02:50:21 AM

Steps 4 & 6 are critical with EL9/AL9.

WordPress should create the database automatically.

IF it doesn't then when you create the database, you also have to create the admin user for that database, then enter all that data when installing WordPress, overwriting the auto entry it's made.

Title: Re: upgraded MariaDB, and to 10.11and does not recognize the database....
Post by: venty on June 04, 2025, 03:51:57 AM

Quote from: Starburst on June 04, 2025, 02:50:21 AM

Steps 4 & 6 are critical with EL9/AL9.

.........

Hi,

many thanks for the help, but maybe it wasn't clear...

1. After installing the server (AL 9+CWP) manually, via:

https://kb.starburstservices.com/control-web-panel-cwp/control-web-panel-cwp-admin-tutorials/upgrade-mariadb-10-x-to-10-11-with-cwp-on-almalinux-9/

I updatedMariaDB to the current stable version 10.11.11 and everything worked normally...

2. I updated to MariaDB version 10.11.13, via CWP from the menu Server Settings-->Yam Manager ... and CWP updated MariaDB to version 10.11.13, automatically ... and then my problem started...

Can I repeat :

https://kb.starburstservices.com/control-web-panel-cwp/control-web-panel-cwp-admin-tutorials/upgrade-mariadb-10-x-to-10-11-with-cwp-on-almalinux-9/

so I will eventually delete version 10.11.13 and install it again, but according to the instructions...???

Pls, help...

BR
Venty

Title: Re: upgraded MariaDB, and to 10.11and does not recognize the database....
Post by: Starburst on June 04, 2025, 04:57:55 AM

Yea, only update via the CLI using

Code: [Select]

dnf --refresh update
A dependency might not have installed via that yum manager.

If you followed the guide, it should have installed the latest version of 10.11.x
Unless of course, you did the before 10.11.13 came out.

Try running the above CLI update command first.

If that fails, try the upgrade as a last resort.