[Solved] Ban Management/MySQL problem

Discussion in 'Systems Administration' started by TheMasteredPanda, May 21, 2016.

  1. Hey,

    ok so I am nearly done setting up my Ban Management page I just cannot connect the SQL database to the website. The SQL server and the website are both hosted on the same machine, the node connecting to the SQL server externally (don't know if that makes a difference). It gives me this error when I click finish http://prntscr.com/b6r2p2 . Here is the configuration: http://prntscr.com/b6ruje

    Cheers,
    Panda :)!
     
  2. A couple things here:
    • In your MySQL config file, check and see if bind-address is uncommented in your config file (and has a value of 0.0.0.0)
    • Make sure what user you are trying to use allows connections from the external server (usually depicted as [email protected]<ip of the server that's trying to access MySQL>
    • Some security best practices:
      • Don't use the MySQL root user for applications, especially if you are allowing external connections to it
      • Use a proper password
      • Since you set the bind-address to 0.0.0.0, you definitely want to firewall your server just in case
     
  3. Aight I'll look into the security malark, does the bind address have to be set to 0.0.0.0/commented out for it to he able to connect to the website as the mc server?
     
  4. Yes.
     
  5. I would recommend you to set the mysql host in your website config to "localhost" or "172.0.0.1"

    (using your external ip when the database is hosted on the same machine can cause some issues with some ISPs, mine for example blocks me from accessing our network from within it; i can't access our public ip)
     
  6. Resolved it, cheers peps.