Re: Conecting to MySQL
On 8/8/22 19:26, Guilherme Campos wrote: > Hello folks, > > trying to connect to MYSQL it appears the error msg below: > InterfaceError: 2003: Can't connect to MySQL server on 'localhost:3306' > (111 Connection refused) > [image: conexao.png] > How can i fix that.? MySQL can listen on a local unix socket (named pipe in Windows), an internet TCP/IP port, or both. If your MySQL is running, it could be listening on the local socket or named port, which has a different url than localhost:3306. MySQL can be configured to also listen on a TCP/IP port, which is what you code is apparently expecting. Although the fact that your MySQL Workbench cannot connect either suggests that MySQL is not running at all. Configuring MySQL is a bit beyond the scope of this list, although I'm sure there are people here who know how to do it. What OS are you using? -- https://mail.python.org/mailman/listinfo/python-list
Re: Conecting to MySQL
I'm not sure about this but this mailing list does not allow attachments ... On Tue, Aug 09, 2022 at 12:45:33PM -0300, Guilherme Campos wrote: Hi Igor, Accessing mysql-workbench it appeared new error messages when I clicked Server Status. I created my database on MySQL Workbench . Is that your question? [image: image.png] [image: image.png] Em ter., 9 de ago. de 2022 às 12:36, Igor Korot escreveu: Hi, @OP, Can you try to connect with mysql-workbench? Also - you didn't answer my first question. Are you using an ODBC wrapper or python module? Thank you. On Tue, Aug 9, 2022 at 10:27 AM Axy wrote: > > > >> trying to connect to MYSQL it appears the error msg below: > >> InterfaceError: 2003: Can't connect to MySQL server on 'localhost:3306' > >> (111 Connection refused) > >> [image: conexao.png] > >> How can i fix that.? > > What do you use for connection? > > Does the firewall interfere with the connection? > > Firewall usually causes connection to hang and timeout with no response. > > But in this case connection looks immediately refused which means either > port number is wrong or mysql is not listening on 127.0.0.1. > > > Axy > -- https://mail.python.org/mailman/listinfo/python-list -- Daniel Ciprus .:|:.:|:. CONSULTING ENGINEER.CUSTOMER DELIVERY Cisco Systems Inc. dcip...@cisco.com tel: +1-703-484-0205 mob: +1-540-223-7098 [ curl -L http://git.io/unix ] signature.asc Description: PGP signature -- https://mail.python.org/mailman/listinfo/python-list
Re: Conecting to MySQL
Yes, exactly that .. I replied from different account and my email was rejected. Just make sure that your mysql is actually running. Depending on your OS, run netstat -an | grep 3306 and this will tell you whether socket is actually in listening mode or not. If it's not, your mysql is either not running or you have a problem with the configuration. On Tue, Aug 09, 2022 at 08:27:16AM -0700, Axy via Python-list wrote: trying to connect to MYSQL it appears the error msg below: InterfaceError: 2003: Can't connect to MySQL server on 'localhost:3306' (111 Connection refused) [image: conexao.png] How can i fix that.? What do you use for connection? Does the firewall interfere with the connection? Firewall usually causes connection to hang and timeout with no response. But in this case connection looks immediately refused which means either port number is wrong or mysql is not listening on 127.0.0.1. Axy -- https://mail.python.org/mailman/listinfo/python-list -- Daniel Ciprus .:|:.:|:. [ curl -L http://git.io/unix ] signature.asc Description: PGP signature -- https://mail.python.org/mailman/listinfo/python-list
Re: Conecting to MySQL
Hi Igor, Accessing mysql-workbench it appeared new error messages when I clicked Server Status. I created my database on MySQL Workbench . Is that your question? [image: image.png] [image: image.png] Em ter., 9 de ago. de 2022 às 12:36, Igor Korot escreveu: > Hi, > @OP, > Can you try to connect with mysql-workbench? > Also - you didn't answer my first question. > > Are you using an ODBC wrapper or python module? > > Thank you. > > > On Tue, Aug 9, 2022 at 10:27 AM Axy wrote: > > > > > > >> trying to connect to MYSQL it appears the error msg below: > > >> InterfaceError: 2003: Can't connect to MySQL server on > 'localhost:3306' > > >> (111 Connection refused) > > >> [image: conexao.png] > > >> How can i fix that.? > > > What do you use for connection? > > > Does the firewall interfere with the connection? > > > > Firewall usually causes connection to hang and timeout with no response. > > > > But in this case connection looks immediately refused which means either > > port number is wrong or mysql is not listening on 127.0.0.1. > > > > > > Axy > > > -- https://mail.python.org/mailman/listinfo/python-list
Re: Conecting to MySQL
Hi, @OP, Can you try to connect with mysql-workbench? Also - you didn't answer my first question. Are you using an ODBC wrapper or python module? Thank you. On Tue, Aug 9, 2022 at 10:27 AM Axy wrote: > > > >> trying to connect to MYSQL it appears the error msg below: > >> InterfaceError: 2003: Can't connect to MySQL server on 'localhost:3306' > >> (111 Connection refused) > >> [image: conexao.png] > >> How can i fix that.? > > What do you use for connection? > > Does the firewall interfere with the connection? > > Firewall usually causes connection to hang and timeout with no response. > > But in this case connection looks immediately refused which means either > port number is wrong or mysql is not listening on 127.0.0.1. > > > Axy > -- https://mail.python.org/mailman/listinfo/python-list
Re: Conecting to MySQL
trying to connect to MYSQL it appears the error msg below: InterfaceError: 2003: Can't connect to MySQL server on 'localhost:3306' (111 Connection refused) [image: conexao.png] How can i fix that.? What do you use for connection? Does the firewall interfere with the connection? Firewall usually causes connection to hang and timeout with no response. But in this case connection looks immediately refused which means either port number is wrong or mysql is not listening on 127.0.0.1. Axy -- https://mail.python.org/mailman/listinfo/python-list
Re: Conecting to MySQL
Igor, firewall was disable... Em ter., 9 de ago. de 2022 às 11:18, Igor Korot escreveu: > Hi, > > On Tue, Aug 9, 2022 at 9:07 AM Guilherme Campos > wrote: > > > > Hello folks, > > > > trying to connect to MYSQL it appears the error msg below: > > InterfaceError: 2003: Can't connect to MySQL server on 'localhost:3306' > > (111 Connection refused) > > [image: conexao.png] > > How can i fix that.? > > What do you use for connection? > Does the firewall interfere with the connection? > > Thank you. > > > > > thanks in advance > > > > Guilherme Campos > > Belo Horizonte - MG > > -- > > https://mail.python.org/mailman/listinfo/python-list > -- https://mail.python.org/mailman/listinfo/python-list
Re: Conecting to MySQL
Hi, On Tue, Aug 9, 2022 at 9:07 AM Guilherme Campos wrote: > > Hello folks, > > trying to connect to MYSQL it appears the error msg below: > InterfaceError: 2003: Can't connect to MySQL server on 'localhost:3306' > (111 Connection refused) > [image: conexao.png] > How can i fix that.? What do you use for connection? Does the firewall interfere with the connection? Thank you. > > thanks in advance > > Guilherme Campos > Belo Horizonte - MG > -- > https://mail.python.org/mailman/listinfo/python-list -- https://mail.python.org/mailman/listinfo/python-list
Conecting to MySQL
Hello folks, trying to connect to MYSQL it appears the error msg below: InterfaceError: 2003: Can't connect to MySQL server on 'localhost:3306' (111 Connection refused) [image: conexao.png] How can i fix that.? thanks in advance Guilherme Campos Belo Horizonte - MG -- https://mail.python.org/mailman/listinfo/python-list