Looking for secure setup mysql on second server for my forum

Discussion in 'Site & Server Administration' started by asteraki1976, Oct 28, 2013.

0
  1. #1
    Hello

    I want for a forum to move the db to another server and i need a secure setup guide to do it....

    Thank you
     
    asteraki1976, Oct 28, 2013 IP
  2. digitalpoint

    digitalpoint Overlord of no one Staff

    Messages:
    38,334
    Likes Received:
    2,613
    Best Answers:
    462
    Trophy Points:
    710
    Digital Goods:
    29
    #2
    You probably would want to get the info from your hosting provider, since it's going to depend on their setup.
     
    digitalpoint, Nov 13, 2013 IP
  3. infinitnet

    infinitnet Member

    Messages:
    56
    Likes Received:
    7
    Best Answers:
    1
    Trophy Points:
    35
    #3
    First you should run the command mysql_secure_installation. Then, bind MySQLd on localhost in case you don't need to connect to it remotely, ie. put "bind-address=127.0.0.1" in your /etc/my.cnf (/etc/mysql/my.cnf on Debian based distros). You should add "local-infile=0" and "symbolic-links=0" as well. That's about it regarding MySQLd. If you're looking for something more advanced, check out: http://www.greensql.com/
     
    infinitnet, Nov 21, 2013 IP