Topic: Instant Rails MySql error

I just downloaded Instant Rails (Win XP) and when I launch it, after around five seconds, I get the following error:

Unexpected end of MySql...see log file?

When I look at the log file, here is what I see:

InnoDB: The first specified data file .\ibdata1 did not exist:
InnoDB: a new database to be created!
070413 22:05:05  InnoDB: Setting file .\ibdata1 size to 10 MB
InnoDB: Database physically writes the file full: wait...
070413 22:05:06  InnoDB: Log file .\ib_logfile0 did not exist: new to be created
InnoDB: Setting log file .\ib_logfile0 size to 5 MB
InnoDB: Database physically writes the file full: wait...
070413 22:05:07  InnoDB: Log file .\ib_logfile1 did not exist: new to be created
InnoDB: Setting log file .\ib_logfile1 size to 5 MB
InnoDB: Database physically writes the file full: wait...
InnoDB: Doublewrite buffer not found: creating new
InnoDB: Doublewrite buffer created
InnoDB: Creating foreign key constraint system tables
InnoDB: Foreign key constraint system tables created
070413 22:05:07  InnoDB: Started; log sequence number 0 0
Can't start server: Bind on TCP/IP port: No such file or directory
070413 22:05:07 [ERROR] Do you already have another mysqld server running on port: 3306 ?
070413 22:05:07 [ERROR] Aborting

070413 22:05:07  InnoDB: Starting shutdown...
070413 22:05:09  InnoDB: Shutdown completed; log sequence number 0 43655
070413 22:05:09 [Note] C:\INSTAN~1\MySql\bin\mysqld.exe: Shutdown complete

070413 22:05:11  InnoDB: Started; log sequence number 0 43655
Can't start server: Bind on TCP/IP port: No such file or directory
070413 22:05:11 [ERROR] Do you already have another mysqld server running on port: 3306 ?
070413 22:05:11 [ERROR] Aborting

070413 22:05:11  InnoDB: Starting shutdown...
070413 22:05:13  InnoDB: Shutdown completed; log sequence number 0 43655
070413 22:05:13 [Note] C:\INSTAN~1\MySql\bin\mysqld.exe: Shutdown complete

070413 22:06:32  InnoDB: Started; log sequence number 0 43655
Can't start server: Bind on TCP/IP port: No such file or directory
070413 22:06:32 [ERROR] Do you already have another mysqld server running on port: 3306 ?
070413 22:06:32 [ERROR] Aborting

070413 22:06:32  InnoDB: Starting shutdown...
070413 22:06:34  InnoDB: Shutdown completed; log sequence number 0 43655
070413 22:06:34 [Note] C:\INSTAN~1\MySql\bin\mysqld.exe: Shutdown complete

070413 22:10:38  InnoDB: Started; log sequence number 0 43655
Can't start server: Bind on TCP/IP port: No such file or directory
070413 22:10:38 [ERROR] Do you already have another mysqld server running on port: 3306 ?
070413 22:10:38 [ERROR] Aborting

070413 22:10:38  InnoDB: Starting shutdown...
070413 22:10:40  InnoDB: Shutdown completed; log sequence number 0 43655
070413 22:10:40 [Note] C:\INSTAN~1\MySql\bin\mysqld.exe: Shutdown complete

070413 22:16:46  InnoDB: Started; log sequence number 0 43655
Can't start server: Bind on TCP/IP port: No such file or directory
070413 22:16:46 [ERROR] Do you already have another mysqld server running on port: 3306 ?
070413 22:16:46 [ERROR] Aborting

070413 22:16:46  InnoDB: Starting shutdown...
070413 22:16:48  InnoDB: Shutdown completed; log sequence number 0 43655
070413 22:16:48 [Note] C:\INSTAN~1\MySql\bin\mysqld.exe: Shutdown complete

070413 22:25:47  InnoDB: Started; log sequence number 0 43655
Can't start server: Bind on TCP/IP port: No such file or directory
070413 22:25:47 [ERROR] Do you already have another mysqld server running on port: 3306 ?
070413 22:25:47 [ERROR] Aborting

070413 22:25:47  InnoDB: Starting shutdown...
070413 22:25:49  InnoDB: Shutdown completed; log sequence number 0 43655
070413 22:25:49 [Note] C:\INSTAN~1\MySql\bin\mysqld.exe: Shutdown complete

I don't have another mysqld server running on port: 3306, as far as I know.

Any suggestions for figuring out what is conflicting here, or how to solve this?

Re: Instant Rails MySql error

Can't start server: Bind on TCP/IP port: No such file or directory
070413 22:05:07 [ERROR] Do you already have another mysqld server running on port: 3306 ?

Do you have another server running on port 3306? Stop other servers running.

Re: Instant Rails MySql error

I am not aware of any other server running on port 3306. Is there an easy way for me to check? (Sorry...I'm still rather new to server administration).

-David

Re: Instant Rails MySql error

netstat -a

from shell or command prompt

Last edited by shadow (2007-04-14 13:16:02)

Re: Instant Rails MySql error

Great! Thanks shadow...that did the trick. I discovered that a download manager for Audible.com was using the same port. When I stopped it, Instant Rails loaded without a hitch.

Now I have another question, however...

How do I access MySQL on an XP machine? On the Mac, I just open up the Terminal program, and type "MySQL". I opened up the Command Prompt in XP, and typed mysql, but got the error message "mysql is not recognized as an internal or external command, operable program or batch file."

According to Instant Rails, MySQL is running fine now. How do I access it?

-David

Re: Instant Rails MySql error

If Instant Rails has added mysql's bin folder to your system path, reboot and it should work.

Otherwise, you need to enter the MySQL bin folder before entering the command.

Re: Instant Rails MySql error

I started the "Online Cookbook" tutorial, and found the command:
mysql -u root -p

This did the trick!

Thanks for all your help!