Hello gnyiryudan,
in 000webhost, as I know and as I remembered, they are not giving us the opportunity to do a remote-access to the MySQL database, if you take the free package.
If you would like to have the SQL database remote access, you will have to spend some money.
Have a nice day!
Hello gnyiryudan,
Sorry for reading the wrong error message.
Grant the ragnarok tables by doing this:
Open your MySQL Workbench
connect to your server via the Server administration (the right one)
Click on the "Users and Privileges", under the "security", on the left pane
click Add account,
put 'root' on the Login Name box.
you can put 'srv20.000webhost.com' or '%' on the "Limit Connectivity to Hosts Matching:" box. Note that '%' means every host.
put your password on the Password box and the Confirm password box.
Then, click on "Apply".
Move to the second tab, "Schema Privileges"
click on the user that you wish to grant the privilege, either root or ragnarok, according to which do you use.
click on the "Add entry" button, located on the right side of the window.
Now, you do understand which you should choose, to grant Any Host from 'username' or a selected host: "srv20.000webhost.com". and on the schema, I suggest you to take "selected schema", with selecting: log, cp, ragnarok. Otherwise, considering the username is root, therefore Any Schema would be likely to be chosen.
Click OK and click on the "Save Changes".
Refresh your Flux CP and see whether it is working or not. if not, restart your MySQL server.
Have a nice day!