Jump to content

Upgrade MariaDB 10.11 In CWP Centos 7 Centos 8 stream AlmaLinux 7/8 RockyLinux 7/8

Featured Replies

1 hour ago, Sandeep B. said:

Try

rpm -e --nodeps mysql-common-8.0.41-1.module_el8.10.0+3965+b415b607.x86_64

There are probably 20 of these conflicts

On 6/2/2023 at 9:42 AM, Sandeep B. said:
yum install MariaDB-server MariaDB-client net-snmp perl-DBD-MySQL -y

Warning: failed loading '/etc/yum.repos.d/mariadb.repo', skipping.
(this file is in the right location and has the following content:
name = MariaDB
baseurl = https://rpm.mariadb.org/10.11/centos/$releasever/$basearch
module_hotfixes = 1
gpgkey = https://rpm.mariadb.org/RPM-GPG-KEY-MariaDB
gpgcheck = 1
)

This is on a brand new server than my last failed attempt at doing this.  I dont know what to say, except this is not working for alma8.

Hi Sandeep,

The upgrade went with a few hiccups but i managed to it working. when i do

mysql -V it shows me mysql Ver 15.1 Distrib 10.11.11-MariaDB, for Linux (x86_64) using readline 5.1

but after i did the command

mysql_upgrade --force

and i scrolled up it gave me this :

mysql.transaction_registry OK

mysql.user OK

Phase 2/8: Installing used storage engines... Skipped

Phase 3/8: Running 'mysql_fix_privilege_tables'

Phase 4/8: Fixing views

mysql.user

Warning : The user specified as a definer ('mariadb.sys'@'localhost') does not exist

status : OK

sys.host_summary OK

the rest says all ok... behind.

is this an issue or ?

regards

Mike

On 4/21/2025 at 9:52 AM, Dutch_Mike said:

Hi Sandeep,

The upgrade went with a few hiccups but i managed to it working. when i do

mysql -V it shows me mysql Ver 15.1 Distrib 10.11.11-MariaDB, for Linux (x86_64) using readline 5.1

but after i did the command

mysql_upgrade --force

and i scrolled up it gave me this :

mysql.transaction_registry OK

mysql.user OK

Phase 2/8: Installing used storage engines... Skipped

Phase 3/8: Running 'mysql_fix_privilege_tables'

Phase 4/8: Fixing views

mysql.user

Warning : The user specified as a definer ('mariadb.sys'@'localhost') does not exist

status : OK

sys.host_summary OK

the rest says all ok... behind.

is this an issue or ?

regards

Mike

Recreate the user and try the upgrade again:

CREATE USER `mariadb.sys`@`localhost` ACCOUNT LOCK PASSWORD EXPIRE;

GRANT SELECT, DELETE ON `mysql`.`global_priv` TO `mariadb.sys`@`localhost`;

Create an account or sign in to comment