Re: Can't Connect Localhost

2013-09-03 Thread hsv
g straight from MySQL client ("mysql.exe"), but something passed through another. What did you enter to get it? Note this quote: The error (2003) Can't connect to MySQL server on 'server' (10061) indicates that the network connection has been refused. You should check that t

Re: Can't Connect Localhost

2013-09-03 Thread shawn green
Hello John, On 9/2/2013 12:49 AM, John Smith wrote: On Sun, 1/9/13, Reindl Harald wrote: Subject: Re: Can't Connect Localhost To: mysql@lists.mysql.com Date: Sunday, 1 September, 2013, 2:44 PM I looked in mysql.config.pl and no "

Re: Can't Connect Localhost

2013-09-01 Thread John Smith
On Sun, 1/9/13, Reindl Harald wrote: Subject: Re: Can't Connect Localhost To: mysql@lists.mysql.com Date: Sunday, 1 September, 2013, 2:44 PM > > I looked in mysql.config.pl and no "localhost" :( > "mysql.config.

Re: Can't Connect Localhost

2013-09-01 Thread Howard Hart
Try mysql -u root -h 127.0.0.1 -p And if that doesn't work mysql -u root -h -p On Sep 1, 2013, at 4:59 AM, "John Smith" wrote: > __mysql_exceptions,OperationalError (2003 "Can't connect to MySQL server on > 'localhost' (10061)") > > My q

Re: Can't Connect Localhost

2013-09-01 Thread Reindl Harald
Am 01.09.2013 15:37, schrieb John Smith: > > On Sun, 1/9/13, Reindl Harald wrote: > > Subject: Re: Can't Connect Localhost > To: mysql@lists.mysql.com > Date: Sunday, 1 September, 2013, 1:34 PM > > where you can

Re: Can't Connect Localhost

2013-09-01 Thread John Smith
On Sun, 1/9/13, Reindl Harald wrote: Subject: Re: Can't Connect Localhost To: mysql@lists.mysql.com Date: Sunday, 1 September, 2013, 1:34 PM where you can change this? typically in the config file of teh software without crystal balls we

Re: Can't Connect Localhost

2013-09-01 Thread Reindl Harald
e Am 01.09.2013 13:56, schrieb John Smith: > __mysql_exceptions,OperationalError (2003 "Can't connect to MySQL server on > 'localhost' (10061)") > > My question: How do I change from localhost to 124.0.0.1? > > Hi John, > > Starting over…. > &

Re: Can't Connect Localhost

2013-09-01 Thread John Smith
__mysql_exceptions,OperationalError (2003 "Can't connect to MySQL server on 'localhost' (10061)") My question: How do I change from localhost to 124.0.0.1? TIA John On Sun, 1/9/13, Terry J Fundak wrote: Subject: Re: Ca

Re: Can't Connect Localhost

2013-08-31 Thread Terry J Fundak
Hi John, Starting over…. What is the "error message"? Terry ___ Terry J Fundak Systems Engineer Network Design and Security Solutions for SMBs Tech Support - Client and Server Systems TJSoftworks 1834 Chadwick Court Santa Rosa, CA 95401 (707) 849-1000 Cell e

Re: Can't Connect Localhost

2013-08-31 Thread Reindl Harald
Am 01.09.2013 01:02, schrieb Terry J Fundak: > Also https://en.wikipedia.org/wiki/Localhost for move reading on the > subject > > Sorry if I'm missing your issue why do you think that i have any issue and why do you insist to reply offlist? > On Aug 31, 2013, at 15:41, Reindl Harald

Re: Can't Connect Localhost

2013-08-31 Thread Reindl Harald
first: you not answer off-list on list-repsones Am 01.09.2013 01:00, schrieb Terry J Fundak: > So... I guess I need to ask: Do you know that 127.0.0.1/localhost only refers > to the machine you are on, right? naturally yes > One cannot, for example, attempt to login to a remote host with that

Re: Can't Connect Localhost

2013-08-31 Thread Reindl Harald
Am 01.09.2013 00:26, schrieb John Smith: > How do I change my connection from localhost to 127.0.0.1 on a Win8 machine? in which context? mysql -h 127.0.0.1.. signature.asc Description: OpenPGP digital signature

