You are here: Re: mysql_connect error Apache Web server to Windows hosted database « PHP Programming Language « IT news, forums, messages
Re: mysql_connect error Apache Web server to Windows hosted database

Posted by GD on 07/25/06 11:37

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_persistent = On

; Maximum number of persistent links. -1 means no limit.
mysql.max_persistent = -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_port =

; Default socket name for local MySQL connects. If empty, uses the
built-in
; MySQL defaults.
mysql.default_socket =

; Default host for mysql_connect() (doesn't apply in safe mode).
mysql.default_host =

; Default user for mysql_connect() (doesn't apply in safe mode).
mysql.default_user =

; 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("mysql.default_password")
; 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_password =

; Maximum time (in secondes) for connect timeout. -1 means no limit
mysql.connect_timeout = 60

; Trace mode. When trace_mode is active (=On), warnings for table/index
scans and
; SQL-Errors will be displayed.
mysql.trace_mode = Off

Thanks for your help!
Dan

 

Navigation:

[Reply to this message]


Удаленная работа для программистов  •  Как заработать на Google AdSense  •  England, UK  •  статьи на английском  •  PHP MySQL CMS Apache Oscommerce  •  Online Business Knowledge Base  •  DVD MP3 AVI MP4 players codecs conversion help
Home  •  Search  •  Site Map  •  Set as Homepage  •  Add to Favourites

Copyright © 2005-2006 Powered by Custom PHP Programming

Сайт изготовлен в Студии Валентина Петручека
изготовление и поддержка веб-сайтов, разработка программного обеспечения, поисковая оптимизация