Give my x10 account access to my DB on my computer?

[Blazer9131]

Hey guys, I have MySQL 5 installed on my computer. I can access it via localhost and all.. I forwarded ports 3306, on all my firewalls.. Now, the question is, How do I set up MySQL 5 to allow connections from my x10hosting account? Thanks guys. =D

~Blaze

 

[Brandon]

Do you have a static IP address?

 

[Blazer9131]

Umm I'm sorta confused by static and dynamic, But It does not change. I've had the same IP for over 6 months. That's as far as I can remember.

 

[Brandon]

Ok, PM me your IP address and I will add it to the firewall.

 

[Blazer9131]

Alright, I PM'd you.

Also, on the MySQL console Should I type this in:

GRANT ALL ON *.* TO root@'xxx.xxx.xxx.xxx' IDENTIFIED BY 'ROOT_PASSWORD';

Where xxx is my X10Hosting's server's IP and ROOT password is my root user's pass?

 

[Brandon]

Yes, or use 'stoli.x10hosting.com'.

Although I don't recommend on using root for regular databases.

 

[Blazer9131]

Enter password:
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 21
Server version: 5.0.45-community-nt MySQL Community Edition (GPL)

Type 'help;' or '\h' for help. Type '\c' to clear the buffer.

mysql> grant all on *.* to mangos@'stoli.x10hosting.com' identified by '<mangospasshere>';

Query OK, 0 rows affected (0.16 sec)

mysql>

That's what I get via the console. Is all that info correct? If so, I get this error message from my script:

Could not connect: Host '74.86.116.188' is not allowed to connect to this MySQL server

 

[Brandon]

Ok, try 74.86.116.188 then, host name's usually work for me though.

 

[Blazer9131]

Nice, Its working Perfectly! Thanks for all your help bro!

*loves x10hosting =P*

Btw, are there like Google Addsence codes instead of the

<script type="text/javascript" src="http://x10hosting.com/adserve.js?advanced"></script>

codes? *<.< I don't want people knowing I'm using free hosting, but I will if its 100% necessary..*