+ Reply to Thread
Results 1 to 9 of 9

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

  1. #1
    Blazer9131 is offline x10 Lieutenant Blazer9131 is an unknown quantity at this point
    Join Date
    Oct 2007
    Posts
    411

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

    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

  2. #2
    Brandon's Avatar
    Brandon is offline Former Senior Account Rep Brandon is on a distinguished road
    Join Date
    Jun 2006
    Location
    Tewksbury, MA
    Posts
    9,589

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

    Do you have a static IP address?
    Thanks,
    Brandon Long

  3. #3
    Blazer9131 is offline x10 Lieutenant Blazer9131 is an unknown quantity at this point
    Join Date
    Oct 2007
    Posts
    411

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

    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.

  4. #4
    Brandon's Avatar
    Brandon is offline Former Senior Account Rep Brandon is on a distinguished road
    Join Date
    Jun 2006
    Location
    Tewksbury, MA
    Posts
    9,589

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

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

  5. #5
    Blazer9131 is offline x10 Lieutenant Blazer9131 is an unknown quantity at this point
    Join Date
    Oct 2007
    Posts
    411

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

    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?

  6. #6
    Brandon's Avatar
    Brandon is offline Former Senior Account Rep Brandon is on a distinguished road
    Join Date
    Jun 2006
    Location
    Tewksbury, MA
    Posts
    9,589

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

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

    Although I don't recommend on using root for regular databases.
    Last edited by Brandon; 11-07-2007 at 08:14 PM.
    Thanks,
    Brandon Long

  7. #7
    Blazer9131 is offline x10 Lieutenant Blazer9131 is an unknown quantity at this point
    Join Date
    Oct 2007
    Posts
    411

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

    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
    Last edited by Blazer9131; 11-07-2007 at 08:21 PM.

  8. #8
    Brandon's Avatar
    Brandon is offline Former Senior Account Rep Brandon is on a distinguished road
    Join Date
    Jun 2006
    Location
    Tewksbury, MA
    Posts
    9,589

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

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

  9. #9
    Blazer9131 is offline x10 Lieutenant Blazer9131 is an unknown quantity at this point
    Join Date
    Oct 2007
    Posts
    411

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

    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..*
    Last edited by Blazer9131; 11-07-2007 at 08:39 PM.

+ Reply to Thread

Similar Threads

  1. Cant access my website or account.
    By mentalinc in forum Free Hosting
    Replies: 10
    Last Post: 10-18-2007, 10:38 PM
  2. Cannot access account management
    By slaiyer in forum Free Hosting
    Replies: 1
    Last Post: 09-12-2007, 11:12 AM
  3. cant access my account
    By carlosdajer in forum Free Hosting
    Replies: 1
    Last Post: 04-22-2007, 05:30 PM
  4. account created but no access?
    By entc401 in forum Free Hosting
    Replies: 3
    Last Post: 03-13-2005, 09:53 AM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
x10hosting free hosting for the masses
dedicated servers