Can't connect

[damagician]

Hello All,

I've started a website to let my family and friends keep track of me and my girlfriend while travelling http://www.globetrotterz.com . I'm sure you all understand how hard it is to learn anything about web design as there is just so much choice and no 2 people will recommend the same thing

I've been using Dreamweaver and updating via FTP. I would now like to take the next step and get into Dynamic Content. I've currently installed Coldfusion on JRun4 and also MYSQL with SQLyog.

I cannot however seem to create a database or even connect to my localhost. Can anyone help me out here?

When I startup SQLyog it gives me some options in order to connect to a database such as connection name, host, password etc.. I'm not sure if I should have already set up the database through MySQL before using SQLyog, or if I create the database with SQLyog.

The Error I am getting is:

Error No. 2003

Can't connect to MySQL server on 'Localhost' (10061)

I have read another comment on a similar problem and have turned off auto protect on my Antivirus: Norton 2005.

Any help here would be greatly appreciated.

[peterlaursen]

this message:

Quote:

Can't connect to MySQL server on 'Localhost' (10061)

is not a user/pw problem. It occurs even before that.

I understand that you have installed MySQL on yor localhost. Are you sure that the MySQL server is running ? The err msg is the one you get when it is not!

Is there a Mysql*****.exe proces to see in taskmanager ?

Did you get the “MySQL Administrator” program from MySQl. It places an icon in system tray from where to manage MySQL.

If you have a Firewall Aplication then try disabling it! AV should not affect connectivity.

Is the SQLyog the free version or enterprise version? It your ISP has blocked the MySQL port you will need to use tunnelling to connect. Tunnelling is included with the Enterprise version only. And most likely the ISP won't let you manage users from no other application than their own Control Panel application

Let's start here. All other issues with other software is not relevant at this point!

Quote:

I'm not sure if I should have already set up the database through MySQL before using SQLyog

After initial install of MySQL you can connect as user “ROOT” with NO PASSWORD from LOCALHOST ONLY (standard port is 3306)!

[damagician]

Thanks for the speedy reply. I'm not actually at my own computer at the moment but I've noted your advice and will check it out ASP.

Let you know how I get on tomorrow 🙂 Thanks

[damagician]

I don't know how I managade it but I am now able to connect to my local host. It may be because of the firewall or maybe something else, net sure.

At least I can now get into the program and have a look around.

Thanks for all the help 😀

[Author]

Posts