ah ok, yes,
the error log says
"
030211 12:10:27 mysqld started
030211 12:10:27 Can't start server: Bind on
TCP/IP port: Address already in use
030211 12:10:27 Do you already have another
mysqld server running on port: 3306 ?
030211 12:10:27 Aborting
"
how do i get rid of this other mysql !
its probably because i have installed and
uninstalled so many times i probably have about
10 different ones installed
- how can i get it back to one installation
maybe i need to reformat again ...
--- Peter Grigor <[EMAIL PROTECTED]> wrote:
> ----- Original Message -----
> From: "J. A. Tovey" <[EMAIL PROTECTED]>
> To: <[EMAIL PROTECTED]>
> Sent: Tuesday, February 11, 2003 9:09 AM
> Subject: socket error
>
>
> > hi -
> >
> > i have got to the beginning stages of
> > installation - on trying to create a root
> > password with:
> >
> > bin/mysqladmin -u root password 'password'
> >
> > i get
> >
> > bin/mysqladmin: connect to server at
> 'localhost'
> > failed
> > error: 'Can't connect to local MySQL server
> > through socket '/tmp/mysql.sock' (2)'
> > Check that mysqld is running and that the
> socket:
> > '/tmp/mysql.sock' exists!
> > [1]+ Done bin/safe_mysqld
> > --user=mysql
> >
> >
> > how can i fix this ?
> >
> > i had previously started the server with:
> >
> > [root@jt mysql]# bin/safe_mysqld --user=mysql
> &
> >
> > and it had returned:
> >
> > [1] 3698
> > [root@jt mysql]# Starting mysqld daemon with
> > databases from /usr/local/mysql/data
> > 030211 12:32:05 mysqld ended
>
>
> From this last line you can tell that the
> mysqld has not started properly
> ('mysql ended'). That's why you can't connect
> to it via mysqladmin.
>
> Check the mysqld log
> (/usr/local/mysql/data/your.machine.name.err)
> for
> errors.
>
> Peter
> <^_^>
> ---------------------------------------------
> Peter Grigor
> Hoobly Classified Ads
> http://www.hoobly.com
>
__________________________________________________
Do you Yahoo!?
Yahoo! Shopping - Send Flowers for Valentine's Day
http://shopping.yahoo.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
