How do I configure a MySQL database that is on my machine to be accessed in moodle hosted on the web?

0

I hired hosting services from Uol Host, however I can not change the database provided by them. I would like to know how do I connect a database from my machine to moodle that is installed on the host. In the moodle installation this appears.

MySQL Workbench just installed.

Thanks in advance.

    
asked by anonymous 09.03.2018 / 22:09

1 answer

0

First you will need a Static IP or Dynamic DNS to access your site, and you will also need your IP ports to be free from your ISP, without this you can not remotely connect to your ISP. host

  • You can check which your ip here

    You can check if the ports are open at your server here

    You will need to free the ports on your router / model see how in some totorial here

  • If everything is ok

  • In your Host Database you will enter your example ip 200.133.56.23 (what appears to you on myip.com.br site)

    Database Enter the name of your bank

    user and passwords (by default is user> root and the white password) case have another user and password type them

    Table prefix is optional

    Database port is usually 3306 but if you have changed specify the one you use

    Unix Socket left blank

  • 09.03.2018 / 22:18