General Mysql Database question

Question

I have been having the hardest time for the last couple of months to really grasp mysql. Everytime no matter what the framework, programming language, computers (pc's), I have had no luck.

My question is this, is there some functionality in mysql preventing the database crud operations from being run on a different domain name? Could it be my firewall settings? I even have a hard time connecting to local databases. Look at my past questions to see what I mean. Is it at all easier to use mysql on a mac / linux?

Answer 1

I'll take the question and break it into parts.

1.) is there some functionality in mysql preventing the database crud operations from being run on a different domain name?
1a.) Don't know what you really mean. Are you trying to ask if it's possible to yank out the actual "data" in the database and store it on one server, and have another server perform crud on it?

2.)Could it be my firewall settings?
2a.) Could always be firewall settings. if you're having trouble connecting, double check them, but often times it is simply the case that you haven't enabled a user to connect remotely. See this guide for step-by-step: http://help.hardhathosting.com/question.php/87

3.)Is it at all easier to use mysql on a mac / linux?
3a.) If you're used to a linux environment, i'd say yes. If you're a pure windows guy, then it'll probably be easier in the short-to-mid term to stay on windows. But Linux is fun once you know it :-)