Checking mySQL privileges
Again, just to show my lack of mySQL knowledge, I'm posting on what "should" be simple - checking why you can't access mySQL from a remote host.
First off, establish a session from the localhost using the mySQL command line (it's typically in the install directory)- the syntax is normally along the lines of:
mysql -u root -p
then check your user list and access IP's with the command
select User,Host from mysql.user;
Then, if, like me, you find you lack permissions, you can grant them, with the command:
GRANT ALL PRIVILEGES ON *.* TO USERNAME@IP IDENTIFIED BY "PASSWORD";
where Username is your desired username, ip is your connecting host IP, and Password is the desired password for your user. You may then want to run
FLUSH PRIVILEGES;
to apply the settings- then give it a go!