Hi,

I am totally new to Mysql and even have difficulty starting the Mysql server on my pc!!!

I have downloaded the zip file needed from mysql.com and am following instructions from a book called Mysql weekend crash course by Jay Green.

It says I should use mysql_safe to start the server but I cannot find this particular file/app. anywhere.

I have windows xp home edition if that info helps? What do I need to do?

Thanks

Hello pjacks,

I don't use Windows XP, so I am not sure how it differs from starting MySQL like I do (with my Windows ME setup). I am sure it's not so different...

Before I try to help you with this, can you quickly tell me - what have you tried already (to start MySQL) and what happens?

ok.

The books tells me the most important files to start with are "mysqld and mysqld_safe (or mysqld.exe on windows) is the daemon or server engine. Before you can do anything with MySql, you need to start the server. To start the server, do not use mysqld; use mysqld_safe instead. To start the server, run the following command from the /bin directory (for DOS , omit the dot and slash)"

Also states that I should find an item in the Start menu that starts the MySql server daemon, but nothing is there.

I have looked through the files when I unzipped the download and can find others files the book refers to like mysqladmin, mysqldump , and mysqlimport but cannot find the mysqld_safe anywhere, (mysqld is there).

What have I not done wrong?

Thanks.

OK, now that's another thing we're doing differently... you have downloaded the zipped version of MySQL (i.e the version without the installer). I always download the 'installer' version. Obviously when you unzip the package, nothing gets 'installed' to your Start menu - you see what I mean?

http://dev.mysql.com/doc/mysql/en/Wi...tallation.html

On unzipping the file I had to install it by clicking on setup.exe file and I installed it onto c drive, or do you mean something else?

OK, so you're okay with the install, I think.

Now, what happens when you open up a console window (DOS) and type in the following command?


You mentioned it as an option in your post but you didn't say if it worked... and that is why I am asking. Forget the C:\mysql\bin\mysqld_safe thingy, I don't seem to have the executable inside my folder as well.

pjacks, I am going to hit the sack any minute now... so if you find no one else helping you in the meantime; I'll take a look at your reply, if any, tomorrow.

Here's some bed time reading if you missed them:

http://dev.mysql.com/doc/mysql/en/Win95_start.html
http://dev.mysql.com/doc/mysql/en/NT_start.html

This is what I get when I use C:\mysql\bin\mysqld

Microsoft Windows XP [Version 5.1.2600]
(C) Copyright 1985-2001 Microsoft Corp.

C:\>C:\mysql\bin\mysqld
Can't start server: listen() on TCP/IP port: No error
040707 20:10:07 Error: listen() on TCP/IP failed with error 10022
040707 20:10:07 Aborting

040707 20:10:07 C:\mysql\bin\mysqld: Shutdown Complete

Make any sense?

Thanks

I searched the net for the error messages in your reply just now and found nothing directly related to "starting MySQL". Most however describe a TCP/IP / WinSock error...

A few things for you to reply to:

• What if anything is inside your error logs? You can find it usually inside c:\mysql\data\host_name.err.
• Try starting the server with C:\mysql\bin\mysqld-nt.exe instead... and hope it makes a difference. see notes here.

I have just realised why I got the message before - I have Mcafee and did not allow the mysqld to access the internet (due to the book I am reading advising not to be on-line when opening mysql server ?!?! I am therefore cautious to allow access).

Am I doing this wrong - should I allow these commands acces to net or not - sorry if it sound a silly question but I am TOTALLY new to this mysql thingy !!

That's a very good question, and here's what I normally do myself. When I am on the Net (online, surfing the web like right now), my MySQL server is not running.

When I am about to start developing scripts on my PC, I get offline, i.e. closing my Internet connection and switching off the modem etc. Then I start MySQL and the Apache server. If I have ZoneAlarm running at this time, it will prompt me if I would like to allow MySQL and Apache to access the Internet, I usually submit "yes".... since I am not ACTUALLY online!

When I am done, I go through the ritual in the reverse; I shut down both, MySQL and Apache and then and only then do I connect to the Net.