MariaDB [(none)]> show grants for 'myuser'@'%'; +-------------------------------------------------------------------------------------------------------+ | Grants for myuser@% | +-------------------------------------------------------------------------------------------------------+ | GRANT USAGE ON *.* TO `myuser`@`%` IDENTIFIED BY PASSWORD '*4FE9FC363621CBAB88C2E6E996DA470EF3698260' | | GRANT SELECT ON `mysql`.`user` TO `myuser`@`%` | | GRANT EXECUTE ON PROCEDURE `sys`.`table_exists` TO `myuser`@`%` | | GRANT EXECUTE ON FUNCTION `sys`.`quote_identifier` TO `myuser`@`%` | +-------------------------------------------------------------------------------------------------------+ 4 rows in set (0.001 sec) MariaDB [(none)]> show grants for 'myuser1'@'%'; +--------------------------------------------------------------------------------------------------------+ | Grants for myuser1@% | +--------------------------------------------------------------------------------------------------------+ | GRANT USAGE ON *.* TO `myuser1`@`%` IDENTIFIED BY PASSWORD '*3C3AA21CBD381A2327556774D842B06965083D83' | | GRANT SELECT ON `mysql`.`user` TO `myuser1`@`%` | | GRANT EXECUTE ON PROCEDURE `sys`.`table_exists` TO `myuser1`@`%` | | GRANT EXECUTE ON FUNCTION `sys`.`quote_identifier` TO `myuser1`@`%` | +--------------------------------------------------------------------------------------------------------+ 4 rows in set (0.002 sec) MariaDB [(none)]> SELECT * -> FROM mysql.procs_priv -> WHERE User='myuser' -> AND Db='sys'; +------+-----+--------+------------------+--------------+----------------+-----------+---------------------+ | Host | Db | User | Routine_name | Routine_type | Grantor | Proc_priv | Timestamp | +------+-----+--------+------------------+--------------+----------------+-----------+---------------------+ | % | sys | myuser | table_exists | PROCEDURE | root@localhost | Execute | 0000-00-00 00:00:00 | | % | sys | myuser | quote_identifier | FUNCTION | root@localhost | Execute | 0000-00-00 00:00:00 | +------+-----+--------+------------------+--------------+----------------+-----------+---------------------+ 2 rows in set (0.004 sec) MariaDB [(none)]> SELECT * FROM mysql.procs_priv WHERE User='myuser1' AND Db='sys'; +------+-----+---------+------------------+--------------+----------------+-----------+---------------------+ | Host | Db | User | Routine_name | Routine_type | Grantor | Proc_priv | Timestamp | +------+-----+---------+------------------+--------------+----------------+-----------+---------------------+ | % | sys | myuser1 | table_exists | PROCEDURE | root@localhost | Execute | 0000-00-00 00:00:00 | | % | sys | myuser1 | quote_identifier | FUNCTION | root@localhost | Execute | 0000-00-00 00:00:00 | +------+-----+---------+------------------+--------------+----------------+-----------+---------------------+ 2 rows in set (0.002 sec) MariaDB [(none)]> select @@version; +------------------+ | @@version | +------------------+ | 10.11.15-MariaDB | +------------------+ 1 row in set (0.000 sec) [root@replica1 ~]# ./mariadb_repo_setup --mariadb-server-version="mariadb-11.4.10" # [info] Checking for script prerequisites. # [warning] Found existing file at /etc/yum.repos.d/mariadb.repo. Moving to /etc/yum.repos.d/mariadb.repo.old_2 # [info] MariaDB Server version 11.4.10 is valid # [info] Repository file successfully written to /etc/yum.repos.d/mariadb.repo # [info] Adding trusted package signing keys... /etc/pki/rpm-gpg ~ ~ # [info] Successfully added trusted package signing keys # [info] Cleaning package cache... 57 files removed [root@replica1 ~]# yum install MariaDB-server Last metadata expiration check: 0:02:49 ago on Wednesday 10 June 2026 03:59:00 AM. Dependencies resolved. ============================================================================================================================================================================================================================================= Package Architecture Version Repository Size ============================================================================================================================================================================================================================================= Installing: MariaDB-server x86_64 11.4.10-1.el9 mariadb-main 19 M Installing dependencies: MariaDB-client x86_64 11.4.10-1.el9 mariadb-main 9.4 M MariaDB-common x86_64 11.4.10-1.el9 mariadb-main 88 k MariaDB-shared x86_64 11.4.10-1.el9 mariadb-main 130 k boost-program-options x86_64 1.75.0-13.el9_7 appstream 104 k galera-4 x86_64 26.4.25-1.el9 mariadb-main 1.2 M mysql-selinux noarch 1.0.14-1.el9_6 appstream 36 k perl-File-Copy noarch 2.34-483.el9 appstream 19 k perl-Sys-Hostname x86_64 1.23-483.el9 appstream 16 k Installing weak dependencies: MariaDB-client-compat noarch 11.4.10-1.el9 mariadb-main 11 k MariaDB-server-compat noarch 11.4.10-1.el9 mariadb-main 9.0 k socat x86_64 1.7.4.1-8.el9 appstream 299 k Transaction Summary ============================================================================================================================================================================================================================================= Install 12 Packages Total download size: 30 M Installed size: 237 M Is this ok [y/N]: y Before running mariadb-upgrade [root@replica1 ~]# mariadb Welcome to the MariaDB monitor. Commands end with ; or \g. Your MariaDB connection id is 3 Server version: 11.4.10-MariaDB MariaDB Server Copyright (c) 2000, 2018, Oracle, MariaDB Corporation Ab and others. Type 'help;' or '\h' for help. Type '\c' to clear the current input statement. MariaDB [(none)]> SELECT * FROM mysql.procs_priv WHERE User='suresh' AND Db='sys'; Empty set (0.010 sec) MariaDB [(none)]> SELECT * FROM mysql.procs_priv WHERE User='myuser1' AND Db='sys'; +------+-----+---------+------------------+--------------+----------------+-----------+---------------------+ | Host | Db | User | Routine_name | Routine_type | Grantor | Proc_priv | Timestamp | +------+-----+---------+------------------+--------------+----------------+-----------+---------------------+ | % | sys | myuser1 | table_exists | PROCEDURE | root@localhost | Execute | 0000-00-00 00:00:00 | | % | sys | myuser1 | quote_identifier | FUNCTION | root@localhost | Execute | 0000-00-00 00:00:00 | +------+-----+---------+------------------+--------------+----------------+-----------+---------------------+ 2 rows in set (0.002 sec) MariaDB [(none)]> SELECT * FROM mysql.procs_priv WHERE User='myuser' AND Db='sys'; +------+-----+--------+------------------+--------------+----------------+-----------+---------------------+ | Host | Db | User | Routine_name | Routine_type | Grantor | Proc_priv | Timestamp | +------+-----+--------+------------------+--------------+----------------+-----------+---------------------+ | % | sys | myuser | table_exists | PROCEDURE | root@localhost | Execute | 0000-00-00 00:00:00 | | % | sys | myuser | quote_identifier | FUNCTION | root@localhost | Execute | 0000-00-00 00:00:00 | +------+-----+--------+------------------+--------------+----------------+-----------+---------------------+ 2 rows in set (0.005 sec) MariaDB [(none)]> show grants for 'myuser'@'%'; +-------------------------------------------------------------------------------------------------------+ | Grants for myuser@% | +-------------------------------------------------------------------------------------------------------+ | GRANT USAGE ON *.* TO `myuser`@`%` IDENTIFIED BY PASSWORD '*4FE9FC363621CBAB88C2E6E996DA470EF3698260' | | GRANT SELECT ON `mysql`.`user` TO `myuser`@`%` | | GRANT EXECUTE ON PROCEDURE `sys`.`table_exists` TO `myuser`@`%` | | GRANT EXECUTE ON FUNCTION `sys`.`quote_identifier` TO `myuser`@`%` | +-------------------------------------------------------------------------------------------------------+ 4 rows in set (0.001 sec) MariaDB [(none)]> show grants for 'myuser1'@'%'; +--------------------------------------------------------------------------------------------------------+ | Grants for myuser1@% | +--------------------------------------------------------------------------------------------------------+ | GRANT USAGE ON *.* TO `myuser1`@`%` IDENTIFIED BY PASSWORD '*3C3AA21CBD381A2327556774D842B06965083D83' | | GRANT SELECT ON `mysql`.`user` TO `myuser1`@`%` | | GRANT EXECUTE ON PROCEDURE `sys`.`table_exists` TO `myuser1`@`%` | | GRANT EXECUTE ON FUNCTION `sys`.`quote_identifier` TO `myuser1`@`%` | +--------------------------------------------------------------------------------------------------------+ 4 rows in set (0.002 sec) MariaDB [(none)]> show grants for 'suresh'@'%'; +------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+ | Grants for suresh@% | +------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+ | GRANT SELECT, INSERT, UPDATE, DELETE, CREATE, DROP, RELOAD, SHUTDOWN, PROCESS, FILE, REFERENCES, INDEX, ALTER, SHOW DATABASES, SUPER, CREATE TEMPORARY TABLES, LOCK TABLES, EXECUTE, REPLICATION SLAVE, BINLOG MONITOR, CREATE VIEW, SHOW VIEW, CREATE ROUTINE, ALTER ROUTINE, CREATE USER, EVENT, TRIGGER, CREATE TABLESPACE, DELETE HISTORY, SET USER, FEDERATED ADMIN, CONNECTION ADMIN, READ_ONLY ADMIN, REPLICATION SLAVE ADMIN, REPLICATION MASTER ADMIN, BINLOG ADMIN, BINLOG REPLAY, SLAVE MONITOR ON *.* TO `suresh`@`%` IDENTIFIED BY PASSWORD '*3C3AA21CBD381A2327556774D842B06965083D83' | +------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+ 1 row in set (0.002 sec) MariaDB [(none)]> select @@version; +-----------------+ | @@version | +-----------------+ | 11.4.10-MariaDB | +-----------------+ 1 row in set (0.001 sec) MariaDB [(none)]> exit Bye After running mariadb-upgrade [root@replica1 ~]# mariadb-upgrade Phase 1/8: Checking and upgrading mysql database Processing databases mysql mysql.column_stats OK mysql.columns_priv OK mysql.db OK mysql.event OK mysql.func OK mysql.global_priv OK mysql.gtid_slave_pos OK mysql.help_category OK mysql.help_keyword OK mysql.help_relation OK mysql.help_topic OK mysql.index_stats OK mysql.innodb_index_stats OK mysql.innodb_table_stats OK mysql.plugin OK mysql.proc OK mysql.procs_priv OK mysql.proxies_priv OK mysql.roles_mapping OK mysql.servers OK mysql.table_stats OK mysql.tables_priv OK mysql.time_zone OK mysql.time_zone_leap_second OK mysql.time_zone_name OK mysql.time_zone_transition OK mysql.time_zone_transition_type OK mysql.transaction_registry OK Phase 2/8: Installing used storage engines... Skipped Phase 3/8: Running 'mysql_fix_privilege_tables' Phase 4/8: Fixing views mysql.user OK sys.host_summary OK sys.host_summary_by_file_io OK sys.host_summary_by_file_io_type OK sys.host_summary_by_stages OK sys.host_summary_by_statement_latency OK sys.host_summary_by_statement_type OK sys.innodb_buffer_stats_by_schema OK sys.innodb_buffer_stats_by_table OK sys.innodb_lock_waits OK sys.io_by_thread_by_latency OK sys.io_global_by_file_by_bytes OK sys.io_global_by_file_by_latency OK sys.io_global_by_wait_by_bytes OK sys.io_global_by_wait_by_latency OK sys.latest_file_io OK sys.memory_by_host_by_current_bytes OK sys.memory_by_thread_by_current_bytes OK sys.memory_by_user_by_current_bytes OK sys.memory_global_by_current_bytes OK sys.memory_global_total OK sys.metrics OK sys.privileges_by_table_by_level OK sys.processlist OK sys.ps_check_lost_instrumentation OK sys.schema_auto_increment_columns OK sys.schema_index_statistics OK sys.schema_object_overview OK sys.schema_redundant_indexes OK sys.schema_table_lock_waits OK sys.schema_table_statistics OK sys.schema_table_statistics_with_buffer OK sys.schema_tables_with_full_table_scans OK sys.schema_unused_indexes OK sys.session OK sys.session_ssl_status OK sys.statement_analysis OK sys.statements_with_errors_or_warnings OK sys.statements_with_full_table_scans OK sys.statements_with_runtimes_in_95th_percentile OK sys.statements_with_sorting OK sys.statements_with_temp_tables OK sys.user_summary OK sys.user_summary_by_file_io OK sys.user_summary_by_file_io_type OK sys.user_summary_by_stages OK sys.user_summary_by_statement_latency OK sys.user_summary_by_statement_type OK sys.version OK sys.wait_classes_global_by_avg_latency OK sys.wait_classes_global_by_latency OK sys.waits_by_host_by_latency OK sys.waits_by_user_by_latency OK sys.waits_global_by_latency OK sys.x$host_summary OK sys.x$host_summary_by_file_io OK sys.x$host_summary_by_file_io_type OK sys.x$host_summary_by_stages OK sys.x$host_summary_by_statement_latency OK sys.x$host_summary_by_statement_type OK sys.x$innodb_buffer_stats_by_schema OK sys.x$innodb_buffer_stats_by_table OK sys.x$innodb_lock_waits OK sys.x$io_by_thread_by_latency OK sys.x$io_global_by_file_by_bytes OK sys.x$io_global_by_file_by_latency OK sys.x$io_global_by_wait_by_bytes OK sys.x$io_global_by_wait_by_latency OK sys.x$latest_file_io OK sys.x$memory_by_host_by_current_bytes OK sys.x$memory_by_thread_by_current_bytes OK sys.x$memory_by_user_by_current_bytes OK sys.x$memory_global_by_current_bytes OK sys.x$memory_global_total OK sys.x$processlist OK sys.x$ps_digest_95th_percentile_by_avg_us OK sys.x$ps_digest_avg_latency_distribution OK sys.x$ps_schema_table_statistics_io OK sys.x$schema_flattened_keys OK sys.x$schema_index_statistics OK sys.x$schema_table_lock_waits OK sys.x$schema_table_statistics OK sys.x$schema_table_statistics_with_buffer OK sys.x$schema_tables_with_full_table_scans OK sys.x$session OK sys.x$statement_analysis OK sys.x$statements_with_errors_or_warnings OK sys.x$statements_with_full_table_scans OK sys.x$statements_with_runtimes_in_95th_percentile OK sys.x$statements_with_sorting OK sys.x$statements_with_temp_tables OK sys.x$user_summary OK sys.x$user_summary_by_file_io OK sys.x$user_summary_by_file_io_type OK sys.x$user_summary_by_stages OK sys.x$user_summary_by_statement_latency OK sys.x$user_summary_by_statement_type OK sys.x$wait_classes_global_by_avg_latency OK sys.x$wait_classes_global_by_latency OK sys.x$waits_by_host_by_latency OK sys.x$waits_by_user_by_latency OK sys.x$waits_global_by_latency OK Phase 5/8: Fixing table and database names Phase 6/8: Checking and upgrading tables Processing databases foobar1 foobar1.tab1 OK information_schema performance_schema sys sys.sys_config OK test Phase 7/8: uninstalling plugins Phase 8/8: Running 'FLUSH PRIVILEGES' OK [root@replica1 ~]# mariadb Welcome to the MariaDB monitor. Commands end with ; or \g. Your MariaDB connection id is 17 Server version: 11.4.10-MariaDB MariaDB Server Copyright (c) 2000, 2018, Oracle, MariaDB Corporation Ab and others. Type 'help;' or '\h' for help. Type '\c' to clear the current input statement. MariaDB [(none)]> SELECT * FROM mysql.procs_priv WHERE User='myuser' AND Db='sys'; Empty set (0.008 sec) MariaDB [(none)]> SELECT * FROM mysql.procs_priv WHERE User='myuser1' AND Db='sys'; Empty set (0.004 sec) MariaDB [(none)]> show grants for 'suresh'@'%'; +------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+ | Grants for suresh@% | +------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+ | GRANT SELECT, INSERT, UPDATE, DELETE, CREATE, DROP, RELOAD, SHUTDOWN, PROCESS, FILE, REFERENCES, INDEX, ALTER, SHOW DATABASES, SUPER, CREATE TEMPORARY TABLES, LOCK TABLES, EXECUTE, REPLICATION SLAVE, BINLOG MONITOR, CREATE VIEW, SHOW VIEW, CREATE ROUTINE, ALTER ROUTINE, CREATE USER, EVENT, TRIGGER, CREATE TABLESPACE, DELETE HISTORY, SET USER, FEDERATED ADMIN, CONNECTION ADMIN, READ_ONLY ADMIN, REPLICATION SLAVE ADMIN, REPLICATION MASTER ADMIN, BINLOG ADMIN, BINLOG REPLAY, SLAVE MONITOR ON *.* TO `suresh`@`%` IDENTIFIED BY PASSWORD '*3C3AA21CBD381A2327556774D842B06965083D83' | +------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+ 1 row in set (0.001 sec) MariaDB [(none)]> show grants for 'myuser1'@'%'; +--------------------------------------------------------------------------------------------------------+ | Grants for myuser1@% | +--------------------------------------------------------------------------------------------------------+ | GRANT USAGE ON *.* TO `myuser1`@`%` IDENTIFIED BY PASSWORD '*3C3AA21CBD381A2327556774D842B06965083D83' | | GRANT SELECT ON `mysql`.`user` TO `myuser1`@`%` | +--------------------------------------------------------------------------------------------------------+ 2 rows in set (0.000 sec) MariaDB [(none)]> show grants for 'myuser'@'%'; +-------------------------------------------------------------------------------------------------------+ | Grants for myuser@% | +-------------------------------------------------------------------------------------------------------+ | GRANT USAGE ON *.* TO `myuser`@`%` IDENTIFIED BY PASSWORD '*4FE9FC363621CBAB88C2E6E996DA470EF3698260' | | GRANT SELECT ON `mysql`.`user` TO `myuser`@`%` | +-------------------------------------------------------------------------------------------------------+ 2 rows in set (0.006 sec) MariaDB [(none)]> select @@version; +-----------------+ | @@version | +-----------------+ | 11.4.10-MariaDB | +-----------------+ 1 row in set (0.017 sec)