2.1.1.3 Starting the Server for the First Time

Testing is best done from a command prompt in a console window (a ``DOS window''). This way you can have the server display status messages in the window where they are easy to see. If something is wrong with your configuration, these messages will make it easier for you to identify and fix any problems.

Make sure you are in the directory where the server is located, then enter this command:

shell> mysqld --console

For servers that include InnoDB support, you should see the following messages as the server starts up:

InnoDB: The first specified datafile c:\ibdata\ibdata1 did not exist:
InnoDB: a new database to be created!
InnoDB: Setting file c:\ibdata\ibdata1 size to 209715200
InnoDB: Database physically writes the file full: wait...
InnoDB: Log file c:\iblogs\ib_logfile0 did not exist: new to be created
InnoDB: Setting log file c:\iblogs\ib_logfile0 size to 31457280
InnoDB: Log file c:\iblogs\ib_logfile1 did not exist: new to be created
InnoDB: Setting log file c:\iblogs\ib_logfile1 size to 31457280
InnoDB: Log file c:\iblogs\ib_logfile2 did not exist: new to be created
InnoDB: Setting log file c:\iblogs\ib_logfile2 size to 31457280
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
011024 10:58:25  InnoDB: Started

When the server finishes its startup sequence, you should see something like this, which indicates that the server is ready to service client connections::

mysqld: ready for connections
Version: '4.0.14-log'  socket: ''  port: 3306

The server will continue to write to the console any further diagnostic output it produces. You can open a new console window in which to run client programs.

If you omit the --console option, the server writes diagnostic output to the error log in the data directory. The error log is the file with the `.err' extension.

For further information about running MySQL on Windows, see section 2.6.1 Windows Notes.

User Comments

Hi there

After starting mysqld --standalone --console, I get nothing displayed. The only thing that happens is that the machine I am using slows up - mouse movements are jerky. I am using Windows ME. Please can someone help.

Thanks in advance
Philip

mysql.host doesn't exist : be careful with C:\my.cnf file, there you have to specify home AND data, same as setup process folders built.
In my Win install, file C:\my.cnf says:
[mysqld]
basedir=D:/mysql/
datadir=D:/mysql/data/
so verify that setup has built data in datadir.

Alejandro

Add your own comment.