Using Toad to connect to SQL database

[skwiecinski]

Has anyone used Toad (or another 2nd/3rd party program) to connect to their SQL database(s) on their server space?

I followed the instructions, and I am putting in the right hostname and username (at least I think so). Of course, before I continue to try I figure I would ask if anyone has had any luck with using a program to manage their SQL databases.

Thanks.

[EricJ]

Did you whitelist your ip address from the cPanel? This has to be done before the server will let you to connect. Support will do it for you if you want.

One thing you also may want to check is if your computer has access to port 3306, as that is what is used for remote mysql administration.

[skwiecinski]

Yes, whitelisted my IP address. I am pretty sure my port is open, going to double check now.

I am guessing I am accessing SQL server. My server name should be my server, without www. Also my login and password should be my main password, or should that be a database admin username/password.

[felgall]

Also my login and password should be my main password, or should that be a database admin username/password.

Ones the database knows about.

[skwiecinski]

Thank you, I will try that out. Haven't had much luck, yet...

[Psiuyo]

skwiecinski, make sure you remember to preface your db and mysql user with your bluehost account name (as shown on the mysql cpanel page). I know I forgot to put this in the first time...