Can't Connect Localhost

2013-08-31 Thread John Smith
Hi; How do I change my connection from localhost to 127.0.0.1 on a Win8 machine? TIA, John -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql

Re: Why "ERROR 2003 (HY000): Can't connect to MySQL server on '192.168.27.72' (111)"?

2013-06-13 Thread Johan De Meersman
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

Why "ERROR 2003 (HY000): Can't connect to MySQL server on '192.168.27.72' (111)"?

2013-06-13 Thread lx
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.

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

2012-04-13 Thread Claudio Nanni
; socket = /var/run/mysqld/mysqld.sock > > > socket = /var/run/mysqld/mysqld.sock > > > socket = /var/run/mysqld/mysqld.sock > > > > > > root@devel:~# /etc/init.d/mysql restart > > > Stopping MySQL database server: mysqld. > > > Sta

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

2012-04-11 Thread Prabhat Kumar
ld/mysqld.sock > > socket = /var/run/mysqld/mysqld.sock > > socket = /var/run/mysqld/mysqld.sock > > > > root@devel:~# /etc/init.d/mysql restart > > Stopping MySQL database server: mysqld. > > Starting MySQL database server: mysqld . . . . . . . . . . .

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

2012-04-11 Thread Larry Martell
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'

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

2012-04-11 Thread mail...@securitylabs.it
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

Re: Can't connect as non-root user to database

2012-03-16 Thread shawn green
On 3/16/2012 2:41 PM, Clemens Eisserer wrote: Hi Shawn, I understand the logic behind seperating local and remote users, postgresql does the same thing in its pg_hba.conf file. However, what I don't understand is the way this turned out to be such a huge problem (for me), as it worked already wi

Re: Can't connect as non-root user to database

2012-03-16 Thread Claudio Nanni
Hi Clemens, my pleasure! I forgot, you had to use also -P3306, so using both -h and -P which deny the lookup for users at localhost, forcing TCP-IP. and so IPs. this is also good when the socket file is not in the standard location, you will have the same problem logging in locally, using -h and

Re: Can't connect as non-root user to database

2012-03-16 Thread Clemens Eisserer
Hi Shawn, I understand the logic behind seperating local and remote users, postgresql does the same thing in its pg_hba.conf file. However, what I don't understand is the way this turned out to be such a huge problem (for me), as it worked already with MySQL-5.1 a few years ago. I've worked with o

Re: Can't connect as non-root user to database

2012-03-16 Thread Clemens Eisserer
Hi Claudio, > you probably have the anonymous user account taking over:   ''@'localhost' > login as root and: > mysql> drop user ''@'localhost'; Thanks a lot, that solved the problem (and saved my day :) !). > when you specify the host with -h you are actually forcing MySQL to use > TCP/IP so it

Re: Can't connect as non-root user to database

