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
