Re: MySQL

[Peter Risdon]

Micah Bushouse wrote:

<cut>

Peter Risdon wrote:

ilich wrote:



Hello All!
I have small problem.
I installed apache2\php4\mysql. Apache and php work fine, but mysql 
doesn't work. When I enter "mysql" to my console it send massage 
"Can't connect to local MySQL server through socket 
'tmp/mysql.socket'". As far as I Know mysqld doesn't load to memory, 
but I'm not sure.Please, give me any advices and explain me what 
does mean this massage.




You probably need to start mysql:

#/usr/local/etc/rc.d/mysql-server.sh start

PWR

<paste>
I think you're actually trying to start the mysql client, which defaults 
to attempt a connection localhost when no cmd arguments are given. Since 
mysqld isn't running, the mysql client will complain about the socket.  
If you're using mysql 4.x (mysql 3.x will be very similar, except the 
daemon may be named safe_mysqld), try these steps:

> whereis mysqld_safe

then run as root the resulting path, for example, on my machine I would use

> /usr/local/bin/mysqld_safe &

that should work!

~Micah
</paste>
That's what the startup script does:

# less /usr/local/etc/rc.d/mysql-server.sh
#!/bin/sh
DB_DIR=/var/db/mysql
PIDFILE=${DB_DIR}/`/bin/hostname -s`.pid
case "$1" in
       start)
               if [ -x /usr/local/bin/mysqld_safe ]; then
                       /usr/bin/limits -U mysql \
                       /usr/local/bin/mysqld_safe --user=mysql 
--datadir=${DB_DI
R} --pid-file=${PIDFILE} > /dev/null &
                       echo -n ' mysqld'
               fi
               ;;

But I'd use this rc.d script if there's a problem like the OP reported 
because it will govern how the daemon starts when the machine boots, so 
it needs to be working.

PWR.
_______________________________________________
[EMAIL PROTECTED] mailing list
http://lists.freebsd.org/mailman/listinfo/freebsd-questions
To unsubscribe, send any mail to "[EMAIL PROTECTED]"