Re: Mysql running?

[Nicolas Ho <class933 () yahoo com>]

hi larry,

i got the same prob as well :( but i managed to get it
solve :) to answer ur question, nope it is not running
at all. to prove, run:

# ps -ef | grep mysql

first of all, for your info, i installed mysql in
/usr/local so do remember to adjust the paths. 
the prob lies with the permission settings. now, if u
check out the log file, u will see this:

# cd /usr/local/var
# less localhost.localdomain.err
011104 16:06:19  mysqld started
011104 16:06:20  /usr/local/libexec/mysqld: Can't
create/write to file '/usr/local/v
ar/localhost.localdomain.pid' (Errcode: 13)
011104 16:06:20  /usr/local/libexec/mysqld: Can't find
file: './mysql/host.frm' (err
no: 13)
011104 16:06:20  /usr/local/libexec/mysqld: Error on
delete of '/usr/local/var/local
host.localdomain.pid' (Errcode: 13)
011104 16:06:20  mysqld ended

now if u look at the permission for the
/usr/local/var, u will see:

# ls -la /usr/local
drwx-----  4 root root 4096 Nov  4 21:33 var

there are a couple of ways to resolve this such as.
wat i did was this:
# cd /usr/local
# chgrp mysql var
# chmod 750 var
# ls -la /usr/local
drwxr-x--- 4 root mysql 4096 Nov  4 21:33 var

this should now work:
# /usr/local/src/mysql-3.23.43/scripts/safe_mysqld &
[1] 948
# Starting mysqld daemon with databases from
/usr/local/var
# ps -ef | grep mysql
mysql 961 948 1 17:52 pts/0    00:00:00
/usr/local/libexec/mysqld --base
mysql 963 961 0 17:52 pts/0    00:00:00
/usr/local/libexec/mysqld --base
mysql 964 963 0 17:52 pts/0    00:00:00
/usr/local/libexec/mysqld --base

hope it works for u n hv fun :)

cheers!
heemeng

> Mysql question:
>
>
> I start it with:
> Cd /usr ; /usr/bin/safe_mysql &
>
> When I start mysql is responds with
>
> [root@klw]#Starting mysqld with dtabase from
/var/lib/mysql
> 011108 12:59:20 mysqld ended
>
> @ (this is a black promts that just sits here until
I hit return)
> Does this above means its running??????
>
> If I hit return, it says
>
> [1]+ Done         /usr/bin/safe_mysqld
>
> Larry

_______________________________________________
Snort-users mailing list
Snort-users () lists sourceforge net
Go to this URL to change user options or unsubscribe:
https://lists.sourceforge.net/lists/listinfo/snort-users
Snort-users list archive:
http://www.geocrawler.com/redir-sf.php3?list=snort-users

__________________________________________________
Do You Yahoo!?
Everything you'll ever need on one web page from News and Sport to Email and Music Charts
http://uk.my.yahoo.com

_______________________________________________
Snort-users mailing list
Snort-users () lists sourceforge net
Go to this URL to change user options or unsubscribe:
https://lists.sourceforge.net/lists/listinfo/snort-users
Snort-users list archive:
http://www.geocrawler.com/redir-sf.php3?list=snort-users