Abhi, Thursday, October 10, 2002, 8:30:43 PM, you wrote: A> I am not able to connect mysql server after executing this command
A> ./safe_mysqld -O key_buffer=64M -O table_cache=256 -O A> sort_buffer=4M -O read_buffer_size=1M A> [repository@shoggoth bin]$ ./mysql -u root A> ERROR 2002: Can't connect to local MySQL server through socket A> '/tmp/mysql.sock' (2) [skip] A> but my process is running. I have tryed to restart also but unable to A> restart mysql server successifully. A> mysql> show processlist; A> +-------+------+-----------+---------+---------+------+------------------------- A> -----+--------------------------------------------------------------+ A> | Id | User | Host | db | Command | Time | A> State A> | Info | A> +-------+------+-----------+---------+---------+------+------------------------- A> -----+--------------------------------------------------------------+ A> | 19509 | root | localhost | mysql | Sleep | 481 A> | A> | NULL | A> | 19532 | root | localhost | DS_data | Query | 0 | A> NULL A> | show processlist | A> | 19547 | root | localhost | DS_data | Query | 39 | Copying to tmp A> table on A> disk | select distinct name_server1 from tbl_raw_zone_file limit 10 | A> +-------+------+-----------+---------+---------+------+------------------------- A> -----+--------------------------------------------------------------+ A> The error (2002) Can't connect to ... normally means that there isn't a A> MySQL server running on the system or A> that you are using a wrong socket file or TCP/IP port when trying to A> connect to the mysqld server. A> Error Log A> ------------- A> 021010 10:30:41 mysqld started A> No variable match for: -O 'read_buffer_size=1M' A> /usr/local/mysql/libexec/mysqld Ver 3.23.49 for pc-linux-gnu on i686 A> Use '--help' or '--no-defaults --help' for a list of available o A> I am using mysql version 3.23 A> mysql> select version(); A> +-------------+ A> | version() | A> +-------------+ A> | 3.23.49-log | A> +-------------+ A> 1 row in set (0.00 sec) A> ptions A> 021010 10:30:41 mysqld ended ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^ But error log shows that MySQL didn't start. Do you have another MySQL server running? -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ ____ __ / |/ /_ __/ __/ __ \/ / Victoria Reznichenko / /|_/ / // /\ \/ /_/ / /__ [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