Dear Marek and all, I find out 3306 is listening show as below :
# netstat -an *.3306 *.* 0 0 24576 0 LISTEN # pwd /usr/local/mysql-3.23.46-sun-solaris2.8-sparc # ./bin/mysql -h sune250 ERROR 2005: Unknown MySQL Server Host 'sune250' (2) Do you know what's wrong ? Thanks a lot, Kevin Chan <Marek Zaradzki Wrote> Sent: Thursday, December 27, 2001 4:09 PM Subject: Re: Why I can't run Mysql program ? Please Help ! > try command > netstat -an > to check if file socket is created. > > try > mysql -h sune250 > > > > ----- Original Message ----- > From: "Kevin Chan" <[EMAIL PROTECTED]> > To: "Marek Zaradzki" <[EMAIL PROTECTED]>; "Phillip B. Bruce" > <[EMAIL PROTECTED]> > Cc: <[EMAIL PROTECTED]> > Sent: Thursday, December 27, 2001 8:46 AM > Subject: Re: Why I can't run Mysql program ? Please Help ! > > > > Dear Marek and all, > > > > I only can find one file end with err (sune250.trasy.com.err) and I can't > > find any error message on that file after I run the following command: > > > > # ./bin/mysql > > ERROR 2002: Can't connect to local MySQL server through socket > > 'path-for-socket-file' (2) > > # > > # pwd > > /usr/local/mysql-3.23.46-sun-solaris2.8-sparc/data > > # > > # ls > > mysql sune250.trasy.com.err > > path-for-socket-file test > > # > > # more sune250.trasy.com.err > > 011207 10:59:37 mysqld started > > /usr/local/mysql-3.23.46-sun-solaris2.8-sparc/bin/mysqld: ready for > > connections > > 011221 15:18:28 /usr/local/mysql-3.23.46-sun-solaris2.8-sparc/bin/mysqld: > > Normal shutdown > > 011221 15:18:28 /usr/local/mysql-3.23.46-sun-solaris2.8-sparc/bin/mysqld: > > Shutdown Complete t: 3306 ? > > 011207 15:11:18 Aborting > > 011207 15:11:18 /usr/local/mysql-3.23.46-sun-solaris2.8-sparc/bin/mysqld: > > Shutdown Complete > > 011207 15:11:18 mysqld ended > > 011207 15:35:34 mysqld started > > 011207 15:35:34 Can't start server: Bind on TCP/IP port: Address already > in > > use > > 011207 15:35:34 Do you already have another mysqld server running on > port: > > 3306 ? > > 011207 15:35:34 Aborting > > 011207 15:35:34 /usr/local/mysql-3.23.46-sun-solaris2.8-sparc/bin/mysqld: > > Shutdown Complete > > 011207 15:35:34 mysqld ended > > 011221 12:03:40 mysqld started > > 011221 12:03:40 Can't start server: Bind on TCP/IP port: Address already > in > > use > > 011221 12:03:40 Do you already have another mysqld server running on > port: > > 3306 ? > > 011221 12:03:40 Aborting > > 011221 12:03:40 /usr/local/mysql-3.23.46-sun-solaris2.8-sparc/bin/mysqld: > > Shutdown Complete > > 011221 12:03:40 mysqld ended > > 011221 12:53:16 mysqld started > > 011221 12:53:16 Can't start server: Bind on TCP/IP port: Address already > in > > use > > 011221 12:53:16 Do you already have another mysqld server running on > port: > > 3306 ? > > 011221 12:53:16 Aborting > > 011221 12:53:16 /usr/local/mysql-3.23.46-sun-solaris2.8-sparc/bin/mysqld: > > Shutdown Complete > > 011221 12:53:16 mysqld ended > > 011221 14:46:15 mysqld started > > 011221 14:46:15 Can't start server: Bind on TCP/IP port: Address already > in > > use > > 011221 14:46:15 Do you already have another mysqld server running on > port: > > 3306 ? > > 011221 14:46:15 Aborting > > 011221 14:46:15 /usr/local/mysql-3.23.46-sun-solaris2.8-sparc/bin/mysqld: > > Shutdown Complete > > 011221 14:46:15 mysqld ended > > 011221 15:18:28 mysqld ended > > 011221 15:21:02 mysqld started > > /usr/local/mysql-3.23.46-sun-solaris2.8-sparc/bin/mysqld: ready for > > connections > > 011224 15:03:03 /usr/local/mysql-3.23.46-sun-solaris2.8-sparc/bin/mysqld: > > Normal shutdown > > 011224 15:03:04 /usr/local/mysql-3.23.46-sun-solaris2.8-sparc/bin/mysqld: > > Shutdown Complete t: 3306 ? > > 011224 12:39:20 Aborting > > 011224 12:39:20 /usr/local/mysql-3.23.46-sun-solaris2.8-sparc/bin/mysqld: > > Shutdown Complete > > 011224 12:39:20 mysqld ended > > A mysqld process already exists at Mon Dec 24 12:40:36 CST 2001 > > 011224 15:03:04 mysqld ended > > 011224 15:05:37 mysqld started > > /usr/local/mysql-3.23.46-sun-solaris2.8-sparc/bin/mysqld: ready for > > connections > > > > Would you mind to tell me what I must be change to solve the problem ? > > Thanks for your help! > > > > Thanks again, > > Kevin Chan > > > > > > <Marek Zaradzki Wrote> > > Sent: Thursday, December 27, 2001 3:05 PM > > Subject: Re: Why I can't run Mysql program ? Please Help ! > > > > > > > Dear Marek and all, > > > > > > The directory for MySQL (/etc/local)as below: > > > > > > lrwxrwxrwx 1 root other 34 Dec 5 16:32 mysql -> > > > mysql-3.23.46-sun-solaris2.8-sparc > > > drwxr-xr-x 13 root mysql 512 Dec 5 16:30 > > > mysql-3.23.46-sun-solaris2.8-sparc > > > > > > Thanks and regards, > > > Kevin Chan > > > > > > <Marek Zaradzki Wrote> > > > Sent: Thursday, December 27, 2001 2:58 PM > > > Subject: Re: Why I can't run Mysql program ? Please Help ! > > > > > > > > > > Hello > > > > look at the permitions of mysql data directory. > > > > > > > > > > > > > > > > > > > > ----- Original Message ----- > > > > From: "Kevin Chan" <[EMAIL PROTECTED]> > > > > To: "Phillip B. Bruce" <[EMAIL PROTECTED]> > > > > Cc: "Michael Brunson" <[EMAIL PROTECTED]>; > > <[EMAIL PROTECTED]>; > > > > <[EMAIL PROTECTED]> > > > > Sent: Thursday, December 27, 2001 7:49 AM > > > > Subject: Re: Why I can't run Mysql program ? Please Help ! > > > > > > > > > > > > > Dear Phillip and all, > > > > > > > > > > I am installing from Binary Distribution and just follow the > > > > INSTALL-BINARY > > > > > file to install. I just did all the steps below: > > > > > > > > > > shell> groupadd mysql > > > > > shell> useradd -g mysql mysql > > > > > shell> cd /usr/local > > > > > shell> gunzip < /path/to/mysql-VERSION-OS.tar.gz | tar xvf - > > > > > shell> ln -s mysql-VERSION-OS mysql > > > > > shell> cd mysql > > > > > shell> scripts/mysql_install_db > > > > > shell> chown -R root /usr/local/mysql > > > > > shell> chown -R mysql /usr/local/mysql/data > > > > > shell> chgrp -R mysql /usr/local/mysql > > > > > shell> chown -R root /usr/local/mysql/bin > > > > > shell> bin/safe_mysqld --user=mysql & > > > > > > > > > > Thanks and regards, > > > > > Kevin Chan > > > > > > > > > > > > > > > <Phillip B. Bruce Wrote> > > > > > Sent: Thursday, December 27, 2001 2:35 PM > > > > > Subject: Re: Why I can't run Mysql program ? Please Help ! > > > > > > > > > > > > > > > > Kevin Chan wrote: > > > > > > > > > > > > > Dear Michael and all, > > > > > > > > > > > > > > Hi Michael, do you mind to tell me where is the location of the > > > my.cnf > > > > > file > > > > > > > in my michane (Sun Solaris2.8) beacuse I can't find it ? > > > > > > > > > > > > > > And what I should change on that file to solve the problem? ... > > > thanks > > > > ! > > > > > > > > > > > > > > Thanks and regards, > > > > > > > Kevin Chan > > > > > > > > > > > > > > <Michael Brunson Wrote> > > > > > > > Sent: Thursday, December 27, 2001 12:35 PM > > > > > > > Subject: Re: Why I can't run Mysql program ? Please Help ! > > > > > > > > > > > > > > On Thu, 27 Dec 2001 12:00:08 +0800, "Kevin Chan" > > > <[EMAIL PROTECTED]> > > > > > > > wrote: > > > > > > > [...] > > > > > > > | # ./bin/mysql > > > > > > > | ERROR 2002: Can't connect to local MySQL server through socket > > > > > > > | 'path-for-socket-file' (2) > > > > > > > [...] > > > > > > > > > > > > > > You may want to edit your my.cnf file to have the path to the > > socket > > > > > file. > > > > > > > > > > > > > > Thanks, > > > > > > > Michael > > > > > > > > > > > > > > > > > --------------------------------------------------------------------- > > > > > > > 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 > > > > > > > > > > > > Kevin, > > > > > > > > > > > > If you had read the instruction from INSTALL-SOURCE you would > > have > > > > > found the > > > > > > following > > > > > > > > > > > > shell> useradd -g mysql mysql > > > > > > shell> gunzip < mysql-VERSION.tar.gz | tar -xvf - > > > > > > shell> cd mysql-VERSION > > > > > > shell> ./configure --prefix=/usr/local/mysql > > > > > > shell> make > > > > > > shell> make install > > > > > > shell> scripts/mysql_install_db > > > > > > shell> chown -R root /usr/local/mysql > > > > > > shell> chown -R mysql /usr/local/mysql/var > > > > > > shell> chgrp -R mysql /usr/local/mysql > > > > > > shell> cp support-files/my-medium.cnf /etc/my.cnf > > > > <=== > > > > > Here is > > > > > > the step you left out > > > > > > shell> /usr/local/mysql/bin/safe_mysqld --user=mysql & > > > > > > > > > > > > > > > > > > > > > > > > -- > > > > > > ************************************************************ > > > > > > *** Phillip B. Bruce *** > > > > > > *** http://pbbruce.home.mindspring.com *** > > > > > > *** [EMAIL PROTECTED] *** > > > > > > *** *** > > > > > > *** "Have you ever noticed? Anybody going slower than *** > > > > > > *** you is an idiot, and anyone going faster than you *** > > > > > > *** is a maniac." - George Carlin *** > > > > > > ************************************************************ > > > > > > > > > > > > > > > > > > > > > > > > > > > > --------------------------------------------------------------------- > > > > > 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 > > > > > > > > > > > > > > --------------------------------------------------------------------- > > > 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 > > --------------------------------------------------------------------- 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
