Jerry Stuckle wrote:
Dan,
Do you have anything in the [mysql] section of your php.ini?
Also, looking back through your first message - you indicate you get the
message:
Can't connect to MySQL server on 'SERVER' (13)
But your code puts out the messages:
"Could not connect to database: ".mysql_error() ;
and
"Could not select database: ".mysql_error() ;
Is this actually the case (your message isn't generated by your code),
or did you just mistype the message? Just want to make sure we're going
down the right path :-).
The actual message is:
Could not connect to database: Can't connect to MySQL server on
'SERVER' (13)
MySQL section of php.ini copied below.
[MySQL]
; Allow or prevent persistent links.
mysql.allow_per sistent = On
; Maximum number of persistent links. -1 means no limit.
mysql.max_persi stent = -1
; Maximum number of links (persistent + non-persistent). -1 means no
limit.
mysql.max_links = -1
; Default port number for mysql_connect() . If unset, mysql_connect()
will use
; the $MYSQL_TCP_PORT or the mysql-tcp entry in /etc/services or the
; compile-time value defined MYSQL_PORT (in that order). Win32 will
only look
; at MYSQL_PORT.
mysql.default_p ort =
; Default socket name for local MySQL connects. If empty, uses the
built-in
; MySQL defaults.
mysql.default_s ocket =
; Default host for mysql_connect() (doesn't apply in safe mode).
mysql.default_h ost =
; Default user for mysql_connect() (doesn't apply in safe mode).
mysql.default_u ser =
; Default password for mysql_connect() (doesn't apply in safe mode).
; Note that this is generally a *bad* idea to store passwords in this
file.
; *Any* user with PHP access can run 'echo
get_cfg_var("my sql.default_pas sword")
; and reveal this password! And of course, any users with read access
to this
; file will be able to reveal the password as well.
mysql.default_p assword =
; Maximum time (in secondes) for connect timeout. -1 means no limit
mysql.connect_t imeout = 60
; Trace mode. When trace_mode is active (=On), warnings for table/index
scans and
; SQL-Errors will be displayed.
mysql.trace_mod e = Off
Thanks for your help!
Dan