Ian, Sunday, April 28, 2002, 5:18:57 AM, you wrote: IP> In reply to Egor's request...
Egor>> > Ian, show me the contents of your <host_name>.err file (the last IP> 20-40 rows) IP> This is the total contents of this file..... IP> /nfs/usr/libexec/mysqld: ready for connections IP> /nfs/usr/libexec/mysqld: ready for connections IP> /nfs/usr/libexec/mysqld: ready for connections IP> /nfs/usr/libexec/mysqld: ready for connections IP> Can't start server: Bind on TCP/IP port: Address already in use IP> Can't start server: Bind on TCP/IP port: Address already in use IP> Can't start server: Bind on TCP/IP port: Address already in use IP> Can't start server: Bind on TCP/IP port: Address already in use IP> Can't start server: Bind on TCP/IP port: Address already in use IP> Can't start server: Bind on TCP/IP port: Address already in use IP> Can't start server: Bind on TCP/IP port: Address already in use This error occurs when another program or other mysqld already uses TCP/IP port. As you wrote below you are using non-standart port: --port=30100 Are you sure that this port is free? Try to run MySQL server with default port=3306. Was there any other running mysqld, when you was running safe_mysqld? IP> Ian >> Ian, >> Saturday, April 27, 2002, 2:31:28 AM, you wrote: >> >> IP> Mysql has not been used on my server before, and I am the only user IP> who has >> IP> ssh access to the system, (any mysqld processes are mine) and have IP> been >> IP> trying to get mysql set up and working properly. >> >> IP> Currenlty I have two mysqld processes idle on my system >> IP> 5404 p2- I 0:00.00 (mysqld) >> IP> 15488 p4- I 0:00.00 (mysqld) >> >> IP> I have tried to end these (kill -s HUP 5404 / kill -s HUP 15488) - but IP> this >> IP> does not have any affect. >> >> IP> I have tried to start the mysql server (currently it's not running | IP> ERROR >> IP> 2002: Can't connect to local MySQL server ), using the safe_mysqld& >> IP> command - with this result... >> IP> [1] 19882 >> IP> user_obscured:/# Starting mysqld demon with databases from IP> /usr/local/var >> IP> nohup >> IP> IP> /nfs/usr/libexec/mysqld --basedir=/usr/local --datadir=/usr/local/var --port >> IP> =30100 & >> IP> mysqld demon ended >> >> IP> (enter) >> >> IP> [1]+ Done safe_mysqld >> >> IP> and mysql does not restart. >> >> IP> Can anyone explain what may be going on here? >> IP> How can I clear the mysqld processes, and restart mysql so that I can IP> use >> IP> it? >> >> Ian, show me the contents of your <host_name>.err file (the last 20-40 IP> rows) >> >> IP> Ian -- For technical support contracts, goto https://order.mysql.com/ 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
