How to setup MySQL on another server

  • I have tried to move MySQL5.7 to another server on Cloud for security reason.
    This system worked in the test environment (WordPress and MySQL were on the same Cloud server).
    It is not possible to connect it from WordPress with MySQL on another server.

    No.1server: WordPress server (internal IP:10.1.0.2) Windows Server2012 R2
    No.2server: MySQL server (internal IP:10.1.0.6) Windows Server2012 R2.

    I have checked it as follows.

    1) The account of MySQL was able to be accessed from anywhere.
    Hostname : %
    2) Changed parameter of “DB_HOST’, ‘localhost’) of wp-config.php;” –> 10.1.0.6
    3) It is confirmed that 3306 ports are set up in Firewall of Windows Server.
    4) MySQL of No.2 server to connect it from No.1 server with with phpmyadmin.
    ( https://10.1.0.6/phpmyadmin )
    5) Connection error was indicated by using command on No.1 server..
    mysql – u root –h 10.1.0.6 –p
    Error
    ERROR 2003(HY000) : can’t connect to mysql server on ’10.1.0.6’ (10060)
    6) There is no “my.ini” on MYSQL’s folder.

    However, it is not possible to connect it from WordPress of No1 with MySQL of No.2.

    Please let me know the method of settlement.

  • The topic ‘How to setup MySQL on another server’ is closed to new replies.

Tags