4 messages in com.mysql.lists.win32Win32 Install Problems
FromSent OnAttachments
Masood Ahmed11 Jun 2003 20:42 
David M Friscia12 Jun 2003 10:59 
Public Folder: MySQL12 Jun 2003 11:22 
Masood Ahmed12 Jun 2003 20:43 
Subject:Win32 Install Problems
From:Masood Ahmed (maso@attbi.com)
Date:06/11/2003 08:42:31 PM
List:com.mysql.lists.win32

Hi,

I am having a hard time trying to install mySQL 4.0.13 on a W2K Server and Pro machine.

According to the instructions:

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

C:\mysql\bin> mysqld --standalone 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

I never see anything after entering the mysqld --standalone command. In fact, I have to end the process with Task Manager for the DOS prompt to re-appear. I have tried this on W2K Server and Pro.

On the Server machine I was able to get

C:\mysql\bin\mysqlshow

To respond but on the PRO machine it could not connect to the server.

Also, after doing the following:

C:\> C:\mysql\bin\mysql mysql mysql> DELETE FROM user WHERE Host='localhost' AND User=''; mysql> QUIT C:\> C:\mysql\bin\mysqladmin reload C:\> C:\mysql\bin\mysqladmin -u root password your_password After you've set the password, if you want to take down the mysqld server, you can do so using this command:

C:\> mysqladmin --user=root --password=your_password shutdown

I could not login as root.

Finally, I could not create any new DB's with WinmySQLadmin.

Someone please help, Masood