List:General Discussion« Previous MessageNext Message »
From:mysql Date:March 9 2006 9:24pm
Subject:RE: php and mysql
View as plain text  
Mary, you need to know 100% that mysql is actually running 
and what port or socket it is listening on for connections, 
before you even try and connect to it.

If you call mysqld directly with a script something like:

#! /bin/sh
# start-mysql-5.0.18
#
# start the MySQL database server

/usr/local/mysql-5.0.18/bin/mysqld \
--defaults-file=/usr/local/mysql-5.0.18/my.cnf \
--port=7000 \
--socket=/var/lib/mysql/mysql.sock \
--pid=/var/lib/mysql/laptop.pid \
--user=mysql \
--datadir=/var/lib/mysql &

Then use a processes monitoring tool such as:

http://www.student.nada.kth.se/~f91-men/qps/

This will then show you if mysqld is running OK.

It will also show you the parameters in the above script 
that you passed to mysqld to get it started.

You then need to try and connect to mysqld with the mysql 
monitor program as already mentioned.

If you just set the client options in /etc/my.cnf config 
file, these will be applied globally to all mysql client 
programs.

EG.

# /etc/my.cnf

# MySQL client program configuration file

# last updated 2006-03-05

# mysqld server configuration file lives in
# /usr/local/mysql-<version>/my.cnf

#---------------------------------------------------------------------------
# mysql client program configuration options
#---------------------------------------------------------------------------

[mysql]
auto-rehash

# needed for security - to stops multiple deletes/updates
# without a where clause
safe-updates

#---------------------------------------------------------------------------

# The following options will be passed to all MySQL clients

[client]
socket = /var/lib/mysql/mysql.sock
port = 7000 

#snip
#---------------------------------------------------------------------------

# end of mysql client program configurations
# /etc/my.cnf


More options for your mysqld server can be set in the 
--defaults-file=/usr/local/mysql-5.0.18/my.cnf 

These options are additional to the options you pass in the 
above script.

EG

#---------------------------------------------------------------------------
# mysqld server configuration options
#---------------------------------------------------------------------------

[mysqld]
basedir=/usr/local/mysql-5.0.18

## use for testing multiple instances of mysqld
## these parameters are normally passed to mysqld
## from the start-mysql-5.0.18 script
##
##basedir=/usr/local/mysql-5.0.18
##port=7005
##socket=/usr/local/mysql-5.0.18/data/mysql.sock
##pid-file=/usr/local/mysql-5.0.18/data/laptop.pid
##datadir=/usr/local/mysql-5.0.18/data
##user=mysql

server-id=1

#skip-networking
skip-name-resolve
skip-locking

set-variable = key_buffer=16M
set-variable = max_allowed_packet=1M
set-variable = table_cache=64
set-variable = sort_buffer=512K
set-variable = net_buffer_length=8K
set-variable = myisam_sort_buffer_size=8M

# logging options
log=5-0-18.log
log-bin=laptop-bin
log-error=5-0-18.error-log
log-queries-not-using-indexes
log-slow-admin-statements
log-slow-queries=5-0-18.slow-log
log-warnings

#---------------------------------------------------------------------------

# end of mysqld server configuration file
# /usr/local/mysql-<version>/my.cnf

Next you will need to check php is using the same socket to 
connect to mysqld server. Use the phpinfo() function in a 
php script, to verify this. Obviously, you will need the 
mysql or mysqli extension loaded for this.

HTH

Keith Roberts


In theory, theory and practice are the same;
In practice they are not. 

On Fri, 10 Mar 2006, Logan, David (SST - Adelaide) wrote:

