Re: Can't Connect Localhost
Hello John, On 9/2/2013 12:49 AM, John Smith wrote: On Sun, 1/9/13, Reindl Harald h.rei...@thelounge.net 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 pass 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
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 http://dev.mysql.com/doc/refman/5.5/en/server-system-variables.html helps, after mysqladmin -uroot -p variables (somepathyoumayuse) OR mysql -uroot -p -eshow 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
__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 te...@tjsoftworks.com wrote: Subject: Re: Can't Connect Localhost To: mysql@lists.mysql.com Cc: John Smith cantinaderecuer...@yahoo.com 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 cantinaderecuer...@yahoo.com 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
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 cantinaderecuer...@yahoo.com 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
On Sun, 1/9/13, Reindl Harald h.rei...@thelounge.net 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
Am 01.09.2013 15:37, schrieb John Smith: On Sun, 1/9/13, Reindl Harald h.rei...@thelounge.net 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 hostname -u test -p Enter password: ERROR 2003 (HY000): Can't connect to MySQL server on 'hostname' (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
Try mysql -u root -h 127.0.0.1 -p And if that doesn't work mysql -u root -h PC IP address -p On Sep 1, 2013, at 4:59 AM, John Smith cantinaderecuer...@yahoo.com 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 te...@tjsoftworks.com wrote: Subject: Re: Can't Connect Localhost To: mysql@lists.mysql.com Cc: John Smith cantinaderecuer...@yahoo.com 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 cantinaderecuer...@yahoo.com 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
On Sun, 1/9/13, Reindl Harald h.rei...@thelounge.net 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 pass 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
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
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
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
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 cantinaderecuer...@yahoo.com 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