Opening Connection to MySQL Database from VBA (Excel)

[jordan elphick]

Hi Guys,

I'm trying to connect to my Database using the following code found on the net.

Server=myServerAddress;Database=myDataBase;Uid=myUsername;Pwd=myPassword;

As mentioned in the title of this topic I am using MySQL. If someone who is familiar with MySQL could please help me by telling me where to find 'myServerAddress' and 'myDataBase' within MySQL.

I am getting confused with the terminology as VBA and MySQL use different terminology for these. Is 'myDataBase' the name of the EER Model, and is 'myServerAddress' simply 'localhost' for a server running from the same machine as VBA?

Regards
Jordan