2012-03-16 Thread shawn green
On 3/16/2012 7:00 AM, Clemens Eisserer wrote: Hi Rik, Hm, is the mysql-client library the same as the mysql-server? Yes. And does mysql --host=127.0.0.1 --user=someone -p somedb work (or it's actual IP-address, forcing the TCP/IP connect instead of possible sockets) ? This is really strang

Re: Can't connect as non-root user to database

2012-03-16 Thread Rik Wasmus
> > Hm, is the mysql-client library the same as the mysql-server? > > Yes. Aight... > > And does mysql --host=127.0.0.1 --user=someone -p somedb work (or it's > > actual IP-address, forcing the TCP/IP connect instead of possible > > sockets) ? > > This is really strange - with -h127.0.0.1 I get

Re: Can't connect as non-root user to database

2012-03-16 Thread Claudio Nanni
If you want to verify it is very easy: $ mysql --user=someone somedb (without -p) mysql> select user(); select current_user(); cheers Claudio 2012/3/16 Claudio Nanni > you probably have the anonymous user account taking over: ''@'localhost' > > when you specify the host with -h you

Re: Can't connect as non-root user to database

2012-03-16 Thread Claudio Nanni
you probably have the anonymous user account taking over: ''@'localhost' when you specify the host with -h you are actually forcing MySQL to use TCP/IP so it will authenticate you using your ip address (127.0.0.1) login as root and: mysql> drop user ''@'localhost'; and try again Cheers Claud

Re: Can't connect as non-root user to database

2012-03-16 Thread Clemens Eisserer
Hi Rik, > Hm, is the mysql-client library the same as the mysql-server? Yes. > And does mysql --host=127.0.0.1 --user=someone -p somedb work (or it's actual > IP-address, forcing the TCP/IP connect instead of possible sockets) ? This is really strange - with -h127.0.0.1 I get the same error: ERR

Re: Can't connect as non-root user to database

2012-03-16 Thread Claudio Nanni
Hi, 1. FLUSH PRIVILEGES is not needed, the SQL commands to manage user and grants reload automatically the grant tables, that was used in the very past when people use to tinker directly the grant tables. 2. you did not specify the @ part of the 'someone' : GRANT ALL ON somedb.* TO 'someone

Re: Can't connect as non-root user to database

2012-03-16 Thread Rik Wasmus
> Hi Rik, > > > Have you tried the _full_ user-identification (which is with host)? > > > > GRANT ALL ON somedb.* TO 'someone'@'%'; > > Yes I had (and just tried to verify) but it didn't help. Oops, didn't use reply-to-list instead of reply-to-author, my apologies... > Could it be Fedora's mys

Re: Can't connect as non-root user to database

2012-03-16 Thread Clemens Eisserer
Hi Rik, > Have you tried the _full_ user-identification (which is with host)? > > GRANT ALL ON somedb.* TO 'someone'@'%'; Yes I had (and just tried to verify) but it didn't help. Could it be Fedora's mysql packages are special somehow? Re-installing mysql after deletig its data-directory didn't

Can't connect as non-root user to database

2012-03-16 Thread Clemens Eisserer
Hi, All I would like to do is the create a small database with a non-root user which is allowed to access the db, however after hours of trying I gave up. I am using MySQL-5.5.20 on Fedora16 . CREATE USER 'someone'@'%' IDENTIFIED BY 'somepass'; CREATE DATABASE somedb; GRANT ALL ON somedb.* TO 'so

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
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

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

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

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

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

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

2009-10-27 Thread F.A.I.Z.A.L
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

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

2009-10-26 Thread lists
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/

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

2009-10-26 Thread F.A.I.Z.A.L
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

Fw: mysqlcheck: Got error 202: Can't connect to local MySQL server through socket '/home/qsys/mysql-5.1.32/temp/mysql.sock'

2009-05-03 Thread michel
--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

mysqlcheck: Got error 202: Can't connect to local MySQL server through socket '/home/qsys/mysql-5.1.32/temp/mysql.sock'

2009-05-03 Thread michel
-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'

Re: Intermittent "Can't connect to MySQL server on '' (4)" (2003)" after 20+ days uptime

2008-08-18 Thread Michael Dykman
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

Re: Intermittent "Can't connect to MySQL server on '' (4)" (2003)" after 20+ days uptime

2008-08-18 Thread Sreekanth CHAVA
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

Intermittent "Can't connect to MySQL server on '' (4)" (2003)" after 20+ days uptime

2008-08-18 Thread Pieter de Zwart
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

Re: ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/tmp/mysql.sock' (61)

2008-04-06 Thread Moon's Father
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 > # >

Re: ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/tmp/mysql.sock' (61)

2008-04-03 Thread Joerg Bruehe
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

Re: ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/tmp/mysql.sock' (61)

2008-04-03 Thread Vidal Garza
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)

Re: ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/tmp/mysql.sock' (61)

2008-04-03 Thread Joerg Bruehe
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

Re: ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/tmp/mysql.sock' (61)

2008-04-02 Thread Krishna Chandra Prajapati
','`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

ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/tmp/mysql.sock' (61)

2008-04-02 Thread Vidal Garza
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

Re: ERROR 2002 (HY000): Can't connect to local MySQL server

2007-06-20 Thread Michael Cole
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

RE: ERROR 2002 (HY000): Can't connect to local MySQL server

2007-06-19 Thread John Mancuso
: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]>

RE: ERROR 2002 (HY000): Can't connect to local MySQL server

2007-06-19 Thread John Mancuso
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

RE: ERROR 2002 (HY000): Can't connect to local MySQL server

2007-06-19 Thread John Mancuso
-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

ERROR 2002 (HY000): Can't connect to local MySQL server

2007-06-19 Thread Ahamarshan jn
. 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

Re: error 99(?) : can't connect to MySQL server

2007-02-06 Thread Fagyal Csongor
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

Re: error 99(?) : can't connect to MySQL server

2007-02-06 Thread Nils Meyer
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

error 99(?) : can't connect to MySQL server

2007-02-06 Thread Fagyal Csongor
Hi, I have an interesting (a.k.a. frustrating) problem on MySQL 4.1.11. I try to connect to the database via DBD::mysql. Everything works - except in a few cases (once in every 1 occasions, approximately) I get: DBI connect('database=test:host=192.168.0.200','test'

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

2006-08-01 Thread scott . anderson
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

can't connect to server using mysqladmin or mysql

2006-08-01 Thread scott . anderson
qld_safe --datadir=/var/lib/mysql --pid-file=/var/lib/mysql/puma.wellesley.edu.pid mysql12832 12811 0 11:11 pts/000:00:00 /usr/sbin/mysqld --basedir=/ --datadir=/var/lib/mysql --user=mysql --pid-file=/var/lib/mysql/puma.wellesley.edu.pid --skip-locking So, it looks like the server is ru

Can't connect to mysql.sock

2006-07-14 Thread Dave M G
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.

Re: all of a sudden can't connect to server..

2006-06-08 Thread Daniel da Veiga
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

Re: I can't connect to mysql server with PHP

2006-05-24 Thread gerald_clark
>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

Re: Re: I can't connect to mysql server with PHP

2006-05-23 Thread 战芳
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"

Re: I can't connect to mysql server with PHP

2006-05-22 Thread gerald_clark
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.

I can't connect to mysql server with PHP

2006-05-22 Thread fool.ben
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#/

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

2006-03-28 Thread mysql
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

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

2006-03-28 Thread Áquila Chaves
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

Re: APACHE 2.0 can't connect to MYSQL 5 when using PHP 5.1.2

2006-02-16 Thread mysql
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

Re: APACHE 2.0 can't connect to MYSQL 5 when using PHP 5.1.2

2006-02-16 Thread SGreen
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

APACHE 2.0 can't connect to MYSQL 5 when using PHP 5.1.2

2006-02-16 Thread persant mpote
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

Re: ERROR 2003 (HY000): Can't connect to MySQL server on 'gandalf' (111)

2005-12-04 Thread Simon Garner
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

ERROR 2003 (HY000): Can't connect to MySQL server on 'gandalf' (111)

2005-12-04 Thread Mike Smith
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

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

2005-12-02 Thread SGreen
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

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

2005-12-02 Thread Jenny Chen
> > > > > > > > > > > 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

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

2005-12-02 Thread Jenny Chen
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

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 20

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

2005-12-02 Thread Jenny Chen
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

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

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

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

Re: why i can't connect to the mysql server from a client pc?

2005-10-19 Thread Jigal van Hemert
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 &

why i can't connect to the mysql server from a client pc?

2005-10-18 Thread zhou bin
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.**.***'

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

Can't connect to mysql server from another windows box

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

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

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

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

2005-09-13 Thread Ed Collins
>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

Re: Can't connect from remote computer

2005-07-12 Thread Nuno Pereira
Probably one problems with permissions. Salama hussein wrote: I can't connect to Mysql from a remote computer yet I can log in fine locally. When I telnet from a remote computer to port 3306, I get a response. The response wasn't meaningful but it was a response. Any idea

Re: Can't connect from remote computer

2005-07-12 Thread Duncan Hill
On Tuesday 12 July 2005 14:25, Salama hussein typed: > I can't connect to Mysql from a remote computer yet I can log in fine > locally. When I telnet from a remote computer to port 3306, I get a > response. The response wasn't meaningful but it was a response. Exact error

Can't connect from remote computer

2005-07-12 Thread Salama hussein
I can't connect to Mysql from a remote computer yet I can log in fine locally. When I telnet from a remote computer to port 3306, I get a response. The response wasn't meaningful but it was a response. Any ideas? Salama -- MySQL General Mailing List For list arch

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

Can't connect to Local Mysql database server

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

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

  1   2   3   4   5   >