How to check the MySQL version on the server hosting my account?

You can check the MySQL version using the mysqli_get_server_info function. To do this, you should create a simple php file (for example mysql.php) with the following lines in it:

 

 

Make sure you replace mysql_user and mysql_pass with your MySQL username and password.

Then you should open the file in a browser to see the MySQL version. The path to the file should be:

yourdomainname.com/mysql.php

cPanel is easy to work with when you have the right host to support you. If you need a reliable partner to help you manage your website with cPanel, check out our cPanel hosting services!

  • 0 Users Found This Useful
Was this answer helpful?

Related Articles

How to export/import a MySQL database via SSH

In this article we will show you how to export and import a MySQL database via SSH. Managing your...

Error about legacy type authentication (old-style) when connecting remotely to MySQL

This particular error can occur in some MySQL clients. The reason for it is that our servers...

How to change the password of a Mysql user in cPanel?

If you have already created a MySQL user through the cPanel -> Mysql Databases tool you may...

How to reset the password for a MySQL database?

You may need to change the password of your database in order to improve the security of your...

I cannot create views in MySQL

Regular MySQL users do not have privileges to create views in MySQL. If you try to execute CREATE...