Dear Philip and all,
# pwd
/usr/local/mysql-3.23.46-sun-solaris2.8-sparc
#
# grep 3306 /etc/services
#
# ps -ef | grep mysql
root 292 1 0 Dec 24 ? 0:00 /bin/sh
./bin/safe_mysqld --datadir=/usr/local/mysql/data --pid-file=/usr/local
mysql 316 292 0 Dec 24 ? 0:00
/usr/local/mysql-3.23.46-sun-solaris2.8-sparc/bin/mysqld --defaults-extra-fi
le=
root 759 686 0 16:57:48 pts/1 0:00 grep mysql
Sorry, I forget the password... how I can create the new one ?
Thanks a lot,
Kevin Chan
<Phillip B. Bruce Wrote>
Sent: Thursday, December 27, 2001 4:05 PM
Subject: Re: Why I can't run Mysql program ? Please Help !
> Kevin Chan wrote:
>
> > 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
>
> Kevin,
>
> First do the following:
>
> # grep 3306 /etc/services
>
> See if any other service is using this port.
>
> # ps -ef | grep mysql
>
> The above will check for any current mysql daemons running.
>
> #mysqladmin -p status
> Enter password:
> Uptime: 425644 Threads: 1 Questions: 6105 Slow queries: 0 Opens: 52
Flush
> tables: 1 Open tables: 8 Queries per second avg: 0.014
>
> That means the server is up and running.
>
> Check those things first and make sure that you have ownership and
permission
> set properly.
>
>
>
> --
> ************************************************************
> *** 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
