Okay, I've got a problem. I have been working on a website for a Muslim school (for volunteer hours) and I want to make the site use a content management type of thingy so that they don't mess with HTML. Turns out, their hosting plan did not come with a MySQL database, so I attempt to connect to my MySQL database that came with my AiiroDesign hosting. It didn't work. I get (actual URL is different, did that for safety):

said
Host 'soandso.soandso.com' is not allowed to connect to this MySQL server

How do I solve this problem, and if I can't what can my host do (in his control panel)?
______________________________

Linux | Chrome | Python | Chuck

It's a mysql permission setting. The user you're connecting as needs to have privileges to connect from that domain.

You should be able to resolve this by adding a MySQL user with privileges for connecting from the school's server. In MySQL, granting this privilege can be done through a query (if you have the GRANT privilege, dunno if your aiirodesign hosting lets you have it, probably does).



Where 192.168.0.1 is replaced with the school server's IP address. If you don't know the IP, you can use the domain name instead - the IP will be looked up based on that.

I get this:

Error said
Error
SQL query:

GRANT ALL PRIVILEGES ON * . * TO username@ "cityofknowledge.com" IDENTIFIED BY "password"

MySQL said:

#1045 - Access denied for user 'aiiro_pikachu'@'67.205.0.0/255.255.192.0' (using password: YES)

Does this mean I don't have the permission to grant?
______________________________

Linux | Chrome | Python | Chuck