How to check if my web host is using new or old MySQL?

mcottle

Member
Joined
Feb 16, 2017
Messages
55
Points
8
Anyone know how check if my current web host is using new or old MySQL?
I want to make sure that my websites are running on the latest version of MYSQL :)
 

hostens

Well-known member
Hosting Provider
Registered
Joined
Jan 18, 2017
Messages
215
Points
28
I presume that you are currently having a shared hosting service. In such case, the MySQL version should be provided in phpMyAdmin first page. There in the "Database server" section, "Server version" should show what MySQL version is currently being used.
 

mcottle

Member
Joined
Feb 16, 2017
Messages
55
Points
8
I have websites running on both shared and vps servers.
I want to know what version of Mysql is the latest version and how to check mysql version on my hosting and compare with new version.

In such case, the MySQL version should be provided in phpMyAdmin first page.
Is it noted in this block in PHPmyadmin?

mysqlserver.jpg

I don't see Mysql version there.
 

hostens

Well-known member
Hosting Provider
Registered
Joined
Jan 18, 2017
Messages
215
Points
28
As seen in the picture, your database server is MariaDB and not MySQL. In general, the shown 10.1.22-MariaDB version should be as MySQL 5.6 and 5.7 upgraded version, with some new features. As MariaDB homepage currently shows, the newest stable version of it is 10.3.8.
 

mcottle

Member
Joined
Feb 16, 2017
Messages
55
Points
8
I checked on other shared hosting and all are using Mariadb
Is there a way to check without needing PhpMyadmin?
mysql-version-phpmyadmin.png
 

hostens

Well-known member
Hosting Provider
Registered
Joined
Jan 18, 2017
Messages
215
Points
28
Well, for shared hosting services, the database version can also be provided in service details (if such section is created by your service provider) or in server "details" or "information" section on used control panel. However, it depends on the service provider and server configuration, so a better suggestion for you would be to check in phpMyAdmin.

If you have root access via SSH, you can try of using command "mysql -V" that should return the required information (of course, database has to be installed in the server).
 

mcottle

Member
Joined
Feb 16, 2017
Messages
55
Points
8
mcottle
If you have root access via SSH, you can try of using command "mysql -V" that should return the required information (of course, database has to be installed in the server).
As I read then this only telling us Mysql client version.
And to know real mysql version I need to login into mysql with mysql root username. I am not sure about these.
 
Newer Threads
Replies
3
Views
1,913
Replies
3
Views
2,653
Replies
12
Views
3,424
Replies
4
Views
1,660

Latest Hosting OffersNew Reviews

Sponsors

Tag Cloud

You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.

Top