[EMAIL PROTECTED] root]# ln -s /tmp/mysql.sock /var/lib/mysql/mysql.sock
[mysqld]
port= 3306
socket = /var/lib/mysql/mysql.sock
Which is fine ... you neglected to say whether or not that fixed your
problem?
-id
--
MySQL General Mailing List
For list archives: http://lists.mys
key_buffer = 16K
max_allowed_packet = 1M
table_cache = 4
sort_buffer_size = 64K
net_buffer_length = 2K
thread_stack = 64K
server-id = 1
- Original Message -
From: ian douglas <[EMAIL PROTECTED]>
To: Cecep Rosuludin <[EMAIL PROTECTED]>
Subject: Re: Can't connect to l
[EMAIL PROTECTED] root]# ls -l /var/lib/mysql
total 20564
-rw-rw 1 mysql mysql25088 Nov 1 14:10 ib_arch_log_00
-rw-rw 1 mysql mysql 10485760 Nov 2 07:39 ibdata1
-rw-rw 1 mysql mysql 5242880 Nov 2 07:39 ib_logfile0
-rw-rw 1 mysql mysql 5242880 Nov 1 14:10 ib_log
(delete)
2.MySQL-server-4.1.7-0.i386.rpm (I removed by rpm -e )
3.the third one, I install mysql from Mandrake cd installer
- Original Message -
From: Spenser <[EMAIL PROTECTED]>
To: Cecep Rosuludin <[EMAIL PROTECTED]>
Subject: Re: Can't connect to local MySQL server thr
Spenser,
thanks for respons, I have done what you've ever done. this the result
[EMAIL PROTECTED] root]# ps -e | grep mysql
[EMAIL PROTECTED] root]#
- Original Message -
From: Spenser <[EMAIL PROTECTED]>
To: Cecep Rosuludin <[EMAIL PROTECTED]>
Subject: Re: Can't
It can has many reason:
1.Your Socket file doesn't exist!
2.If it does exist,Please kill your mysql & instead of
running its daemon,run its file in bg mode. (with &
sign)
--- Cecep Rosuludin <[EMAIL PROTECTED]> wrote:
> Dear AlL,
>
> my former question is "how to run mysql service".
> but now
Either the socket has been removed or is in a different location than you
think. Try connecting by host and port. I would also verify with a database
restart that the socket is being created where you think it is. If you
continue to have issues look over this page to see if it helps.
http://dev.mys
You better download the binary release from mysql.com and install it. It's statically
linked so it should work fine on all Linuxes.
Correctly installed MySQL binary release works fine and generally needs no tweaking to
start and run.
--
For technical support contracts, goto https://order.
What does, "rcmysql status" say?
--- Mark <[EMAIL PROTECTED]> wrote:
> Hi, I just installed 3.23.55 and I started getting
> this message when
> I run mysql from the shell.
>
> /tmp/mysql.sock exists and the permissions are right
> and mysqld is
> running, also the weird thing is that php is
> conn
Edwin,
Monday, October 07, 2002, 1:09:37 PM, you wrote:
>>>On Monday 07 October 2002 12:04, Edwin Raj wrote:
>>>
When I type mysql in the command prompt it is giving the error "ERROR
2002: Can't connect to local MySql server through socket
'/var/lib/mysql/mysql.sock' (111)"
There
Ed Carp wrote:
>>On Monday 07 October 2002 12:04, Edwin Raj wrote:
>>
>>>When I type mysql in the command prompt it is giving the error "ERROR
>>>2002: Can't connect to local MySql server through socket
>>>'/var/lib/mysql/mysql.sock' (111)"
>>>There is no file mysql.sock at that location???
>>>
>
> On Monday 07 October 2002 12:04, Edwin Raj wrote:
> > When I type mysql in the command prompt it is giving the error "ERROR
> > 2002: Can't connect to local MySql server through socket
> > '/var/lib/mysql/mysql.sock' (111)"
> > There is no file mysql.sock at that location???
>
> Exactly.
>
> > W
On Monday 07 October 2002 12:04, Edwin Raj wrote:
> When I type mysql in the command prompt it is giving the error "ERROR
> 2002: Can't connect to local MySql server through socket
> '/var/lib/mysql/mysql.sock' (111)"
> There is no file mysql.sock at that location???
Exactly.
> What is the probl
ed as play."
- Plato (427 - 347 BC)
- Original Message -
From: "Erik Price" <[EMAIL PROTECTED]>
To: "Andrew Rich" <[EMAIL PROTECTED]>
Cc: <[EMAIL PROTECTED]>
Sent: Thursday, April 25, 2002 10:01 PM
Subject: Re: Can't connect to local MySQL ser
On Thursday, April 25, 2002, at 04:17 PM, Andrew Rich wrote:
>
> Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)
>
>
> Any ideas ?
You might need to specify the path to your socket file when you start
MySQL... did you specify a specific socket location at compile time
So sprach »Felipe Baytelman« am 2001-09-19 um 11:37:36 -0400 :
> I'm getting
>
> ERROR 2002: Can't connect to local MySQL server through socket
> '/var/lib/mysql/mysql.sock' (111)
Does the file actually exist? I know that you deleted it, but
Alexander Skwar
--
How to quote: http://learn
Is that the correct location for mysql.sock?
If yes, is it world readable and writeable?
If no, is the socket location defined in /etc/my.cnf?
If it is, this file must be world readable.
½ÉÃ溸 wrote:
> I installed linux and mysql 3.23.40.
> Root installed and started mysql and user (charley) w
George Pitcher ([EMAIL PROTECTED]) writes:
> Similar for me. Except that I can do all the usual SQL stuff as root but if
> I try and access via PHP I get the '/tmp/mysql.sock' missing message.
>
> Is a complete re-install of MySQL the only solution or is there something
> else that can be done t
Similar for me. Except that I can do all the usual SQL stuff as root but if
I try and access via PHP I get the '/tmp/mysql.sock' missing message.
Is a complete re-install of MySQL the only solution or is there something
else that can be done to solve this problem, which, from scanning archives,
i
Thank you for all your suggestions,
I got it.
the problem was in our web server because of security $ENV{HOME} doesnt
point to my home directory so my .my.cnf file was unreachable.
That's it.
may be It can be helpful for other people as well.
> my %attr = (
> PrintError =>0,
> Rai
I don't know for sure... perhaps, the apache+php binary just treats it
differently than when interacting with it directly from the shell...
I am a newbie and I just had the same problem 2 minutes ago...
hope it works out...
thanks,
shawn
On Tue, 29 May 2001, Mohammad Shoja wrote:
> Thanks for
Thanks for your reply
The question is why in command line there is no problem?
> It is looking for /tmp/mysql.sock and the one that exists is
> /tmp/mysql.sock.shoja
>
> Two different files.. It can't find what it is looking for. Try:
>
> safe_mysqld --socket=/tmp/mysql.sock
>
> and it should
>
> [client]
> port=3309
> socket=/tmp/mysql.sock.shoja
>
> Now the problem is when I'm trying to run my cgi from command prompt there
> is no error and it connect successfully.
>
> But when I'm trying to run it through web browser I get this error
> message:
>
> Can't connect to local MySQL serve
Have you checked the permissions on mysql.sock? This happened to me once.
Since your webserver is running as 'nobody' you need to make sure the
permissions are correct for the socket and directories...
Just a thought.
Bryan
-Original Message-
From: denis mettler [mailto:[EMAIL PROTECT
Putting on my Captain Obvious hat. Are you sure that you only have 1 php.ini
and that PHP is picking up the right one? PHP thinks your mysql.sock is in
/var/lib/mysql.
Also, make sure that it's /tmp/mysql.sock and not /tmp/mysqld.sock. I seem
to remember mine being mysqld.sock.
Cal
http://www.
Well, since PHP is trying to use a socket in the wrong directory,
you might check the PHP list to see if they can help you.
This is not, strictly speaking a MySQL problem, so waiting here for the
correct answer may not be the quickest route to the answer.
I have seen several answers indicating th
CAL T. DEMIER writes:
> I get the subject error when running the static or semi-static linux builds on
> Mandrake 7.2. My database is working fine and I am able to use another client,
> KMySQLAdmin, without problems.
>
> Cal
>
hi!
You are probably referring to mysqlgui.
In that case,
27 matches
Mail list logo
