Assuming Linux, check where it's listening using "netstat -lptn".
lx wrote:
>hi all:
>I'm a new one. I have a mysql server in 192.168.27.72 , and a mysql
>client in 192.168.23.73.
>I use this way:
> mysql -h 192.168.27.72 -u root -p
>
>the ERROR messa
hi all:
I'm a new one. I have a mysql server in 192.168.27.72 , and a mysql
client in 192.168.23.73.
I use this way:
mysql -h 192.168.27.72 -u root -p
the ERROR message is:
ERROR 2003 (HY000): Can't connect to MySQL server on '192.
rting MySQL database server: mysqld . . . . . . . . . . . . . .
> > failed!
> > > root@devel:~# mysql -u root -p
> > > Enter password:
> > > ERROR 2002 (HY000): Can't connect to local MySQL server through socket
> > > '/var/run/mysqld/mysqld.sock
. . .
> failed!
> > root@devel:~# mysql -u root -p
> > Enter password:
> > ERROR 2002 (HY000): Can't connect to local MySQL server through socket
> > '/var/run/mysqld/mysqld.sock' (2)
> > root@devel:~# cd /var/run/mysqld/
> > root@devel:/var/run/
topping MySQL database server: mysqld.
> Starting MySQL database server: mysqld . . . . . . . . . . . . . . failed!
> root@devel:~# mysql -u root -p
> Enter password:
> ERROR 2002 (HY000): Can't connect to local MySQL server through socket
> '/var/run/mysqld/mysqld.sock'
Il 11/04/2012 10:51, Ganesh Kumar ha scritto:
Hi Guys,
I am using debian squeeze it's working good, I am trying to install
mysql-server. mysql-server installation successfully but didn't start
root@devel:~# /etc/init.d/mysql restart
Stopping MySQL database server: mysqld.
Starting MySQL databa
Reindl Harald wrote:
> Please "netstat --numeric-hosts --notrim --programs -u -t -l"
> In my first answer i forgot the -l
i will check according to your suggstions
If i find still in troubles, i will let you know
thank you
---p
--
MySQL General Mailing List
For list archives: http://lists.
Please "netstat --numeric-hosts --notrim --programs -u -t -l"
In my first answer i forgot the -l
Without we get active connections, but we want the listening
tcp-services where somewhere must by mysqld
the easiest test is however
> [harry@srv-rhsoft:~]$ telnet 127.0.0.1 3306
> Trying 127.0.0.1..
Reindl Harald wrote:
> please do not only post outputs, read them and try to understand
> before press send - "not all processes could be identified, non-owned
> process info will not be shown, you would have to be root to see it all."
> in the ouptput says that all afterwards is useless
>
> "net
please do not only post outputs, read them and try to understand
before press send - "not all processes could be identified, non-owned process
info will not be shown, you would have to be root to see it all." in
the ouptput says that all afterwards is useless
"netstat --numeric-hosts --notrim --pr
Reindl Harald wrote:
> Did you make any change in the my.cnf?
> What does "netstat --numeric-hosts --notrim --programs -u -t" say?
> What is the content of your my.cnf?
>
Here incluede
thank you
p
--
(xpol) % netstat --numeric-hosts --notrim --programs -u -t
Andrew Moore wrote:
> I think you'll need to give us a bit more to go on. I presume this is a
> web based app?
yes
>
> What have you changed? Has the MySQL daemon stopped? What have you
> changed?
from 'ps' i get
3545 0.0 0.1 194816 3292 ?Sl 13:58 0:08 /usr/sbin/mysqld --
defau
gt; browser,
> pointing to http://localhost:9000/
>
> Probably my fault, since i have been tinkering a little with my settings.
> As
> i try to connect, i get
> Can't connect to MySQL server on '127.0.0.1' (111)
>
> Any ideas, what to check?
>
> I am using li
//localhost:9000/
>
> Probably my fault, since i have been tinkering a little with my settings. As
> i try to connect, i get
> Can't connect to MySQL server on '127.0.0.1' (111)
>
> Any ideas, what to check?
>
> I am using linux/opensuse 11.4
signature.asc
Description: OpenPGP digital signature
I have been using my local dictionary for years, accessing from web browser,
pointing to http://localhost:9000/
Probably my fault, since i have been tinkering a little with my settings. As
i try to connect, i get
Can't connect to MySQL server on '127.0.0.1' (111)
Any ideas
Hi
thanks for your reply.
i found the problem, the problem was due to maintenance activity IT team
rebooted the machine but they didn't start the mysql server after reboot.
i executed mysqld with root credit. i got the below output but still the
cursor not return to prompt
bash-2.03# /usr/local
The socket hets created when you start the server
It might be in the mysql home dir, it might be in /var/run.
See if its declared in my.cnf
Sent via BlackBerry from T-Mobile
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/
hi experts
ERROR 2002 (HY000): Can't connect to local MySQL server through socket
'/tmp/mysql.sock' (2)
iam facing the above error while connecting the mysql database. i am also
checked the mysql.sock socket file is not in /tmp.
could you please help me to fix this problem. wh
--prefix=/home/qsys/mysql-5.1.32 \
--with-unix-socket-path=/home/qsys/mysql-5.1.32/tmp/mysql.sock
make
make install
mkdir /home/qsys/mysql-5.1.32/var
/home/qsys/mysql-5.1.32/bin/mysql_upgrade
at this point I get mysqlcheck: Got error 202: Can't connect to local MySQL
server through s
-socket-path=/home/qsys/mysql-5.1.32/tmp/mysql.sock
make
make install
mkdir /home/qsys/mysql-5.1.32/var
/home/qsys/mysql-5.1.32/bin/mysql_upgradeat this point I get mysqlcheck: Got
error 202: Can't connect to local MySQL server through socket
'/home/qsys/mysql-5.1.32/temp/mysql.sock'
Regardless of who has implemented the network and the status of
provided monitoring tools, this has all the look and feel of
intermittent network issues. I would run an independant network scan
(maybe nmap?) from one of the affected clients to the affected host
and I bet you will find that the sa
HI Pieter
I have a suggestion.this might not be very helpful
Try to reconfigure the connections between the client and Mysql
server where the problem exists.and then try to notice the
uptime and logs of the server.
CHAVA
On Mon, Aug 18, 2008 at 12:00 PM, Piet
Greetings to all,
I am having a weird issue with MySQL that I can't solve. We are getting
intermittent client connection errors code 2003 to the database server for
10mins seemingly at random, and after 20+ days of uptime. Unfortunately, I
have not been able to correlate these connection problems
Make sure your mysqld is running
On Fri, Apr 4, 2008 at 3:24 AM, Joerg Bruehe <[EMAIL PROTECTED]> wrote:
> Hi,
>
>
> Vidal Garza wrote:
>
> > [[...]]
> >
> > I have a cuestion, where do you find the system header files error
> > number (61)?
> >
>
> I do that brute-force:
>
> #! /bin/sh
> #
>
Hi,
Vidal Garza wrote:
[[...]]
I have a cuestion, where do you find the system header files error
number (61)?
I do that brute-force:
#! /bin/sh
#
# FGIN shell script to use "fgrep" on all
"/usr/include/h" files
#
# $1, $2, ... options and arguments given to "fgr
ection metod script.
I set
#!/bin/sh
...
/usr/local/bin/mysql -h 127.0.0.1 -u root -pmypassword MYDB -e "$query"
...
the -h option but i have a another message error...
...
...
ERRORERROR 2003 (HY000): Can't connect to MySQL server on '127.0.0.1' (60)
ERROR 2003 (HY000)
C i386
freebsd# mysql --version
mysql Ver 14.12 Distrib 5.0.51a, for portbld-freebsd6.3 (i386) using 5.2
[[...]]
but it return error on the screen like and this its my PROBLEM! I would
like that all connections finish ok. The errors not apear on mysql_error
file.
: Can't connect to local M
','`date +%d-%H:%M`','$cnt');"
> /usr/local/bin/mysql -u root -ppasswd -e "$query" MYDB >/dev/null
> if [ $cnt -eq 99 ];then
> break
> else
> cnt=`expr $cnt "+" 1`
> fi
> done
>
>
> but it return error on the scre
all connections finish ok. The errors not apear on mysql_error
file.
: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (61)
ERROR 2002 (HY000): Can't connect to local MySQL server through socket
'/tmp/mysql.sock' (61)
ERROR 2002 (HY000): Can't c
AIL PROTECTED]
> Sent: Tuesday, June 19, 2007 12:48 PM
> To: John Mancuso
> Subject: RE: ERROR 2002 (HY000): Can't connect to local MySQL server
>
> mysqld_safe
> Starting mysqld daemon with databases from /var/lib/mysql STOPPING
> server from pid file /var/run/mysqld/m
:48 PM
To: John Mancuso
Subject: RE: ERROR 2002 (HY000): Can't connect to local MySQL server
mysqld_safe
Starting mysqld daemon with databases from /var/lib/mysql STOPPING
server from pid file /var/run/mysqld/mysqld.pid
070619 17:40:10 mysqld ended
--- John Mancuso <[EMAIL PROTECTED]>
jn [mailto:[EMAIL PROTECTED]
Sent: Tuesday, June 19, 2007 12:25 PM
To: John Mancuso
Subject: RE: ERROR 2002 (HY000): Can't connect to local MySQL server
Hiya,
I could not find .err file anywhere.
and my mysql.sock file is showing 0 bytes in it.
- ash#
--- John Mancuso <[EMAIL PROTECTED
-2475
-Original Message-
From: Ahamarshan jn [mailto:[EMAIL PROTECTED]
Sent: Tuesday, June 19, 2007 11:54 AM
To: mysql@lists.mysql.com
Subject: ERROR 2002 (HY000): Can't connect to local MySQL server
Hi,
I was appending Grant previledges to some databases in mysql; either i
typed
.
However I could not connect to mysql again
When I start mysql I get the following error
$ mysql
ERROR 2002 (HY000): Can't connect to local MySQL
server through socket '/var/lib/mysql/mysql.sock'
(111)
I could not start nor stop any running mysql
I tried to reboot my system hoping t
Nils Meyer wrote:
Hi Faygal,
Fagyal Csongor wrote:
for (1..5) {
$dbh = DBI->connect($dsn, $user, $password, {'RaiseError' => 1} );
my $sth = $dbh->prepare('SELECT * FROM users');
}
I think you are simply running out of available outgoing ports with
that. Here is some more insigh
Hi Faygal,
Fagyal Csongor wrote:
for (1..5) {
$dbh = DBI->connect($dsn, $user, $password, {'RaiseError' => 1} );
my $sth = $dbh->prepare('SELECT * FROM users');
}
I think you are simply running out of available outgoing ports with
that. Here is some more insight on that topic:
ht
;,...) failed: Can't
connect to MySQL server on '192.168.0.200' (99) at con.pl line 14
perror 99 gives me:
OS error code 99: Cannot assign requested address
This doesn't make sense to me. I wrote a test script that looks like this:
for (1..5) {
$dbh = DBI->connect
problem.
I apologize for the mistake.
>Description:
>How-To-Repeat:
>Fix:
>Submitter-Id:
>Originator:root
>Organization:
Wellesley College Computer Science
>MySQL support: none
>Synopsis: can't connect to server and can&#x
ct to server at 'puma' failed
error: 'Lost connection to MySQL server during query'
>Fix:
None that I know of. This is a real problem for me.
>Submitter-Id:
>Originator:root
>Organization:
Wellesley College Computer Science
>MySQL support: none
>Synopsis:
mysql_pconnect() [function.mysql-pconnect]: Can't connect to
local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2) in
/web_sites/web/db_fns.php on line 6.
So far as I can remember, the only places I made edits were in
/etc/php5/apache2/php.ini, and /etc/mysql/my.cnf.
On 6/8/06, Frances <[EMAIL PROTECTED]> wrote:
Daniel da Veiga wrote:
> On 6/8/06, Frances <[EMAIL PROTECTED]> wrote:
>
>> what's event viewer? (searched google for error 1067, so opened .err
>> file, this is what is says (at the bottom, long file):
>>
>> 060607 22:37:33 [Note] mysqld: Shutdown c
>fedora core 4. The version of the mysql server is 4.1.3 Beta. I wanna
>>>connect to the server using the following statement:
>>>$db_connection=mysql_pconnect("localhost","root","");
>>>The server returned the error 2002:
>>>20
verybody!
>>I've install a mysql server on my computer. The operating system is Redhat
>>fedora core 4. The version of the mysql server is 4.1.3 Beta. I wanna connect
>>to the server using the following statement:
>>$db_connection=mysql_pconnect("localhost"
calhost","root","");
>The server returned the error 2002:
>2002 Can't connect to local MySQL server through socket
>'/var/mysql/lib/mysql.sock(13)'
>
>
The user running the php connection does not have permissions to open
/var/mysql/lib/mysql.
ot;);
The server returned the error 2002:
2002 Can't connect to local MySQL server through socket
'/var/mysql/lib/mysql.sock(13)'
I was suggested that the server may not running, or the sockect is wrong. But
when I run the following statement, there was no error occured:
localhost#/
On Tue, 28 Mar 2006, Áquila Chaves wrote:
> To: mysql@lists.mysql.com
> From: Áquila Chaves <[EMAIL PROTECTED]>
> Subject: error: 'Can't connect to local MySQL server through socket
> '/tmp/mysql.sock'
>
> - When I execute the command "m
sock' port:
3306 MySQL Community Edition - Standard (GPL)
- Aparently it's OK. But when I execute the command below occurs the
following error:
[EMAIL PROTECTED] mysql]# bin/mysqladmin version
bin/mysqladmin: connect to server at 'localhost' failed
error: 'Can't c
hu, 16 Feb 2006, persant mpote wrote:
> To: mysql@lists.mysql.com
> From: persant mpote <[EMAIL PROTECTED]>
> Subject: APACHE 2.0 can't connect to MYSQL 5 when using PHP 5.1.2
>
> hi,
> since 3 days, i'm trying to connect to MYSQL 5.0.18 from
> php scripts usi
persant mpote <[EMAIL PROTECTED]> wrote on 02/16/2006 10:29:37 AM:
> hi,
> since 3 days, i'm trying to connect to MYSQL 5.0.18 from php
> scripts using Apache et Macromedia 2004 Dreamweaver.
> Could someone help me doing this?
> Best regard.
>
>
> -
> Nouv
hi,
since 3 days, i'm trying to connect to MYSQL 5.0.18 from php scripts using
Apache et Macromedia 2004 Dreamweaver.
Could someone help me doing this?
Best regard.
-
Nouveau : téléphonez moins cher avec Yahoo! Messenger ! Découvez les tarif
On 5/12/2005 11:56 a.m., Mike Smith wrote:
Hi,
Hi,
I've already check my /etc/my.cnf file for a "binding"
line. Its not
there. I also found an item online that indicated
adding:
Look for the option "skip-networking". This disables TCP/IP so the
server only accepts local connections v
qldump on mythconverg and install
Mandrivia 2006 on
server gandalf. I restored the mythconverg; Now, I
get:
[EMAIL PROTECTED] mysql -u mythtv -pmythtv -h gandalf
mythconverg
ERROR 2003 (HY000): Can't connect to MySQL server on
'gandalf' (111)
I then tried granting privledges to
gt; > > On 12/2/05, [EMAIL PROTECTED] <[EMAIL PROTECTED]> wrote:
> > > >
> > > >
> > > >
> > > > Jenny Chen < [EMAIL PROTECTED]> wrote on 12/02/2005 12:27:33 PM:
> > > >
> > > > > Hi,
> > > &g
> >
> > >
> > >
> > > Jenny Chen < [EMAIL PROTECTED]> wrote on 12/02/2005 12:27:33 PM:
> > >
> > > > Hi,
> > > >
> > > > I'm trying to connect to the MySQL server on the RedHat AS 4 from a
> > > remote
IL PROTECTED]> wrote on 12/02/2005 12:27:33 PM:
>
> > Hi,
> >
> > I'm trying to connect to the MySQL server on the RedHat AS 4 from a
> remote
> > Solaris SPARC box. When I run the command:
> >
> > mysql -h HOSTNAME
> >
> > I got t
Jenny Chen <[EMAIL PROTECTED]> wrote on 12/02/2005 12:27:33 PM:
> Hi,
>
> I'm trying to connect to the MySQL server on the RedHat AS 4 from a
remote
> Solaris SPARC box. When I run the command:
>
> mysql -h HOSTNAME
>
> I got the error as
>
> ERROR 20
Hi,
I'm trying to connect to the MySQL server on the RedHat AS 4 from a remote
Solaris SPARC box. When I run the command:
mysql -h HOSTNAME
I got the error as
ERROR 2003 (HY000): Can't connect to MySQL server on 'HOSTNAME' (145)
Could anyone please explain what the mean
Hello.
> If I try to run mysqlshow, I see:
>
> C:\Documents and Settings\Chris>mysqlshow sql
> mysqlshow: Access denied for user 'ODBC'@'localhost' (using
password: NO)
ODBC is default username that is used on Windows. Create a new user
account and use it to connect to the MySQL se
I've just installed MySQL v5.0.15 on my 'Windows XP system and most ways
I want to connect to it fail. I don't see what I'm doing wrong. I've
searched the manual, the web, and the forums without seeing anything
that clearly addressed my problem. Help, please!
If I navigate through Programs / MySQL
zhou bin wrote:
hi,
mysql is a very goode software,so i made mysql_3.23_58 and mysql_4.1
in two of my server, and i changed the root password, but why i can't
connect to the mysql server from a client pc(use mysqlcc or any other
tools)?
the error message is:
[206] ERROR 1130: Host &
hi,
mysql is a very goode software,so i made mysql_3.23_58 and mysql_4.1
in two of my server, and i changed the root password, but why i can't
connect to the mysql server from a client pc(use mysqlcc or any other
tools)?
the error message is:
[206] ERROR 1130: Host '218.4.**.***'
>it sounds like you need to look at, and potentially cleanup (or make
>your mysql access entries match) what's in the inverse-map record for
>the IPnumbers of your machines.
>when you connect mysql takes the IPnumber on the inbound connection,
>looks it up in DNS and then checks the result against
>Note that if you set the password by directly editing (UPDATE) the
>mysql.user table like this, you will have to run
FLUSH PRIVILEGES;
Thank you. That solved the problem connecting from the mysql client.
It changed the problem connecting via the 'Test' button from the ODBC
Administrator, t
[EMAIL PROTECTED] wrote:
Gerald Williams <[EMAIL PROTECTED]> wrote on 09/20/2005 10:49:22 AM:
MySQL 5.0.12, P2P Microsoft network
I cannot get the manual's instructions (24.1.9.6) to work for
connecting from a mysql client on a windows machine to a mysql
server running on another windows ma
Gerald Williams <[EMAIL PROTECTED]> wrote on 09/20/2005 10:49:22 AM:
> MySQL 5.0.12, P2P Microsoft network
>
> I cannot get the manual's instructions (24.1.9.6) to work for
> connecting from a mysql client on a windows machine to a mysql
> server running on another windows machine (xp and w2kpr
MySQL 5.0.12, P2P Microsoft network
I cannot get the manual's instructions (24.1.9.6) to work for connecting from a
mysql client on a windows machine to a mysql server running on another windows
machine (xp and w2kpro repsectively)
The client machine can ping the server machine by name or IP ad
Ed Collins wrote:
Description:
I get the following message "error: 'Can't connect to local MySQL
server through socket '/tmp/mysql.sock' (61)'"
This is the error the client gives when it cannot connect to the server,
usually because the server i
>Description:
I get the following message "error: 'Can't connect to local MySQL
server through socket '/tmp/mysql.sock' (61)'" Everything has run
fine for along time. This is running on OS X server 10.3 and ever
since the ran the last software upda
Hello.
Error 2013 means: "Lost connection to MySQL server during query". See:
http://dev.mysql.com/doc/mysql/en/gone-away.html
rtroiana wrote:
Hi All,
>
>
>
>I had posted a query few days back that I couldn't connect to mysql
database
>from a network machine. So for that
Hi All,
I had posted a query few days back that I couldn't connect to mysql database
from a network machine. So for that I added two entries in my firewall
exceptions.
I added the Port 3306 and mysqld, so firewall should allow any connection to
database from external computer. My problem wa
e-
From: Tom Crimmins [mailto:[EMAIL PROTECTED]
Sent: Monday, March 28, 2005 7:54 PM
To: [EMAIL PROTECTED]
Cc: mysql@lists.mysql.com
Subject: RE: 'Can't connect to local MySQL server' error
On Monday, March 28, 2005 21:36, bruce wrote:
> hi...
>
> a server went from RH
On Monday, March 28, 2005 21:36, bruce wrote:
> hi...
>
> a server went from RH8 to FC2. it appears that the guy who did the
> upgrade didn't perfrom any backups...
>
> i get a 'Can't connect to local MySQL server through socket...' erro
hi...
a server went from RH8 to FC2. it appears that the guy who did the upgrade
didn't perfrom any backups...
i get a 'Can't connect to local MySQL server through socket...' error.
i've tried to 'fix' the tables 'mysql_fix_privilege_tables' with n
Hi
according to Dr Google I'm not the first one to encounter this error
below.
SpamAssassin: invoked with 'spamd -D -q -u filter'
failed to load user (filter) scores from SQL database: SQL Error:
Can't connect to local MySQL server through socket
'/var/lib/mysql/mysql.s
> I then logged in, changed root password, used test database, etc.
>
> Now after reboot I cannot connect. I get this:
>
> [EMAIL PROTECTED]:/usr/local/mysql/bin # ./mysql -u root -p
> Enter password:
> ERROR 2002 (HY000): Can't connect to local MySQL serv
# ./mysql -u root -p
Enter password:
ERROR 2002 (HY000): Can't connect to local MySQL server through socket
'/tmp/mysql.sock' (2)
Please give options if this involves: manual server start, setting up
autostart, etc.
Thanks
--
MySQL General Mailing List
For list archives: http://lists.
t; STOPPING server from pid file /var/lib/mysql/mybox.pid
> tee: /var/lib/mysql/mybox.err: Permission denied
> 050202 09:21:36 mysqld ended
> tee: /var/lib/mysql/mybox.err: Permission denied
>
> and this one:
>
> [EMAIL PROTECTED] ~] mysql -u root
> ERROR 2002 (HY000): Ca
2 09:21:36 mysqld ended
tee: /var/lib/mysql/mybox.err: Permission denied
and this one:
[EMAIL PROTECTED] ~] mysql -u root
ERROR 2002 (HY000): Can't connect to local MySQL server through socket
'/var/lib/mysql/mysql.sock' (2)
[EMAIL PROTECTED] ~]
Then I found the notes about selinu
1 Slave I/O thread: error connecting to master
'replication # MU@ # MUST BE SET:3306': Error: 'Can't connect to
MySQL server on ' # MUST BE SET' (111)' errno: 2003
retry-time: 60 retries: 86400
Google hasnt turned up anything useful. Any ideas anyone? What
ow
>
> 041221 1:12:41 Slave I/O thread: error connecting to master
> 'replication # MU@ # MUST BE SET:3306': Error: 'Can't connect to
> MySQL server on ' # MUST BE SET' (111)' errno: 2003
> retry-time: 60 retries: 86400
>
> Google h
Hi,
I am trying to setup replication on MySQL.
Version 4.1.0alpha
Using:
./bin/mysql -h -u replication -p
I can connect successfully, but my error logs show
041221 1:12:41 Slave I/O thread: error connecting to master
'replication # MU@ # MUST BE SET:3306': Error: 'Can'
batch file.
There are two users in this computer. I try to use
different user log in, but fail.
I installed this software this summer, it worked
fine before. Now I don't know why I can't connect to
it.
Your early reply will be appreciated.
Shanhong
--
MyS
server at 'localhost' failed
error: 'Can't connect to local MySQL server through socket
'/var/lib/mysql/mysql.sock' (2)'
Check that mysqld is running and that the socket:
'/var/lib/mysql/mysql.sock' exists!
ps -ef | grep mysql
root 725 1 0 Oct29 ?
iled
error: 'Can't connect to local MySQL server through socket
'/var/lib/mysql/mysql.sock' (2)'
Check that mysqld is running and that the socket:
'/var/lib/mysql/mysql.sock' exists!
ps -ef | grep mysql
root 725 1 0 Oct29 ?00:00:00 /bin/sh
/usr/bin/
[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
ib_logfile1
drwx--x--x 2 mysql mysql 4096 Feb 23 2004 mysql/
-rw-rw 1 mysql root 7509 Nov 2 07:39 server6.cma-cgm.com.err
drwxr-xr-x 2 mysql mysql 4096 Feb 23 2004 test/
Therein lies your problem: you can't connect to
/var/lib/mysql/mysql.sock if it doesn't exist :o)
(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
to run mysql service".
> but now i have run mysql service
>
> [EMAIL PROTECTED] root]# service mysql start
> Starting MySQL Server
>[ OK ]
>
> but i still cannot connect to mysql
>
> [EMAIL PROTECTED] root]# mysql
&
ERROR 2002: Can't connect to local MySQL server through socket '/var/lib/mysql/m
ysql.sock' (2)
can you give some advice..! what should i do.
--
___
Find what you are looking for with the Lycos Yellow Pages
http://r.lycos.
At 8:27 -0700 10/5/04, Claire Lee wrote:
Hi,
I have a perl script that connect to mysql using the
following:
my $dbh =
DBI->connect("DBI:mysql:$dbname;host=$host","$dblogin",
"$dbpasswd") or die "Cannot connect to $dbname: " .
$DBI::errstr;
But after I upgraded to 4.1.5 I get the following
error me
If you are using an ODBC driver or some other pre-4.1 library to connect
to a post-4.1 MySQL server you can get the message you describe.
Here is some reading about cross-version authentication issues:
http://dev.mysql.com/doc/mysql/en/Problems.html (esp section A.2)
http://dev.mysql.com/doc/mysq
http://www.alchemetrics.co.uk
> -Original Message-
> From: Claire Lee [mailto:[EMAIL PROTECTED]
> Sent: 05 October 2004 16:28
> To: [EMAIL PROTECTED]
> Subject: Can't connect to DB after upgrading to mysql 4.1.5
>
> Hi,
> I have a perl script that connect to mysql us
Hi,
I have a perl script that connect to mysql using the
following:
my $dbh =
DBI->connect("DBI:mysql:$dbname;host=$host","$dblogin",
"$dbpasswd") or die "Cannot connect to $dbname: " .
$DBI::errstr;
But after I upgraded to 4.1.5 I get the following
error message:
DBI->connect(dbname;host=host) f
Hi,
I'm noticing this error in various script of ours that run on the cron:
DBI connect('general:10.1.1.80:3306;mysql_connect_timeout=3','root',...)
failed: Can't connect to MySQL server on '10.1.1.80' (115) at
/usr/local/apache/cgi-bin/Shared/DBStuff.pm l
://dev.mysql.com/doc/mysql/en/Problems_with_mysql.sock.html
-Original Message-
From: Rajashik Kar
To: [EMAIL PROTECTED]
Sent: 8/18/04 2:06 AM
Subject: Can't connect to local MySQL server through socket
Hi,
Iam getting the error "Can't connect to local MySQL server through
socke
Hi,
Iam getting the error "Can't connect to local MySQL server through socket" whenever
Iam trying to start mysql prompt.
Kindly Help. Following is the trace. Iam using an Unix Solaris8.
svtlab7/opt/mysql/bin% mysql -u root -p
Enter password:
ERROR 2002: Can't connect t
On Monday 19 July 2004 12:12, charitha wrote:
> Hi, You just check the entry in your /etc/my.cnf file where your .sock
> file is configured
my.conf says for server and client configuration:
socket = /var/lib/mysql/mysql.sock
So the path is correct
> if it is not this path then change it and res
>
Sent: Monday, July 19, 2004 12:46 PM
Subject: ERROR 2002: Can't connect to local MySQL server through socket
'/var/lib/mysql/mysql.sock' (2)
> Hello! I'm new to MySQl and I have sevral problems to get the Mysql-server
> going.
> First of all, when trying to c
1 - 100 of 299 matches
Mail list logo
