Deprecated: File class-phpmailer.php is deprecated since version 5.5.0! Use wp-includes/PHPMailer/PHPMailer.php instead. The PHPMailer class has been moved to wp-includes/PHPMailer subdirectory and now uses the PHPMailer\PHPMailer namespace. in /var/www/wordpress/wp-includes/functions.php on line 6085

Deprecated: Creation of dynamic property WordPress_Module::$redirects is deprecated in /var/www/wordpress/wp-content/plugins/redirection/modules/wordpress.php on line 141
Check MySQL Version - The Grok Shop
Deprecated: strtolower(): Passing null to parameter #1 ($string) of type string is deprecated in /var/www/wordpress/wp-content/plugins/wordpress-seo/frontend/schema/class-schema.php on line 119

Warning: Trying to access array offset on value of type bool in /var/www/wordpress/wp-content/plugins/social-pug/inc/functions.php on line 597

Check MySQL Version

The The MySQL Command-Line Client will show the version as soon as you successfully enter it:

admin@server:~$ sudo mysql -u admin -p
[sudo] password for admin: 
Enter password: 
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 70589
Server version: 5.7.27-0ubuntu0.16.04.1 (Ubuntu)

If you are already in the The MySQL Command-Line Client & scrolling up is not viable, you can just run a query:

mysql> SELECT VERSION();

+-------------------------+
| VERSION()               |
+-------------------------+
| 5.7.27-0ubuntu0.16.04.1 |
+-------------------------+
1 row in set (0.01 sec)

If you just want to check from the shell directly:

admin@server:~$ mysqld --version
mysqld  Ver 5.7.27-0ubuntu0.16.04.1 for Linux on x86_64 ((Ubuntu))
admin@server:~$ mysql --version
mysql  Ver 14.14 Distrib 5.7.27, for Linux (x86_64) using  EditLine wrapper

On Macs, the format is a little different, but the commands are the same:

admin@macbook$ mysqld --version             
/usr/local/Cellar/mysql/8.0.19/bin/mysqld  Ver 8.0.19 for osx10.15 on x86_64 (Homebrew)
admin@server$ mysql --version 
mysql  Ver 8.0.19 for osx10.15 on x86_64 (Homebrew)

Tested on: Ubuntu 16.04, MacOS Catalina

Sharing is caring!

Leave a Comment

Your email address will not be published. Required fields are marked *


Warning: Undefined array key "total_count_position" in /var/www/wordpress/wp-content/plugins/social-pug/inc/functions-frontend.php on line 46
shares