Hi,
If you wish to write an server application ...i think, you can be interested
about how make settings for a socket (see "man 7 setsockopt")
But your problem it's so far from that....i think, you changed some user
access rights and for this reason you can't connect to MySQL server.
Try mysql -u root -h your_name_machine(not "localhost") -p
Don't try to restart MySQL daemon because it is already started...check with
ps -ax | grep "mysqld".
Regards,
Gelu
_____________________________________________________
G.NET SOFTWARE COMPANY
Permanent e-mail address : [EMAIL PROTECTED]
[EMAIL PROTECTED]
----- Original Message -----
From: "Simon K. Chan" <[EMAIL PROTECTED]>
To: "Mysql Help" <[EMAIL PROTECTED]>
Sent: Sunday, June 02, 2002 1:05 AM
Subject: can't re-start mysql server
> Hi All,
>
> I've been trying to re-start the mysql server for a while now.
> A few days ago, I discovered that I couldn't connect to the database
> after entering my password. I got the usual "can't connect via
> the /tmp/mysql.sock" message.
>
> I tried to restart the daemon with ./bin/safe_mysqld &, but that didn't
> work. So I check the my_host_name.err file in the /data
> and found this:
>
> "Can't start server: Bind on TCP/IP port: Address already in use
> Do you already have another mysqld server running on port: 3306
> Aborting"
>
> My 2 questions:
>
> 1. WHAT DO I DO???!!! :-)
>
> 2. I searched Google Groups and I came up with this message in a thread:
> Monty:
>
> "calling setsockopt() with SO_REUSEADDR on the server socket should solve
this
> problem.
>
> On Linux ( possibly on other systems too) this can happen if the server
dies
> without closing the socket, and the client is still connected.
>
> Killing all the clients should allow the server to bind the port again,
even
> with the current code.
>
> --
> Sasha Pachev"
>
> what is "setsockopt() and SO_REUSEADDR " and how do I use 'em?
>
> Many thanks,All.
>
>
>
>
>
>
>
>
>
>
>
>
>
>
> =====
> #########################################
>
> Warmest Regards,
> Simon K. Chan - [EMAIL PROTECTED]
>
> "Great spirits have always encountered violent opposition from mediocre
minds." - Albert Einstein
>
> __________________________________________________
> Do You Yahoo!?
> Yahoo! - Official partner of 2002 FIFA World Cup
> http://fifaworldcup.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 <mysql-unsubscribe-##L=##[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 <mysql-unsubscribe-##L=##[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
