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

Joined
Feb 16, 2017
Messages
49
Best answers
0
Ratings
4
Points
8
#1
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
Joined
Jan 18, 2017
Messages
160
Best answers
2
Ratings
55 6
Points
28
#2
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.
 
Joined
Feb 16, 2017
Messages
49
Best answers
0
Ratings
4
Points
8
#3
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
Joined
Jan 18, 2017
Messages
160
Best answers
2
Ratings
55 6
Points
28
#4
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.
 
Joined
Feb 16, 2017
Messages
49
Best answers
0
Ratings
4
Points
8
#6
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
Joined
Jan 18, 2017
Messages
160
Best answers
2
Ratings
55 6
Points
28
#7
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).
 
Joined
Feb 16, 2017
Messages
49
Best answers
0
Ratings
4
Points
8
#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
81
Replies
3
Views
742
Replies
12
Views
104
Latest Threads
Recommended Threads
Replies
2
Views
740
Replies
7
Views
1,928
Replies
16
Views
4,067
Replies
9
Views
1,683
Replies
0
Views
20

Latest Hosting OffersNew Reviews

Sponsors

Latest Blog ArticlesMost Viewed Threads

Top