Re: Can't Connect Localhost

[hsv]

 2013/09/02 12:49 +0800, John Smith 
> > I looked in mysql.config.pl and no "localhost" :(
> "mysql.config.pl" from what software damned?
> "mysql.config.pl" does not exist in context of mysql

It exists in the following folder on my Win8 box:

/Program Files (x86)/MySQL/MySQL Server 5.5/bin

Yes, apparently it does exist in context of mysql. At any rate, it didn't work. 
Is there another config file in there? 


That is a Perl script, meant for, under Windows, configuration _reporting_. One 
directory up look for "my.ini". As for its meaning, maybe 
 helps, 
after
mysqladmin -uroot -p variables > (somepathyoumayuse)
OR
mysql -uroot -p -e"show global variables" > (somepathyoumayuse)
for showing all variables that may be in that file.

For me the commands work also with "-hlocalhost" or "-h127.0.0.1" in the 
command-line, as expected.

In any case, your original error message, although it is a MySQL error, as 
Harald said does not look like something 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 there is a 
MySQL server running, that it has network connections enabled, and that the 
network port you specified is the one configured on the server. 


-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql

Re: Can't Connect Localhost

[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 "localhost" :(



"mysql.config.pl" from what software damned?
"mysql.config.pl" does not exist in context of mysql


It exists in the following folder on my Win8 box:

/Program Files (x86)/MySQL/MySQL Server 5.5/bin

Yes, apparently it does exist in context of mysql. At any rate, it didn't work. 
Is there another config file in there?


*what client software you are using to connect to a
mysql-server*


I had written a python script. However, even if I try your and the other 
fellow's suggestion and open up a command prompt with admin privileges and type
mysql -u root -h 127.0.0.1 -p

it just opens up a mysql session, and that only if I do it from the folder 
where that script lives since it's not in the path. Otherwise, it complains it 
can't find the script.
TIA,
John




I am also confused by your apparent dependency on this script 
(mysql_config.pl) to create a client connection.  This is not the 
location that stores or processes or influences your startup parameters. 
 Neither can it be used for creating client-server connections.


http://dev.mysql.com/doc/refman/5.6/en/mysql-config.html


The location of your configuration details is a 'my.ini' file or files 
located in one of these locations


http://dev.mysql.com/doc/refman/5.6/en/option-files.html

What happens when you temporarily rename mysql_config.pl to something 
else? What error messages do you get?


Also.  You have established that using the command line client 
(mysql.exe) works just fine for you.  What is the other tool are you 
attempting to use as a MySQL client that has been giving you problems? 
There are at least two connection libraries you can launch from Python 
that allow you to connect to MySQL.  Which one is yours?


Regards,
--
Shawn Green
MySQL Principal Technical Support Engineer
Oracle USA, Inc. - Hardware and Software, Engineered to Work Together.
Office: Blountville, TN

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql

Re: Can't Connect Localhost

[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.pl" from what software damned?
> "mysql.config.pl" does not exist in context of mysql

It exists in the following folder on my Win8 box:

/Program Files (x86)/MySQL/MySQL Server 5.5/bin

Yes, apparently it does exist in context of mysql. At any rate, it didn't work. 
Is there another config file in there?

> *what client software you are using to connect to a
> mysql-server*

I had written a python script. However, even if I try your and the other 
fellow's suggestion and open up a command prompt with admin privileges and type
mysql -u root -h 127.0.0.1 -p

it just opens up a mysql session, and that only if I do it from the folder 
where that script lives since it's not in the path. Otherwise, it complains it 
can't find the script.
TIA,
John 


--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql

Re: Can't Connect Localhost

[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 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: Can't Connect Localhost
> To: mysql@lists.mysql.com
> Cc: "John Smith" 
> Date: Sunday, 1 September, 2013, 3:33 AM
> 
> 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-Mail: te...@tjsoftworks.com
> 
> 
> 
> 
> 
> On Aug 31, 2013, at 3:26 PM, John Smith 
> wrote:
> 
>> 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
> 
> 
> 
> -- 
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe:http://lists.mysql.com/mysql
> 

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql

Re: Can't Connect Localhost

[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 change this? typically
>  in the config file
>  of teh software without crystal balls we don't know
>  
>  what about tell us what software you are speaking about?
> 
> Well, I'm using MySQL ;) 

"__mysql_exceptions,OperationalError (2003 "Can't connect to MySQL server on 
'localhost' (10061)")"
is surely not the answer of the ordinary mysql-cli-client

why? because it looks like this

mysql -h  -u test -p
Enter password:
ERROR 2003 (HY000): Can't connect to MySQL server on '' (111)

> In my first post, I stated version 5.5 and on Win8/64

fine that does not answer the question which *client software* you are using

> I looked in mysql.config.pl and no "localhost" :(

"mysql.config.pl" from what software damned?
"mysql.config.pl" does not exist in context of mysql

*what client software you are using to connect to a mysql-server*
*why not read the manual of this software*



signature.asc
Description: OpenPGP digital signature

Re: Can't Connect Localhost

[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 don't know
 
 what about tell us what software you are speaking about?

Well, I'm using MySQL ;) In my first post, I stated version 5.5 and on Win8/64. 
I looked in mysql.config.pl and no "localhost" :(
John

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql

Re: Can't Connect Localhost

[Reindl Harald]

where you can change this? typically in the config file
of teh software without crystal balls we don't know

what about tell us what software you are speaking about?

please realize that you have a very bad style of asking questions
http://www.catb.org/esr/faqs/smart-questions.html#before

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….
>  
>  What is the "error message"?
>  
>  On Aug 31, 2013, at 3:26 PM, John Smith 
>  wrote:
>  
>  > Hi;
>  > How do I change my connection from localhost to
>  127.0.0.1 on a Win8 machine?





signature.asc
Description: OpenPGP digital signature

Re: Can't Connect Localhost

[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: Can't Connect Localhost
 To: mysql@lists.mysql.com
 Cc: "John Smith" 
 Date: Sunday, 1 September, 2013, 3:33 AM
 
 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-Mail: te...@tjsoftworks.com
 
 
 
 
 
 On Aug 31, 2013, at 3:26 PM, John Smith 
 wrote:
 
 > 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
 > 
 > 
 


--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql

Re: Can't Connect Localhost

[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-Mail: te...@tjsoftworks.com





On Aug 31, 2013, at 3:26 PM, John Smith  wrote:

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



smime.p7s
Description: S/MIME cryptographic signature

Re: Can't Connect Localhost

[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 wrote:
> 
>>
>>
>> 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

Re: Can't Connect Localhost

[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 IP 
> address or to go from one host to another, right?  

naturally yes

That address is 100% reserved to go to the local machine ..

yes

> unless one has some tricks going on at the port level so that is is piped to 
> another host.

what do you call tricks here?
forward mysql prt 3306 of whatever host to 127.0.0.1:whatever port?

> Thus the terminal command
> mysql -h 127.0.0.1 is going to open a connect to the mysql instance on the 
> current host of the terminal session.
> 
> Does that help?

you need help, not i

> Now, if what you are trying to do is to open a console session to mysql 
> and the above command doesn't work,

i ask with the error message i get

> first, I think that would be pretty unusual and/or a sysadmin has locked the 
> instance 
> to respond from another host . that would be my guess.

why guess if you get a error message?

surely one can restrict a user to hwatever IP address
as well as localhost and 127.0.0.1 is not the same
localhost is a unix-socket, 127.0.0.1 is TCP

with "skip-name-resolve" they are handeled different

however, as said, you need *at least* to provide error messages
you get since the crystal balls of most people are defect

> te...@tjsoftworks.com
> 
> On Aug 31, 2013, at 15:41, Reindl Harald wrote:
> 
>>
>>
>> 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

Re: Can't Connect Localhost

[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