MySQL Help - Initial Configuration
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
re: MySQL Help - Initial Configuration
On Friday 13 December 2002 22:19, Benjamin Fisher wrote: 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. [skip] 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 Look in the error log file to see what is wrong with MySQL start. 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? -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Egor Egorov / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net ___/ www.mysql.com - 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