Re: Can't connect to MySQL server on '127.0.0.1' (111)

2011-04-02 Thread xPol
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.

Re: Can't connect to MySQL server on '127.0.0.1' (111)

2011-04-02 Thread Reindl Harald
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..

Re: Can't connect to MySQL server on '127.0.0.1' (111)

2011-04-02 Thread xPol
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

Re: Can't connect to MySQL server on '127.0.0.1' (111)

2011-04-02 Thread Reindl Harald
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

Re: Can't connect to MySQL server on '127.0.0.1' (111)

2011-04-02 Thread xPol
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

Re: Can't connect to MySQL server on '127.0.0.1' (111)

2011-04-02 Thread xPol
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

Re: Can't connect to MySQL server on '127.0.0.1' (111)

2011-04-02 Thread Andrew Moore
I think you'll need to give us a bit more to go on. I presume this is a web based app? What have you changed? Has the MySQL daemon stopped? What have you changed? On Sat, Apr 2, 2011 at 4:10 PM, xPol wrote: > I have been using my local dictionary for years, accessing from web > browser, > poin

Re: Can't connect to MySQL server on '127.0.0.1' (111)

2011-04-02 Thread Reindl Harald
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? Am 02.04.2011 17:10, schrieb xPol: > I have been using my local dictionary for years, accessing from web browser, > pointing to http://localhost:9000/ >

Re: can't connect to server using mysqladmin or mysql

2006-08-01 Thread scott . anderson
I would like to withdraw my earlier bug report with the same subject line. I discovered that an erroneous IP address for the server machine had gotten into /etc/hosts (due to some IP changes in my organization). Once the DNS error was resolved, I was able to connect correctly and fix the password

Re: can't connect to the MySQL server from remote machine?

