im1hunt

Hi rob, when you are connecting, are you using an IP address or are you using localhost, when you are running it locally localhost works best. Just thought Id mention that cos when I set up phpmyadmin I had that same error message you are getting, then I changed the IP address to localhost and it went away. Just a thought

Ok, I am using phpmyadmin to create my MySQL data base and it is all working properly. I have normalised the data in my table and have all the feilds set up but I am unsure as to how I create the relationships butween the tables in my db. I know that in microsoft access all you do is open a window with the tables and drag the mouse over the fields you want to join, but I dont know how to do it in MySQL. can anyone tell me?