Re: Re: /tmp/mysql.sock problem
adam, Tuesday, June 04, 2002, 7:55:23 PM, you wrote: the mysql.sock file is automatically created when mysqld is started. please check your configuration (/etc/my.cnf) and your mysql daemon ... :D a Thanks. However, something's still wrong. a Restarted the daemon - /usr/sbin/safe_mysqld and the file wasn't created. a How can I check where this file is going? I've searched for it, but not a found it. Are you sure that your MySQL server was started? Check with the following command if there is mysqld in the process list ps ax | grep mysqld a Egor, a This was the output I received: a [root@localhost mysql]# ps ax | grep mysqld a 2398 pts/0S 0:00 grep mysqld a [root@localhost mysql]# Your MySQL server is not running. Start MySQL server again. If MySQL server will not start look in the host_name.err file in the MySQL data dir if there is any cause of errors. a Thanks a Adam -- 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
/tmp/mysql.sock problem
Apologies for posting such a basic query, but I couldn't find an archived version of the mailing list, or a fix to my problem. Using Linux Mandrake 8.2. It's the problem with mysql.sock, which I've tried to make the /tmp directory sticky, following the command on the mysql site. However, it still hasn't provided me with a mysql.sock file. How do I reinstate this file? advTHANKSance Adam - 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: /tmp/mysql.sock problem
Dicky Wahyu Purnomo wrote: On Tue, 04 Jun 2002 08:04:01 +0100 adam [EMAIL PROTECTED] wrote: Apologies for posting such a basic query, but I couldn't find an archived version of the mailing list, or a fix to my problem. Using Linux Mandrake 8.2. It's the problem with mysql.sock, which I've tried to make the /tmp directory sticky, following the command on the mysql site. However, it still hasn't provided me with a mysql.sock file. How do I reinstate this file? the mysql.sock file is automatically created when mysqld is started. please check your configuration (/etc/my.cnf) and your mysql daemon ... :D Thanks. However, something's still wrong. Restarted the daemon - /usr/sbin/safe_mysqld and the file wasn't created. How can I check where this file is going? I've searched for it, but not found it. Adam -- -BEGIN PGP PUBLIC KEY BLOCK- Version: GnuPG v1.0.4 (GNU/Linux) Comment: For info see http://www.gnupg.org Comment: A revocation certificate should follow iEkEIBECAAkFAjxu+xACHQIACgkQEN8jbmPrR/B3LwCcDZs25AlyaMhHxZ0PoFAx 3iFknAEAmwcOYuqBoG2AGYJ5U8z3YiFgWvok =TLkp -END PGP PUBLIC KEY BLOCK- - 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: Re: /tmp/mysql.sock problem
adam, Tuesday, June 04, 2002, 12:05:30 PM, you wrote: the mysql.sock file is automatically created when mysqld is started. please check your configuration (/etc/my.cnf) and your mysql daemon ... :D a Thanks. However, something's still wrong. a Restarted the daemon - /usr/sbin/safe_mysqld and the file wasn't created. a How can I check where this file is going? I've searched for it, but not a found it. Are you sure that your MySQL server was started? Check with the following command if there is mysqld in the process list ps ax | grep mysqld a Adam -- 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
Re: /tmp/mysql.sock problem
Dicky Wahyu Purnomo wrote: On Tue, 04 Jun 2002 08:04:01 +0100 adam [EMAIL PROTECTED] wrote: Apologies for posting such a basic query, but I couldn't find an archived version of the mailing list, or a fix to my problem. Using Linux Mandrake 8.2. It's the problem with mysql.sock, which I've tried to make the /tmp directory sticky, following the command on the mysql site. However, it still hasn't provided me with a mysql.sock file. How do I reinstate this file? the mysql.sock file is automatically created when mysqld is started. please check your configuration (/etc/my.cnf) and your mysql daemon ... :D On Tue, 04 Jun 2002 10:04:28 +0100 adam [EMAIL PROTECTED] wrote: It's the problem with mysql.sock, which I've tried to make the /tmp directory sticky, following the command on the mysql site. However, it still hasn't provided me with a mysql.sock file. How do I reinstate this file? the mysql.sock file is automatically created when mysqld is started. please check your configuration (/etc/my.cnf) and your mysql daemon ... :D did u install mysql from rpm or tgz ? if rpm ... 0. make sure that all mysqld stopped ... killall -9 safe_mysqld; killall -9 mysqld 1. /etc/init.d/mysql start or /etc/init.d/mysql restart 2. ps ax | grep mysqld 3. you should see minimal line with safe_mysqld and only mysqld 4. do -- shell $ updatedb 5. do -- shell $ locate mysql.sock 6. for sure ... run mysql client -- shell $ mysql I've followed these instructions and strangely, mysql.sock appears in /var/lib/mysql/ Should I copy it over? I has a funny equals sign next to it in Midnight Commander. Thanks again for advice. Adam -- -BEGIN PGP PUBLIC KEY BLOCK- Version: GnuPG v1.0.4 (GNU/Linux) Comment: For info see http://www.gnupg.org Comment: A revocation certificate should follow iEkEIBECAAkFAjxu+xACHQIACgkQEN8jbmPrR/B3LwCcDZs25AlyaMhHxZ0PoFAx 3iFknAEAmwcOYuqBoG2AGYJ5U8z3YiFgWvok =TLkp -END PGP PUBLIC KEY BLOCK- - 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: /tmp/mysql.sock problem
Egor Egorov wrote: adam, Tuesday, June 04, 2002, 12:05:30 PM, you wrote: the mysql.sock file is automatically created when mysqld is started. please check your configuration (/etc/my.cnf) and your mysql daemon ... :D a Thanks. However, something's still wrong. a Restarted the daemon - /usr/sbin/safe_mysqld and the file wasn't created. a How can I check where this file is going? I've searched for it, but not a found it. Are you sure that your MySQL server was started? Check with the following command if there is mysqld in the process list ps ax | grep mysqld Egor, This was the output I received: [root@localhost mysql]# ps ax | grep mysqld 2398 pts/0S 0:00 grep mysqld [root@localhost mysql]# Thanks Adam - 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: /tmp/mysql.sock problem
OK got this sorted in the end, by putting a soft link in to the /tmp folder pointing to the /var/lib - thanks one and all. Adam Dicky Wahyu Purnomo wrote: On Tue, 04 Jun 2002 08:04:01 +0100 adam [EMAIL PROTECTED] wrote: Apologies for posting such a basic query, but I couldn't find an archived version of the mailing list, or a fix to my problem. Using Linux Mandrake 8.2. It's the problem with mysql.sock, which I've tried to make the /tmp directory sticky, following the command on the mysql site. However, it still hasn't provided me with a mysql.sock file. How do I reinstate this file? the mysql.sock file is automatically created when mysqld is started. please check your configuration (/etc/my.cnf) and your mysql daemon ... :D -- -BEGIN PGP PUBLIC KEY BLOCK- Version: GnuPG v1.0.4 (GNU/Linux) Comment: For info see http://www.gnupg.org Comment: A revocation certificate should follow iEkEIBECAAkFAjxu+xACHQIACgkQEN8jbmPrR/B3LwCcDZs25AlyaMhHxZ0PoFAx 3iFknAEAmwcOYuqBoG2AGYJ5U8z3YiFgWvok =TLkp -END PGP PUBLIC KEY BLOCK- - 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