PDA

View Full Version : Connecting to MySQL


matthewm
06-18-2006, 01:35 PM
Hi, I'm trying to connect to my MySQL database using a program called SQLyog. I'm having trouble connecting to the server though... I may be putting the connection information in wrong, as I keep getting an error that says "Lost connection to MySQL server during query," but I thought I had everything correct. Can someone tell me what information I need to connect to my MySQL databases with a 3rd party GUI?

Thanks

Dyjital
06-18-2006, 09:26 PM
It may be useful to post the information that you entered.

though blocking out the obvious site name if you choose, username/ pass etc.


To ensure that we are all on the same wavelength

matthewm
06-18-2006, 09:40 PM
No problem.

MySQL Host Address: my website
Username: my username
Password: my password
Port: 2082

I'm not actually sure if that's the right address & port to use, but I don't know what other site I'd connect with, and that's the only port that I ever see when connecting to my site though cPanel. I'm assuming I need to connect with my cPanel username and password also.

Attempting to connect takes a while before I finally get an error message, so I'm assuming at least something is working... if I type in a different address I get an error almost instantly. I've never used anything but PHPMyAdmin though, so I'm not sure what I need to enter to connect through another program.