WordPress Developer Resources

wpdb::db_server_info(): string

Returns the version of the MySQL server.

Return

string Server version as a string.

Source

public function db_server_info() {
	return mysqli_get_server_info( $this->dbh );
}

View all references View on Trac View on GitHub

Used by	Description
WP_Site_Health::prepare_sql_data()`wp-admin/includes/class-wp-site-health.php`	Runs the SQL version checks.
dbDelta()`wp-admin/includes/upgrade.php`	Modifies the database based on specified SQL statements.
wp_version_check()`wp-includes/update.php`	Checks WordPress version against the newest version.
wpdb::has_cap()`wp-includes/class-wpdb.php`	Determines whether the database or WPDB supports a particular feature.
wpdb::db_version()`wp-includes/class-wpdb.php`	Retrieves the database server version.

Changelog

Version	Description
5.5.0	Introduced.

User Contributed Notes

Skip to note 3 content

Ravikumar Patel 4 years ago

You must log in to vote on the helpfulness of this noteVote results for this note: 0You must log in to vote on the helpfulness of this note
You can Retrieve the MySQL server version on frontend by global declaration.
```
global $wpdb;
echo $wpdb->db_server_info();
```
Log in to add feedback
Skip to note 4 content

Liton Arefin 3 years ago

You must log in to vote on the helpfulness of this noteVote results for this note: 0You must log in to vote on the helpfulness of this note
Another way to Retrieve MySQL Server version by using $wpdb:
```
global $wpdb;
$db_version_dump = $wpdb->get_var( 'SELECT VERSION() AS version from DUAL' );
if ( preg_match( '/\d+(?:\.\d+)+/', $db_version_dump, $matches ) ) {
    echo $matches[0]; //returning the first match of Database Version
}
```
Log in to add feedback

You must log in before being able to contribute a note or feedback.