How to connect to my database online?

Lauj

Sorry if my topic is not appropriate for this forum.

I'm trying to use EMS MySQL Manager Pro to connect to my website's MySQL database. So far it is unsucessful. I wonder if anyone can help me.

I currently use phpMyAdmin 2.6 to connect to my database. I also can use Macromedia MX 2004 to connect to my database. But somehow I couldn't use EMS MySQL Manager to connect to my database. Any help is greatly appreciated.

ljCharlie

bradgrafelman

Macromedia can connect to MySQL servers? Interesting; never used that feature before.

I would say check and re-check all your settings. With the exception of your password, you could try posting your configuration in Macromedia for us to look at.. maybe there's an obvious error you're not catching?

Lauj

This is the settings I used in Dreamweaver to connect to my database...however, I'm not sure what I'm talking about is the same as what you're thinking off.

Below are my settings.

$hostname_LorResident = "localhost";
$database_LorResident = "myDatabase";
$username_LorResident = "myuserName";
$password_LorResident = "myPassword";

ljCharlie

bradgrafelman

Well, I'm assuming you then connect to MySQL via:

$link = mysql_connect($hostname_LorResident, $username_LorResident, $password_LorResident);

mysql_select_db($database_LorResident);

right? If that isn't working, I'd say you have to contact your host to figure out what your MySQL login credentials are.

Lauj

Yes, that works in Dreamweaver. I have no problem connecting from dreamweaver. What I'm talking about about is using EMS MySQL Manager 3 Pro to manage connect to MySQL online on my website. Does anyone know if EMS MySQL Manager 3 Pro can be used to manage website MySQL database?

ljCharlie