> To: Mary Adel <mary.adel@stripped>
> From: "Logan, David (SST - Adelaide)" <David.Logan@stripped>
> Subject: RE: php and mysql
> 
>  
> If you still have issues after that, then read
> http://dev.mysql.com/doc/refman/5.0/en/can-not-connect-to-server.html
> 
> Regards
> 
> 
> ---------------------------------------------------------------
> ********** _/     **********  David Logan 
> *******   _/         *******  ITO Delivery Specialist - Database
> *****    _/            *****  Hewlett-Packard Australia Ltd
> ****    _/_/_/  _/_/_/  ****  E-Mail: david.logan@stripped
> ****   _/  _/  _/  _/   ****  Desk:   +618 8408 4273
> ****  _/  _/  _/_/_/    ****  Mobile: 0417 268 665
> *****        _/       ******    
> ******      _/      ********  Postal: 148 Frome Street,
> ********   _/     **********          Adelaide SA 5001
>                                       Australia 
> i    n    v    e    n    t                                   
> ---------------------------------------------------------------
> 
> -----Original Message-----
> From: JC [mailto:hiep@stripped] 
> Sent: Friday, 10 March 2006 6:42 AM
> To: Mary Adel
> Cc: fbsd_user@stripped; mysql@stripped
> Subject: RE: php and mysql
> 
> On Thu, 9 Mar 2006, Mary Adel wrote:
> 
> > Thanks for al your help and i di that and now i have another error
> >
> > Can't connect to local MySQL server through socket
> > '/var/lib/mysql/mysql.sock' (2)
> > my code is as follows:
> >
> > <?php
> > print "hi";
> > mysql_connect('localhost', 'root','') or die(mysql_error());
> > echo "Connected to MySQL<br />";
> > print "connected";
> > ?>
> > if u can help in this i ll appreciate that a lot
> >
> >
> > On Thu, 2006-03-09 at 13:37 -0500, fbsd_user wrote:
> >> You need a login id and password unless this is test DB added under
> >> ID "root"
> >> You have to use the same login id as the one you created the
> >> db/table with.
> >>
> >> mysql_connect('localhost', 'Login id', 'pw') or die(mysql_error())
> >>
> >> mysql_connect('localhost', 'root') or die(mysql_error())
> >>
> >>
> >> -----Original Message-----
> >> From: Mary Adel [mailto:mary.adel@stripped]
> >> Sent: Thursday, March 09, 2006 3:06 PM
> >> To: mysql@stripped
> >> Subject: php and mysql
> >>
> >>
> >> I have a severe problem that php5 cannot connect to mysql and i
> >> don't
> >> know why
> >> also i am using linux
> >> here is my peice of code
> >> :<?php
> >> print "hi";
> >> mysql_connect('localhost', '', '') or die(mysql_error());
> >> echo "Connected to MySQL<br />";
> >> print "connected";
> >> ?>
> >> if their is any configuration please tell me
> >>
> >> thanks,
> >> mary
> >>
> >>
> >> --
> >> MySQL General Mailing List
> >> For list archives: http://lists.mysql.com/mysql
> >> To unsubscribe:
> >> http://lists.mysql.com/mysql?unsub=1
> >>
> >>
> >
> >
> >
> 
> -- 
> 
> hi mary,
> 
> take a look at 
> http://www.stanton-finley.net/fedora_core_5_installation_notes.html#MySQ
> L.
> 
> basically, you need to make sure that your mysql server accepts local 
> connection.
> 
> if you login to your mysql server:
> mysql -u root (if no password for root) or
> mysql -u root -p (if there is pw for root)
> 
> and then:
> select user,host,password from mysql.user;
> 
> if you don't see an entry for root & localhost, then you need to add it 
> in.
> 
> hope that help.
> JC
> 
> -- 
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe:    http://lists.mysql.com/mysql?unsub=1
> 
> 
> --
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe:    http://lists.mysql.com/mysql?unsub=1
> 
> 
Thread
php and mysqlMary Adel9 Mar
  • RE: php and mysqlfbsd_user9 Mar
    • RE: php and mysqlMary Adel9 Mar
      • RE: php and mysqlJC9 Mar
  • Re: php and mysqlPeter Brawley9 Mar
RE: php and mysqlSST - Adelaide)9 Mar
  • RE: php and mysqlmysql9 Mar
  • RE: php and mysqlIng. Edwin Cruz9 Mar