MySQL Remote Connection

[eouw0o83hf]

I know this is a total noob question, but I'm new to bluehost and fairly new to MySQL (but not to databases/web development in general); I can't seem to get connected to the server from my computer.

I have created a database and added a user for it with necessary permissions; I need some help with the server host to connect to. Now I'm using MySQL Query Browser 1.2.15 with following connection info:

Server Host: mydomainname.com
Port: 3306
Username: database_username
Password: password
Default Schema: database

Is there something obvious I'm missing here? I went over the documentation provided by bluehost and couldn't find anything helpful in connecting to the database server. Am I going about this in completely the wrong way?

Thanks for any help!

~Nathan

[felgall]

Unless you are trying to access the database remotely the host name should be localhost

If you are trying to access it remotely you need to whitelist the IP address you are accessing it from.

You will also need to specify the name of the database you are trying to connect to which will have the same account name prefix as the username does. Note that prefix is the accountname of your account and nothing to do with the database.

[eouw0o83hf]

Unless you are trying to access the database remotely the host name should be localhost

I'm trying to access the database on bluehost from my computer at home...so, remotely.

If you are trying to access it remotely you need to whitelist the IP address you are accessing it from.

Okay.

You will also need to specify the name of the database you are trying to connect to which will have the same account name prefix as the username does. Note that prefix is the accountname of your account and nothing to do with the database.

Yeah, I actually did have account_username as my user; I failed to type that in here correctly.

Also, is it correct to be trying to connect to mydomain.com, or is there a different server host I should be trying to connect to? Thanks!

[eouw0o83hf]

I actually ended up figuring it out. For what it's worth / future people with the same problem, I had to connect to mydomain.com to get to the database, after whitelisting my IP (as per felgall's suggestion). Thanks for the help!