My SQL DBs

[vAcuushin]

http://studio92k.pcriot.com/register.php
If you try to go on there, I get an error:
Warning: mysql_connect() [function.mysql-connect]: Host '7x.xx.xxx.xxx' is not allowed to connect to this MySQL server in /home/xxxxx/public_html/config.php on line 9
Cant connect to the database
The config is here:

   <?php
// made by superfun
// Version 3.2
$host['naam'] = '9x.xx.xxx.xx';                // my host
$host['gebruikersnaam'] = 'root';       // my database username
$host['wachtwoord'] = '------';   // my database password
$host['databasenaam'] = 'maplestory';       // my database name

$db = mysql_connect($host['naam'], $host['gebruikersnaam'], $host['wachtwoord']) OR die ('Cant connect to the database');
mysql_select_db($host['databasenaam'], $db);
?>

It works for my buddy's server (using x10hosting as well) and he did the same thing I did..
Any ideas? :S
Here's his link:
http://nokelt.x10hosting.com/register.php

 

[Christopher]

Is the mysql server hosted on your computer?
If yes, you need to allow remote connections or the server's ip.

If you are trying to access the x10 mysql server, use localhost for host.

 

[vAcuushin]

Yes, the MySQL server is hosted on my computer.
It's just when I put my IP in the config it shows me the error with the shared IP (from the cPanel)

"If yes, you need to allow remote connections or the server's ip."
I just went to My Computer and allowed users to remotely connect to me. Same error.
I tried with the server's IP:

Warning: mysql_connect() [function.mysql-connect]: Access denied for user 'root'@'absolut.x10hosting.com' (using password: YES) in /home/xxxxx/public_html/config.php on line 9
Cant connect to the database.


I've tried again with localhost as the host, it worked, but I'd have to make a new db :S I'll try that.

 

[Brandon]

You need to add it to your MySQL Access Host list.

 

[vAcuushin]

Add what :O?
I added my IP and the Server's IP, doesn't work :[

 

[Brandon]

Please, you should look into this more, you need to add it to your MySQL server's remote access list, not ours.

 

[vAcuushin]

Can anyone explain to me how?
*noobasaur*

 

[Fedlerner]

You should try to investigate this yourself, the support section is to give support related x10hosting account problems.

Do you have a firewall? If so, you should allow the IPs: 74.86.116.187 & 74.86.133.24

 

[vAcuushin]

Thanks for the help guys, I would've searched but I didn't know what to search,
Thanks for the clues Brandon lole.

 

[Fedlerner]

Feel free to re-open this thread if you need further assistance.