How to check for MYSQL on server?

[sb73542]

Hi, I was wondering if there is an easy script or something to check to see MYSQL is installed on my web host's server.  (Besides calling customer support   )  Thanks!

[hyperion]

Your host will have to provide you with a database, so you will have to call them anyway.

[Joachim Müller]

you can find out wether PHP running on your webspace has mySQL support by creating a file with

Code Select Expand

<?php
phpinfo();
?>in it. Save it on your server (e.g. as phpinfo.php) and run it in your browser ( http://yourdomain.com/phpinfo.php ). If it shows something like

mysql
MySQL Support enabled
Active Persistent Links  0  
Active Links  0  
Client API version  4.0.16  
MYSQL_MODULE_TYPE  external  
MYSQL_SOCKET  /var/lib/mysql/mysql.sock  
MYSQL_INCLUDE  -I/usr/include/mysql  
MYSQL_LIBS  -L/usr/lib -lmysqlclient  

in it then your webspace has mySQL.support.
This doesn't necesarily mean you have a mySQL-database! But as hyperion wrote, it's little use to know there is a mySQL database as long as you don't have the login credentials for the database (database name, username, password) - which only your webhost can tell you. But don't be alarmed - if you had mySQL, they would have told you - as it's a feature webhosts boast with when signing up for a contract.

GauGau

[moorey]

Or the nmap utility :wink:

MySQL typically uses port 3306.

[azrael]

Just a word of caution on the nmap thing, many ISP's have a zero
tolerance policy for portscans of their servers, so if you plan to do so,
send them a mail (in which you could ask them directly anyway ).

---
Azrael

[moorey]

It was more of a FYI kind of thing.. Another way to find out is just to telnet to port 3306.. but really that's way off topic, I apologise for that. I digress.

Obviously the best solution as suggested by many was just to ask; there's no fail in that - it's the simplest.

[sb73542]

Thanks for all the help!  It's actually a bit of a pride issue for me... I just started modifying a web site for a company that hasn't updated their site in a LONG time.  They've had the hosting account for years, with little documentation. I had to call three times already to verify different things, I guess I was hoping to avoid another call.   :wink:   FYI, I'm trying to decide between Menalto Gallery or Coppermine for the "Products" gallery page, which is a major focus of the site redesign.