2005-12-02 Thread SGreen
That means that the MySQL server installed on the machine on which you issued the command is running AND that it can be connected to by the local loopback address (127.0.0.1). This still does not mean that you can connect to it from any other machine as your firewall may permit local (within th

Re: can't connect to the MySQL server from remote machine?

2005-12-02 Thread Jenny Chen
Hi, I tried with "telnet localhost 3306" locally, and got the message as: "Connected to localhost.localdomain (127.0.0.1). Escape character is '^]'. = 5.0.16-standard!QS//?.e,7~9>iw;]E!r=Connection closed by foreign host." What is this meaning? Thanks, Jenny On 12/2/05, Fernando Antunes <[EMAI

Re: can't connect to the MySQL server from remote machine?

2005-12-02 Thread Jenny Chen
Yes, I did try both hostname and IP, but can't work although I can ping to the two boxes from each other. Just wondering if it is because of the port(3306) got disabled?? Thanks, Jenny On 12/2/05, [EMAIL PROTECTED] <[EMAIL PROTECTED]> wrote: > > > > Jenny Chen <[EMAIL PROTECTED]> wrote on 12/

Re: can't connect to the MySQL server from remote machine?

2005-12-02 Thread SGreen
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 2003 (HY000): Can't connect to MySQL server

Re: Can't connect to MySQL v5.0.15 on 'Windows XP

2005-11-16 Thread Gleb Paharenko
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

Re: Can't connect to mysql server from another windows box

2005-09-20 Thread Gerald Williams
>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

Re: Can't connect to mysql server from another windows box

2005-09-20 Thread Gerald Williams
>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

Re: Can't connect to mysql server from another windows box

2005-09-20 Thread Michael Stassen
[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

Re: Can't connect to mysql server from another windows box

2005-09-20 Thread SGreen
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

Re: Can't connect to Local Mysql database server

2005-06-08 Thread Gleb Paharenko
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

RE: 'Can't connect to local MySQL server....' error

2005-03-29 Thread bruce
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

RE: 'Can't connect to local MySQL server....' error

2005-03-28 Thread Tom Crimmins
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...' error. > > i've tried to 'fix' the tables 'mysql_fix_privileg

Re: Can't connect to local MySQL server through socket'/var/lib/m ysql/mysql.sock'

2004-11-01 Thread ian douglas
[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

Re: Can't connect to local MySQL server through socket'/var/lib/m ysql/mysql.sock'

2004-11-01 Thread Cecep Rosuludin
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

Re: Can't connect to local MySQL server through socket'/var/lib/m ysql/mysql.sock'

2004-11-01 Thread ian douglas
[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

Re: Can't connect to local MySQL server through socket'/var/lib/m ysql/mysql.sock'

2004-11-01 Thread Cecep Rosuludin
(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

Re: Can't connect to local MySQL server through socket'/var/lib/m ysql/mysql.sock'

2004-11-01 Thread Cecep Rosuludin
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

Re: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock'

2004-11-01 Thread Pahlevanzadeh Mohsen
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

Re: Can't connect to DB after upgrading to mysql 4.1.5

2004-10-05 Thread Paul DuBois
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

Re: Can't connect to DB after upgrading to mysql 4.1.5

2004-10-05 Thread SGreen
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

RE: Can't connect to DB after upgrading to mysql 4.1.5

2004-10-05 Thread Kevin Cowley
Claire The Authentication protocols changed with 4.1. If you do a search on the archive this subject has come up several times. Either upgrade your perl interface or make 4.1.5 use the old protocol. Kevin Cowley R&D Tel: 0118 902 9099 (direct line) Email: [EMAIL PROTECTED] Web: http://www.alche

RE: Can't connect to local MySQL server through socket

2004-08-18 Thread Victor Pendleton
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

Re: Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock'

2004-06-11 Thread Egor Egorov
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.

Re: Can't connect to MySQL server on 'localhost' (10061)

2004-01-29 Thread [EMAIL PROTECTED]
7;ll let you know if connecting from the laptop works. chris -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Wednesday, January 28, 2004 6:40 PM To: [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Subject: Re: Can't connect to MySQL server on 'loc

Re: Can't connect to MySQL server on 'localhost' (10061)

2004-01-28 Thread [EMAIL PROTECTED]
I assume that you know the the server's ip and then try: from DOS: mysql -h ipaddressofserver -u user1 -ppassword1 --type this as is with your server's ip Also you need to be running 4.1.1 client on your laptop. N. Chris Frost wrote: With several others, I too have this problem. MySQL 4.1.1 ins

Re: Can't connect to MySQL server on 'localhost' (10061)

2004-01-28 Thread [EMAIL PROTECTED]
ednesday, January 28, 2004 4:15 PM To: N. Chris Frost Cc: [EMAIL PROTECTED] Subject: Re: Can't connect to MySQL server on 'localhost' (10061) I assume that you know the the server's ip and then try: from DOS: mysql -h ipaddressofserver -u user1 -ppassword1 --type this as is with

Re: Can't connect to MySQL server on 'localhost' (10061)

2004-01-28 Thread Brian Harris
I assume that you know the the server's ip and then try: from DOS: mysql -h ipaddressofserver -u user1 -ppassword1 --type this as is with your server's ip Also you need to be running 4.1.1 client on your laptop. N. Chris Frost wrote: With several others, I too have this problem. MySQL 4.1.1 ins

Re: Can't connect to MySQL server

2004-01-10 Thread Aaron Gerber
Roger and Johannes, The default did have the "skip-networking" on. I commented that out as you advised, and it worked like a Charm!! I'm pretty excited to be able to have that working now. I really really appreciate the prompt reply and the consideration that you both took in your replies.

Re: Can't connect to MySQL server

2004-01-10 Thread Roger Baklund
* Aaron Gerber > I'm new to the list, hope this is the correct mailing list. It is. :) > I have a new installation of MySQL 4.0.16. Default binary installation > (apt-get). It's running on linux (morphix .4). > > Locally, I can connect to the MySQL server > > mysql -h localhost -p You are not

Re: Can't connect to MySQL server

2004-01-10 Thread Johannes Franken
* Aaron Gerber <[EMAIL PROTECTED]> [2004-01-10 21:33 +0100]: > Locally, I can connect to the MySQL server [...] > but I can't connect if I put in the IP address (locally or remotely) Maybe mysqld is configured to listen on its unix domain socket only? This is the default for Debian. Remove the li

Re: Can't connect to MySQL server on '[server]' (10061) - unix & tcp/ip sockets

2003-10-28 Thread Victoria Reznichenko
"Ben Darlow" <[EMAIL PROTECTED]> wrote: > > I've recently set up a new linux box and installed MySQL 4 (for the > record, Knoppix/Debian and the 'unstable' MySQL 4 package). I've had no > problems connecting using phpMyAdmin, but when I try to connect remotely > using MySQL Control Center or SQLyo

Re: Can't connect to MySQL from remote

2003-10-01 Thread Egor Egorov
[EMAIL PROTECTED] wrote: > I have some problems with MySQL 3.23.52 on RedHat Linux 8.0. > > I can connect to mysql when I am on the same machine but I can't connect to it from > another machine. Here is the error I get: > >> mysqladmin -u cedric -h gdvi02 version > mysqladmin: connect to server

[Fwd: Re: Can't connect to local MySQL question]

2003-08-14 Thread Andreas
--- Begin Message --- On 8/9/03 11:20 PM, "Andreas" <[EMAIL PROTECTED]> wrote: Andreas, Thanks for the help... The error log shows: 030810 14:52:48 mysqld started 030810 14:52:49 InnoDB: Started 030810 14:52:49 Fatal error: Can't open privilege tables: Table 'mysql.host' doesn't exist 0308

Re: Can't connect to local MySQL question

2003-08-14 Thread Andreas
I forwarded your mail to the mysql list so that everyone who cares knows what is going. Bill Hernandez wrote: The error log shows: 030810 14:52:48 mysqld started 030810 14:52:49 InnoDB: Started 030810 14:52:49 Fatal error: Can't open privilege tables: Table 'mysql.host' doesn't exist 030810 1

Re: Can't connect to local MySQL question

2003-08-10 Thread Eternal Designs, Inc
Andreas wrote: Bill Hernandez wrote: I followed the install instructions at http://entropy.ch , and was able to get mySql & php installed on my G4 -> (OSX 10.2.6) last night. I downloaded Navicat and setup a password for the mysql user. I created a connection called myDatabase_connection to a

Re: Can't connect to local MySQL question

2003-08-09 Thread Andreas
Bill Hernandez wrote: I followed the install instructions at http://entropy.ch , and was able to get mySql & php installed on my G4 -> (OSX 10.2.6) last night. I downloaded Navicat and setup a password for the mysql user. I created a connection called myDatabase_connection to a database called myD

Re: Can't connect to local MySQL server through socket '/tmp/mysql.sock'

2003-03-06 Thread Prabu Subroto
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

re: Can't connect to MySQL server & Access denied for root

2003-01-14 Thread Egor Egorov
On Monday 13 January 2003 14:21, Adrian Bucur wrote: > I removed an old mysql version and I installed a new one on a machine > running Suse 8.1 Linux. > shell>rpm -i MySQL-client-3.23.54a-1.i386.rpm > shell>rpm -i MySQL-shared-3.23.54a-1.i386.rpm > shell>rpm -i MySQL-devel-3.23.54a-1.i386.rpm > sh

RE: Can't connect to MySQL server & Access denied for root

2003-01-13 Thread Loren McDonald
Sounds like the same problem I'm having (for which I'm still stumped and don't know what has caused it): table mysql.user is read only. Test this by logging into mysql and using the GRANT or REVOKE statements. -- Loren McDonald Gods Of Music Reviewer/Editor [EMAIL PROTECTED] http://www.GodsOfM

re: Re: Can't connect to local MySql server through socket '/var/lib/mysql/mysql.sock' (111)

2002-10-07 Thread Egor Egorov
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

Re: Can't connect to local MySql server through socket '/var/lib/mysql/mysql.sock' (111)

2002-10-07 Thread Edwin Raj
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??? >>> >

RE: Can't connect to local MySql server through socket '/var/lib/mysql/mysql.sock' (111)

2002-10-06 Thread Ed Carp
> 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

Re: Can't connect to local MySql server through socket '/var/lib/mysql/mysql.sock' (111)

2002-10-06 Thread Niclas Hedhman
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

re: can't connect to remote host

2002-10-03 Thread Victoria Reznichenko
luoya, Thursday, October 03, 2002, 9:01:22 AM, you wrote: ll> I just install mysql 3.23.52-max-nt on two computers. One is Win2K and ll> another is winXP. It seems all right. I use the following commands on ll> both. ll> C:\mysql\bin>mysql ¨Chlocalhost ¨Curoot ¨Cp ll> Mysql prompt: ll> Welcom

Re: can't connect to server

2002-05-24 Thread Andrew Lietzow
Dear Hoa, RE>>> I have the mysql server running. I can't connect to it though. It reads, > "Can't connect to local MySQL server through socket > '/var/lib/mysql/mysql.sock'. - Stop it, (either mysqld or mysql), then start again. On my servers, the mysql startup script is in /e

Re: can't connect to server2

2002-05-23 Thread Egor Egorov
Hoa, Thursday, May 23, 2002, 8:49:36 AM, you wrote: HD> Okay so it says that I can't connect through socket HD> '/var/lib/mysql/mysql.sock'. So I checked and the UNIX socket is located HD> here: /tmp/mysql.sock. I'm relatively new to Linux. What does this mean? You should specify path to yo

Re: can't connect to server2

2002-05-22 Thread 龔惠樑(Borus.Kung)
you can try command "ps -ef | grep mysql" to see if "safe_mysqld" is alive and also one or more "mysqld" processes are running to check the socket type command "netstat -na | grep 3306" see if you can see the processes are listening to the socket if the socket if not being listen, you cannot con

Re: Can't connect to ....

2002-05-19 Thread Samuel Mendelowski
problem in permission; change rights to group an user mysql Jaan Jürgenson > Hi everybody. > > Just installed Red Hat Linux on a machine. I included the MySQL > packages but cant get it up working. > > When starting from shell it looks like this: > > $ mysql > ERROR 2002: Can't connect to loca

Re: Can't connect to ....

2002-05-16 Thread Victoria Reznichenko
Jaan, Thursday, May 16, 2002, 5:19:20 PM, you wrote: JJ> Just installed Red Hat Linux on a machine. I included the MySQL packages JJ> but cant get it up working. JJ> When starting from shell it looks like this: JJ> $ mysql JJ> ERROR 2002: Can't connect to local MySQL server through socket JJ> '

Re: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)

2002-04-26 Thread Neil Highley
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

Re: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)

2002-04-25 Thread Erik Price
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

Re: Can't connect to SERVER MYSQL localhost

2001-12-21 Thread Heikki Tuuri
Daniel, see the online manual at http://www.innodb.com It contains a list of Windows and Linux operating system error codes. Error 3 in Windows means 3 The system cannot find the path specified. ERROR_PATH_NOT_FOUND Check that the directory path c:\mysql\data\ibdata exists. Regards, Heikk

Re: Can't connect to SERVER MYSQL localhost

2001-12-20 Thread Daniel Bechtel
't init databases. Thanks Daniel - Original Message - From: "Jeff Holt" <[EMAIL PROTECTED]> To: "Daniel Bechtel" <[EMAIL PROTECTED]> Sent: Thursday, December 20, 2001 6:10 PM Subject: RE: Can't connect to SERVER MYSQL localhost > Did you remove c:

Re: can't connect to server

2001-12-01 Thread Miguel Angel Solórzano
At 16:11 30/11/2001 +0100, [EMAIL PROTECTED] wrote: Hi, I don't understand very well your problem, anyway here some informations: Using the MySQL Server as Service To start/stop options: 1- net start mysql/net stop mysql 2- using the SCM (Service Control Manager) 3- using the WinMySQLAdmin Whe

RE: Can't connect to new databases

2001-10-31 Thread Quentin Bennett
Bennett Subject: Re: Can't connect to new databases In mysql directly I have no problem. In php, when I run mysql_select_db("database") or die("Failed to connect to database"); I simply get the failed error - Original Message - From: "Quentin B

RE: Can't connect to new databases

2001-10-31 Thread Quentin Bennett
Hi, What error message do you get. Quentin -Original Message- From: Ryan Booker [mailto:[EMAIL PROTECTED]] Sent: Thursday, 1 November 2001 1:22 p.m. To: [EMAIL PROTECTED] Subject: Can't connect to new databases I have recently installed mySQL 3.23.43. I will be using it to run a webs

Re: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (111)

2001-09-19 Thread Alexander Skwar
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

RE: Can't connect to source

2001-09-05 Thread Venu
)-Original Message- )From: Roland Thompson [mailto:[EMAIL PROTECTED]] )Sent: Wednesday, September 05, 2001 3:38 AM )To: [EMAIL PROTECTED] )Subject: Can't connect to source ) ) )Hi, ) )I’ve just started playing about with MySQL. I created a database called )‘haworth’, no problem there, then

Re: Can't connect to source

2001-09-05 Thread Igbar Foosenhopper
Hello Roland, Basically users are defined with their 'hostname'. So if i dial in from my isp it might be [EMAIL PROTECTED] so I have to define rights to that user. Along with the manual bit below .. you might want to get Paul DuBois's great book on Mysql. This bit is from the manual .. 7.35

Re: Can't connect to source

2001-09-05 Thread Gerald Clark
Read the manual, especially the section on the GRANT command. Roland Thompson wrote: > Hi, > > I've just started playing about with MySQL. I created a database called > 'haworth', no problem there, then created a table called 'list'. > I put 3 entries in it, and checked it using > > SELECT * F

Re: Can't connect to local MySQL server through socket '/tmp/mysql.so ck'(2)

2001-09-05 Thread Gerald Clark
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

Re: Can't connect to local MySQL server through socket '/tmp/mysql.sock'(2)

2001-09-04 Thread Ed Carp
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

Re: Can't connect to local MySQL server through socket '/tmp/mysql.sock'(2)

2001-09-04 Thread George Pitcher
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

Re: Can't connect to local MySQL server through socket '/tmp/mysql.sock'(2)

2001-05-30 Thread Mohammad Shoja
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

Re: Can't connect to local MySQL server through socket '/tmp/mysql.sock'(2)

2001-05-29 Thread SecLists
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

Re: Can't connect to local MySQL server through socket '/tmp/mysql.sock'(2)

2001-05-29 Thread Mohammad Shoja
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

Re: Can't connect to local MySQL server through socket '/tmp/mysql.sock'(2)

2001-05-29 Thread SecLists
> > [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

RE: Can't connect to local MysqlServer through socket 'tmp/mysql.sock

2001-04-19 Thread Johan Martin
Are you running the version that came with Redhat 7.0? I had the same problem and just downloaded a newer version from mysql.com and installed it. That seemed to fix the problem. > -Original Message- > From: Goksel Misirli [SMTP:[EMAIL PROTECTED]] > Sent: Thursday, April 19, 2001 10:24 AM

Re: Can't connect to local MysqlServer through socket 'tmp/mysql.sock

2001-04-19 Thread Chris Worth
it is in the FAQ. On Thu, 19 Apr 2001 20:23:39 +0300, Goksel Misirli wrote: >I can't start mysqld . Can you help me? > >Error message:"Can't connect to local MysqlServer through socket 'tmp/mysql.sock" > > - Before posting

Re: Can't connect to MYSQL Server

2001-04-04 Thread B. van Ouwerkerk
>When I type mysql from the command prompt ... an error occured : > ERROR 2003: Can't connect to MYSQL server on 'localhost' (10061) >What is the problem? >Hanan Don't send me a copy of your message.. I'll get mine from the list.. Did you follow all instructions as found in the manual and from

RE: Can't connect to local MySQL server through socket

2001-03-21 Thread Bryan Coon
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

RE: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (13)

2001-03-21 Thread Cal Evans
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.

Re: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (13)

2001-03-21 Thread Gerald L. Clark
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

Re: Can't connect to local MySQL server through socket '' (111)

2001-03-16 Thread Sinisa Milivojevic
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,

Re: Can't connect to local Mysql server (111)

2001-01-11 Thread
Dear Frank, First of all, try to figure out have MYSQL daemon started. use # ps ax | grep mysql If it will show mysql process then try to run # /{path to mysql installation}/mysql_config --socket --port Reagrds, Ruslan O. Nesterov P.S. Try to read th manual it explains all troubles like it ---