forum.coppermine-gallery.net

No Support => General discussion (no support!) => Topic started by: sb73542 on November 04, 2003, 03:56:18 am

Title: How to check for MYSQL on server?
Post by: sb73542 on November 04, 2003, 03:56:18 am

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!

Title: How to check for MYSQL on server?
Post by: hyperion on November 04, 2003, 04:09:02 am

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

Title: How to check for MYSQL on server?
Post by: Joachim Müller on November 04, 2003, 08:00:15 am

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

Code: [Select]

<?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

Quote

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

Title: How to check for MYSQL on server?
Post by: moorey on November 04, 2003, 08:04:33 am

Or the nmap utility :wink:

MySQL typically uses port 3306.

Title: How to check for MYSQL on server?
Post by: azrael on November 04, 2003, 02:24:17 pm

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

Title: How to check for MYSQL on server?
Post by: moorey on November 04, 2003, 03:33:55 pm

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.

Title: How to check for MYSQL on server?
Post by: sb73542 on November 04, 2003, 10:34:58 pm

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.