As discussed in comments, the problem was a missing prce2 package which meant preg_match(), used by $wpdb->db_version() to parse the MySQL version number out of SELECT VERSION(), didn’t work. Solved by
sudo yum install pcre2
Related Posts:
- Can’t open the mysql.plugin table. Please run mysql_upgrade to create it
- Differences between utf8 and latin1
- What specific database privileges does WordPress need?
- What is the most secure way to set up the MySQL user in WPMU?
- WordPress installation on valet php 8 (PHP Fatal error: Uncaught mysqli_sql_exception Table ‘wp_options’ doesn’t exist in wp-includes/wp-db.php:2056)
- Running WordPress from MySQL Cluster with HAPRoxy
- Cannot add or update a child row: a foreign key constraint fails
- Cannot delete or update a parent row: a foreign key constraint fails
- ERROR 2003 (HY000): Can’t connect to MySQL server on localhost (10061)
- Rename a column in MySQL
- Not unique table/alias
- Install mysql-python (Windows)
- #1055 – Expression of SELECT list is not in GROUP BY clause and contains nonaggregated column this is incompatible with sql_mode=only_full_group_by
- Can’t connect to local MySQL server through socket ‘/var/lib/mysql/mysql.sock’ (2)
- Disable ONLY_FULL_GROUP_BY
- MySQL WHERE IN ()
- SELECT list is not in GROUP BY clause and contains nonaggregated column …. incompatible with sql_mode=only_full_group_by
- Host ‘xxx.xx.xxx.xxx’ is not allowed to connect to this MySQL server
- difference between primary key and unique key
- MySQL – UPDATE query based on SELECT Query
- How to export a mysql database using Command Prompt?
- MySQL Error #1133 – Can’t find any matching row in the user table
- How can I prevent SQL injection in PHP?
- Best way to store an array in MySQL database?
- MySQL date formats – difficulty Inserting a date
- How to grant remote access permissions to mysql server for user?
- How to check if mysql database exists
- #1062 – Duplicate entry for key ‘PRIMARY’
- How can I convert a string to a float in mysql?
- Is there a Profiler equivalent for MySql?
- How to use greater than operator with date?
- How to replace the domain name in a WordPress database?
- Optimize WordPress Query that take 5 seconds to execute
- MySQL Replication Latency Issues in wp-admin pages
- How to disable `SQL_CALC_FOUND_ROWS` [duplicate]
- Increment value (value = value+1) of $wpdb->update
- How can I debug my database connection for unit testing?
- Extending the database
- SQL query not working in alphabetical post title/content search
- WordPress Deadlock Error
- Universal problem: first request after ~25 second inactivity always slower (~1 second) than subsequent requests (~1/10sec)
- How to do a MySQL dump from production site without using a search and replace script for local development?
- Importing MariaDB into Mysql in WordPress
- Concurrent / simultaneous MySQL connections
- How to check for empty and not a failure
- How to get a Google maps SQL->XML->map marker tutorial to work in WordPress
- How many ‘wp_insert_post’ calls can be performed in one shot, in a very long ‘for’ loop?
- Converting mysql to $wpdb
- Update a WordPress post or page takes 60+ seconds
- add_post_meta does not respect the content
- Modify MySQL Query Based on Dropdown Menu
- Select multiple wp_postmeta keys with single select
- How can I fix WordPress installation errors?
- Backing up and restoring multiple sites efficiently
- Alter wp_post table vs. post_meta performance/speed
- Replacing link URL ending strings via MySQL
- Problem with admin login after deployment
- Are these WordPress tables safe to add indexes to?
- SQL syntax error when getting data for a url
- How to stop $wpdb from prepending database name
- Import CSV to MySQL, with custom registration field information
- Locally restoring a ManageWP full site backup
- WordPress doesn’t save changes some times
- Update Custom Post Type Taxonomies with SQL
- Custom SELECT Query not returning the_title and the_permalink
- Will reducing mysql permissions hinder WP function? [duplicate]
- Php Mysql Terms
- Export SQL query based on custom field?
- Lock wait timeout exceeded; try restarting transaction
- How to install WordPress from hosting service with mysql database from Compute Engine GCP?
- 504 Gateway Time-out after custom plugin inserts data into mysql database
- WordPress fails to install with “Can’t Select Database” Error (WAMPServer)
- What is this? MySQL array?
- Error Connecting to Database WHEN Installing WordPress on XAMPP [Tried All the Usual Stuff] (Pics Included)
- What is the MYSQL Query to bulk update the canonical URL of specific categories of posts in WordPress?
- How can I verify WordPress nonce from the following code?
- Why should be SQL keywords, like CREATE TABLE and UPDATE, must be uppercase in WordPress?
- Add row to SQL array
- SELECT statement wrong?
- mysql query on wp_user and user_meta problem
- $wpdb post type and term query only works when there are no dashes or spaces in the term slug and title
- Use custom query if main search query returns zero results in wordpress
- get_results() query not working only when entering strings
- Geographical proximity query using post_meta
- What is the cron doing?
- Can I use mysql queries to replace query_posts()?
- Add value to array in database
- SQL error on restoring database
- MySQL database gives blank page (white screen of death)
- How to Import Multiple Values in custom field
- Making CURDATE() recognize current_time()
- why is $wpdb->update() causing a DB error from within wp_set_password()
- How should I troubleshoot a database serialization issue with a WordPress migration
- How WP decide to show or not to show in admin panel the pop-up window with hint? Need a fix
- Global MySQL replacing of text patterns/matches
- SQL – Pull products of particular category from a remote WordPress woocommerce db
- Efficiently loop over huge number of posts
- Using queries in and i see 7000+queries?
- How can I show mysql locks?
- Slow search queries with a large database