Jump to content


Photo

Mysql & PHP


  • Please log in to reply
2 replies to this topic

#1 fuelinjection

fuelinjection
  • New Members
  • Pip
  • Newbie
  • 2 posts

Posted 27 November 2003 - 11:05 AM

I\'ve installed redhat linux onto an old machine I had.
I installed apache server from the redhat 9 installation cd, which is working fine, its installed php which also seems to be working fine.

I have then installed mysql, setup the basic databases to hold the user details, and mysql is running.

Yet when I try to access myphpadmin from my server, it says something about php needing to be setup for mysql. So even though mysql is running, sites that need it are not able to see it.

I use a contact management software called mambo(www.mamboserver.com), upon installation this tells you what you have running on your server, when I run this, it says that mysql is \'unavailable\'

Can anyone assist, do I need to change some settings in the php.ini file to point it to the mysql socks or something?

#2 deRusett

deRusett
  • Members
  • PipPip
  • Member
  • 26 posts

Posted 27 November 2003 - 11:30 AM

[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 limimt
mysql.connect_timeout = 60

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

[mSQL]
; Allow or prevent persistent links.
msql.allow_persistent = On

; Maximum number of persistent links. -1 means no limit.
msql.max_persistent = -1

; Maximum number of links (persistent+non persistent). -1 means no limit.
msql.max_links = -1



make sure this is in your PHP.ini file and make sure it is uncommented

#3 fuelinjection

fuelinjection
  • New Members
  • Pip
  • Newbie
  • 2 posts

Posted 27 November 2003 - 12:04 PM

Thanks, I will check this when I get home tonight




0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users