I need help with database connection

[ghettoc401]

I'm trying to connect to my mysql database remotely, and I was wondering what the database host is. I've tried several variations, but it seems like none are working. Here is what i am putting into the fields:

Hostname: eoclan.pcriot.com (thats my site)
Port: 3306
username: mysql database username
password: mysql database password

I want to know what i am doing wrong, and how i can fix it because I have been working at this for some time, and i have checked all the help databases and old topics and I couldnt find anything that helps me. Any help is appreciated, Thanks in advance!

EDIT: I found some topics that are the same questions as mine, but they dont have an answer; most of them are locked = /

Also, this problem is very common, and I suggest that a tutorial should be made so that you guys wont have to anwer this problem over and over. Its just a suggestion, trying to help out

 

[t2t2t]

You have to add your IP address to the allowed connections thing in cPanel.
Screeny:

Username: The username, like "tkd_USERNAME"
Password: the database password
Host: You're domain name
Port: Leave default
Database: The database, like "tkd_DATABASE"


Hope this helps

Note: screenshot is from Cpanel10.

 

[ghettoc401]

Thank you for your quick reply. I have already added my self to the allowed connections, and it still isnt working. :happysad:

 

[t2t2t]

Does it print out any sort of error?

 

[ghettoc401]

Cant Connect to MySql server on eoclan.pcriot.com (10060)

 

[Micro]

Again, you will need to ask Corey to add your WAN (Outgoing IP) to the firewalls incoming allowed list...

If you are just using mysql maybe you could use www.freesql.org for the DB>

 

[ghettoc401]

I tried that place and everytime i tryto create a database it gives me an error saying something about creating grant / database. I want to get this working here because it will allow me to have a website to accompany the database.

I will pm corey my ip so that he can unblock it in the firewall.

 

[Corey]

Dealing with over PMs, closing this.

-Corey