Solved SQL No connection could be made because the target machine actively refused it

Discussion in 'Development' started by Levi, Mar 9, 2019.

  1. Levi

    Levi Zombie Pigman

    Messages:
    674
    GitHub:
    captainleviftw
    I use libasyqnl and this is my config.yml.
    I have a mysql user called "[email protected]%" with all permissions to it
    PHP:
    database:
      
    typemysql
      sqlite
    :
        
    fileplugins
      mysql
    :
        
    hostmy vps ip
        username
    tom
        password
    "mypassowrd"
        
    schemamydatabase
    worker
    -limit2
    I installed mysql on my ubuntu vps.
    I think my config is the problem because when i try it locally it works fine and I dont get error.
    The server and MySQL service s running.

    I get error

    Code:
    SQL CONNECT error: No connection could be made because the target machine actively refused it."
     
  2. SOFe

    SOFe Administrator Staff Member PMMP Team Poggit Admin Noobiest member in the PMMP Team

    Messages:
    1,796
    GitHub:
    sof3
    Check your firewall settings. Check if the MySQL server is opened to 0.0.0.0
     
  3. Levi

    Levi Zombie Pigman

    Messages:
    674
    GitHub:
    captainleviftw
    How do i check that
     
  4. Levi

    Levi Zombie Pigman

    Messages:
    674
    GitHub:
    captainleviftw
    ok i connected from my vps but now i cant seem to connect when i run it from my pc
     
  5. Levi

    Levi Zombie Pigman

    Messages:
    674
    GitHub:
    captainleviftw
    nevermind
     

Share This Page

  1. This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
    By continuing to use this site, you are consenting to our use of cookies.