1. Forum
  2. Usenet
  3. COMP.LANG.PYTHON

  • Conecting to MySQL

    From Guilherme Campos@21:1/5 to All on Mon Aug 8 22:26:07 2022
    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

    --- SoupGate-Win32 v1.05
    * Origin: fsxNet Usenet Gateway (21:1/5)
  • From Igor Korot@21:1/5 to guilhermecamposbh@gmail.com on Tue Aug 9 09:18:03 2022
    Hi,

    On Tue, Aug 9, 2022 at 9:07 AM Guilherme Campos
    <guilhermecamposbh@gmail.com> 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

    --- SoupGate-Win32 v1.05
    * Origin: fsxNet Usenet Gateway (21:1/5)
  • From Guilherme Campos@21:1/5 to All on Tue Aug 9 11:55:27 2022
    Igor,

    firewall was disable...

    Em ter., 9 de ago. de 2022 às 11:18, Igor Korot <ikorot01@gmail.com>
    escreveu:

    Hi,

    On Tue, Aug 9, 2022 at 9:07 AM Guilherme Campos
    <guilhermecamposbh@gmail.com> 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


    --- SoupGate-Win32 v1.05
    * Origin: fsxNet Usenet Gateway (21:1/5)
  • From Igor Korot@21:1/5 to axy@declassed.art on Tue Aug 9 10:36:14 2022
    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 <axy@declassed.art> 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


    --- SoupGate-Win32 v1.05
    * Origin: fsxNet Usenet Gateway (21:1/5)
  • From Axy@21:1/5 to All on Tue Aug 9 08:27:16 2022
    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

    --- SoupGate-Win32 v1.05
    * Origin: fsxNet Usenet Gateway (21:1/5)
  • From Guilherme Campos@21:1/5 to All on Tue Aug 9 12:45:33 2022
    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 <ikorot01@gmail.com>
    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 <axy@declassed.art> 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



    --- SoupGate-Win32 v1.05
    * Origin: fsxNet Usenet Gateway (21:1/5)
  • From Dan Ciprus (dciprus)@21:1/5 to Axy via Python-list on Tue Aug 9 18:40:10 2022
    --ztrmxyjegy6tik2k
    Content-Type: multipart/signed; micalg=pgp-sha512;
    protocol="application/pgp-signature"; boundary="3s7dv5usxifg2cct" Content-Disposition: inline


    --3s7dv5usxifg2cct
    Content-Type: text/plain; charset=utf-8; format=flowed
    Content-Disposition: inline
    Content-Transfer-Encoding: quoted-printable

    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 ]

    --3s7dv5usxifg2cct--

    --ztrmxyjegy6tik2k--

    -----BEGIN PGP SIGNATURE-----

    iQGzBAABCgAdFiEEKcglcpuZtkHnB5Z3auFyV77zAhoFAmLyqfQACgkQauFyV77z AhqDbAv/VPuhhIkLvdw6OH76+Ivuz8Kh0i08xtNHbjTyj91yxomum6l+5IrAG22U XN6LN9rJeFEnM/sSzK5diBz6QmIwyGHJLTvN7OjhzuEQsY3n9RLS4TrutYFvtM73 lE80PifT33vuzkivcOkpRCUnw68h3CVViwQyco04Nnzl69Wyqj4YWlrr06Df5wJS JMMCPk1oHGEy/KZ81MilVzMfRtCgIpw/YPX2pjkdGhpFLE+FKnKVtgyoTaUpWNI2 z52II132glaEyYqGMpHmwHhvijboqwrJmZHkFbWEGpiKwbrJJWzEvcsxmkXiNs7L OcHhSJgmfCPmEpz02sTzv9P+4oa51EotbyraQgbVQ4+4qYMIo6vMrJFX+fLgwK6F Aq/f9kwok1RMPsxvWNYVkZ5taY19jQTqrm9EmmJmVaQ1SAbuxHPCm57uoSukUcT1 fekOAFsUYLIu06ndUdS4gkyK3MdVjNj/Z0g/vT9EJGSAKbQEX8pjEMr11OGzwDxN
    PUN9I0iW
    =TLTp
    -----END PGP SIGNATURE-----

    --- SoupGate-Win32 v1.05
    * Origin: fsxNet Usenet Gateway (21:1/5)
  • From Dan Ciprus (dciprus)@21:1/5 to Guilherme Campos on Tue Aug 9 19:01:33 2022
    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 <ikorot01@gmail.com> >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 <axy@declassed.art> 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.
    dciprus@cisco.com
    tel: +1-703-484-0205
    mob: +1-540-223-7098

    [ curl -L http://git.io/unix ]

    -----BEGIN PGP SIGNATURE-----

    iQGzBAABCgAdFiEEKcglcpuZtkHnB5Z3auFyV77zAhoFAmLyrwgACgkQauFyV77z AhoLCQwAqPHF2O1hsd/if3NVB0LkGSpnSard6VdHQvdDOGA5g74IiaGEfQlPvSRG AqvtoBh9xrP04n5CD1fghn4bRr2gFe3O2yMm/c6VSCOOgNO+tBcCAQ+TxU647xgi tCR8rK1z2FPQd41XT5wWH7XdHwgSt3s1E7K6z05XVyoaTcA3jpvKAt6DCktGLfmw Or9BFKhlC32qcLWUsImhd/OuPoXSNSyeB1LoPCYs11rDcQx6r4Nf1L68JHRSfoE+ xDH7HtaT12uvmHj+Gihr16T/vlYeiqYVMPhrKc18DrP5IyVtBzDjcwAimXel+gZD WQtNPPc9EbiAO4sLjRXX+JPARtxPQ1/87K4dxxV+xIZbU9Tq7ZpBIi5sIrDVNCVb xl4pq3mb53TQcsDNkHNzokdoHwlvJJOCLJLt5SG22m8ac7jT3hHndP+r2BrdwHzb FImV7jXGE2VK8D1JmU5a/A7sYdpKABzddFmo3UQcb5DEBzTk3NG5X+D3yXrUlUUG
    mpguCu9K
    =0aOs
    -----END PGP SIGNATURE-----

    --- SoupGate-Win32 v1.05
    * Origin: fsxNet Usenet Gateway (21:1/5)
  • From Michael Torrie@21:1/5 to Guilherme Campos on Sun Aug 14 19:35:54 2022
    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?

    --- SoupGate-Win32 v1.05
    * Origin: fsxNet Usenet Gateway (21:1/5)