I'm fairly new to MySQL, and RDBMS's in general, but not to system administration nor linux. I'm running Gentoo, and I can't seem to get mySQL to work.
Gallio root # /etc/init.d/mysql start * Starting mysqld... [ ok ] Then I: Gallio root # ps ax PID TTY STAT TIME COMMAND 1 ? S 0:04 init 2 ? SW 0:00 [keventd] 3 ? SWN 0:00 [ksoftirqd_CPU0] 4 ? SW 0:00 [kswapd] 5 ? SW 0:00 [bdflush] 6 ? SW 0:00 [kupdated] 7 ? SW 0:00 [khubd] 12 ? SW 0:02 [kjournald] 37 ? S 0:00 /sbin/devfsd /dev 1989 ? SW 0:00 [kjournald] 1990 ? SW 0:00 [kjournald] 1991 ? SW 0:00 [kjournald] 4711 ? SW 0:00 [eth0] 4907 ? S 0:00 /usr/sbin/smbd 4909 ? S 0:01 /usr/sbin/nmbd 4942 ? S 0:00 /usr/sbin/sshd 4996 ? S 0:00 /usr/sbin/syslogd -m 0 4999 ? S 0:00 /usr/sbin/klogd -c 3 -2 5001 ? S 0:00 /usr/sbin/cron 5007 vc/1 S 0:00 login -- root 5008 vc/2 S 0:00 login -- root 5010 vc/4 S 0:00 /sbin/agetty 38400 tty4 linux 5011 vc/5 S 0:00 /sbin/agetty 38400 tty5 linux 5012 vc/6 S 0:00 /sbin/agetty 38400 tty6 linux 5013 vc/1 S 0:00 -bash 5480 vc/2 S 0:00 -bash 1211 vc/3 S 0:00 /sbin/agetty 38400 tty3 linux 5487 ? S 0:00 /usr/sbin/sshd 5489 ? S 0:00 /usr/sbin/sshd 5490 pts/0 S 0:00 -sh 5497 pts/0 S 0:00 -bash 5604 ? S 0:00 /usr/sbin/apache -D SSL -D PHP4 -D PERL 5605 ? S 0:00 /usr/sbin/apache -D SSL -D PHP4 -D PERL 5606 ? S 0:00 /usr/sbin/apache -D SSL -D PHP4 -D PERL 5607 ? S 0:00 /usr/sbin/apache -D SSL -D PHP4 -D PERL 5608 ? S 0:00 /usr/sbin/apache -D SSL -D PHP4 -D PERL 5570 pts/0 R 0:00 ps ax But it's not there. To make sure: Gallio root # nmap 10.10.10.10 Starting nmap V. 3.00 ( www.insecure.org/nmap/ ) Interesting ports on Gallio (10.10.10.10): (The 1599 ports scanned but not shown below are in state: closed) Port State Service 22/tcp open ssh 80/tcp open http 139/tcp open netbios-ssn Nmap run completed -- 1 IP address (1 host up) scanned in 2 seconds Gallio root # Nothin'. Nada. Nil. It's not starting. If I try to stop it... Gallio root # /etc/init.d/mysql stop * Stopping mysqld... [ !! ] My guess, it can't find the pid to stop it with. And the file /var/run/mysqld/mysqld.pid (or something like that) doesn't exist. Running 'safe_mysqld --user=mysql &' does the following: Gallio root # safe_mysqld --user=mysql & [1] 5632 Gallio root # Starting mysqld daemon with databases from /var/lib/mysql 021213 11:47:23 mysqld ended When I escape out of that: [1]+ Done safe_mysqld --user=mysql I'm not sure what has gone wrong, but I'd like to get the mysql up and running. BTW, what would be a worthy book to get on mySQL? Ben -- ______________________________________________ http://www.linuxmail.org/ Now with POP3/IMAP access for only US$19.95/yr Powered by Outblaze --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php