upgraded MariaDB, and to 10.11and does not recognize the database....

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

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

Code: [Select]

mysql_upgrade --force

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

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.

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

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.

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.

Hi,

1. Ok, 10.11.13 is the version released, but the question is 10.11.11 or 10.11.13, which do you think is better to use?

2. Using 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/ can I install version 10.11.11?!?

What should I do?

Thanks in advance!

BR
Venty

10.11.11 is part of the 10.11 LTS stable branch, so perfectly suitable for production use.
10.11.13 is still part of the LTS branch and the latest available, having all the bug fixes and improvements the MariaDB developers have included. So probably the best choice currently unless you need the newer features of the 11.x branch, in that case 11.4 LTS.

Those instructions are for 10.11 LTS branch, so when you install the MariaDB repo, it will install the latest 10.11.x version.

Unless you specify an older 10.11.x version manually.