Can anyone remember the very basics?

[Old Dog]

Hi All

I am very new to the use of MySql and have never used Yog before. My new role requires me to look at using MySql so I have downloaded and with help from a SAMS book started to use MySql quiet easily.

However I have no wbeen asked to try and make it more attractive to look at, hence the use of Yog.

I have installed MySql onto a desktop machine acting as the DB server, I have installed Yog onto the same machine. When working directly from the DB server I can start using MySql with 'osql -E' etc but fail to get a connection with the Yog startup. I have tried both 'Local host' and the Machines hostname but to no effect.

If anyone out there has the time and patience to help out an Old Dog learning new tricks I would be grateful, if not I will remain in the dark for eternity…..

[Ritesh]

What is the error message that you are getting?

[peterlaursen]

It is “localhost” not “local host” (no space).

What do you mean with “hostname”. Windows network name won't work!

You can also use your ip.

[Old Dog]

Hi

Yes I am using windows 2K client, MySql Server is installed onto the machine and SQL Server is running. When I try to connect to it using the 'connect to MySql host pop up' I have tried putting in the IP address, I have tried 'localhost' and before I even tried the machines local name (IMPORT4).

Please note that the machine running the MySql and Yog are the same machine, so I suspect it could be a port issue?

Thanks for your quick responses chaps.

Old Dog

[Old Dog]

Oh sorry I forgot to say the error message is always 'error 2003 (or 2005)

Can't connect to MySQL server on 'ipaddress' or 'localhost' or machine logical name as in windows name (I wont try that anymore as Peter has pointed out that it can't use this name.

[peterlaursen]

this should be all you'll need to input.

You can check the my.ini file to see which port is used by MySQL, but I don't see why it is not 3306.

It could be a firewall issue. Some firewalls block connections with TCP even to localhost

[peterlaursen]

Quote:

so I have downloaded and with help from a SAMS book started to use MySql

Most books on MySQL are outdated. With the new installer for Windows and the “MySQL System Tray Monitor” installed with “MySQL Administrator” and preconfigured command line tool accessible directly from startmenu most of the “exercises” described in various books to get MySQL running are not necessary ….

What is your MySQL version? Did you get it from dev.mysql.com ? There are som obscure builds available on the internet 🙁

[Old Dog]

Many thanks Peter and Ritesh. I have re-installed SqlYog and now it does work just as you said it does. I can only think that maybe I typed in an obscure pw or something. Well that bit is now working so once again many thanks for your help.

The Sql version I have is 4.1.12, the book does also explain that MySql can be opened directly from the start menu, I now open it this way and think the reference to use osql -E was for the msde version?

I suspect it will not be too long before I am asking another dumb question, so thanks in anticipation.

Old Dog

[peterlaursen]

Quote:

maybe I typed in an obscure pw

yes maybe … if you tried to use the name of your Windows' user account, then you can't connect! MySQL does not use the Windows' user management – it operates its own user accounts. That's a common misunderstanding with new MySQL users …

[Author]

Posts