Advanced search  

News:

CPG Release 1.6.26
Correct PHP8.2 issues with user and language managers.
Additional fixes for PHP 8.2
Correct PHP8 error with SMF 2.0 bridge.
Correct IPTC supplimental category parsing.
Download and info HERE

Pages: [1]   Go Down

Author Topic: How to check for MYSQL on server?  (Read 7048 times)

0 Members and 1 Guest are viewing this topic.

sb73542

  • Coppermine newbie
  • Offline Offline
  • Posts: 2
How to check for MYSQL on server?
« 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!
Logged

hyperion

  • VIP
  • Coppermine addict
  • ***
  • Offline Offline
  • Posts: 1317
  • - retired -
How to check for MYSQL on server?
« Reply #1 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.
Logged
"Then, Fletch," that bright creature said to him, and the voice was very kind, "let's begin with level flight . . . ."

-Richard Bach, Jonathan Livingston Seagull

(http://www.mozilla.org/products/firefox/buttons/getfirefox_small.png)

Joachim Müller

  • Dev Team member
  • Coppermine addict
  • ****
  • Offline Offline
  • Gender: Male
  • Posts: 47843
  • aka "GauGau"
    • gaugau.de
How to check for MYSQL on server?
« Reply #2 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
Logged

moorey

  • VIP
  • Coppermine frequent poster
  • ***
  • Offline Offline
  • Posts: 404
How to check for MYSQL on server?
« Reply #3 on: November 04, 2003, 08:04:33 am »

Or the nmap utility :wink:

MySQL typically uses port 3306.
Logged

azrael

  • Coppermine newbie
  • Offline Offline
  • Posts: 7
How to check for MYSQL on server?
« Reply #4 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
Logged

moorey

  • VIP
  • Coppermine frequent poster
  • ***
  • Offline Offline
  • Posts: 404
How to check for MYSQL on server?
« Reply #5 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.
Logged

sb73542

  • Coppermine newbie
  • Offline Offline
  • Posts: 2
How to check for MYSQL on server?
« Reply #6 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.
Logged
Pages: [1]   Go Up
 

Page created in 0.019 seconds with 20 queries.