Skip to main content

A remote Mysql and Amazon AWS using WHM

Comments

7 comments

  • web-project
    you will be able to setup remote MySQL using Amazon AWS and linked to WHM (instead of SQL client). How to Create a MySQL Database " Amazon Web Services
    0
  • toplisek
    What about in the case of DB.T2.large Is this also needed as it is just dedicated MYSQL?
    0
  • web-project
    What about in the case of DB.T2.large Is this also needed as it is just dedicated MYSQL?

    you can disable the mysql server on local machine and setup as dedicated mysql server.
    0
  • cPanelMichael
    Hello, We document how to configure a cPanel server to utilize a remote MySQL server at: Manage MySQL Profiles - Version 68 Documentation - cPanel Documentation The remote MySQL server does not need to utilize cPanel. You may also find this document helpful: Troubleshoot MySQL Profiles - Version 68 Documentation - cPanel Documentation Thank you.
    0
  • toplisek
    It is an issue that only one account needs dedicated MYSQL due to extensive use of MYSQL. It is not general MYSQL and disables feature. Is this also possible?
    0
  • cPanelMichael
    It is an issue that only one account needs dedicated MYSQL due to extensive use of MYSQL. It is not general MYSQL and disables feature. Is this also possible?

    Yes, but you'd need to configure that account's script to connect to the remote MySQL server's IP address in the script's database configuration settings (e.g. config.php). Then, make sure outgoing connections over port 3306 (if that's the port utilized for MySQL on the remote server) are not disabled in your firewall. Additionally, make sure the remote MySQL server allows connections from the cPanel server's IP address: MySQL allow remote connections from multiple ip addresses Thank you.
    0
  • toplisek
    Thank you for this information.
    0

Please sign in to leave a comment.