4 messages in com.mysql.lists.win32Win32 Install Problems| From | Sent On | Attachments |
|---|---|---|
| Masood Ahmed | 11 Jun 2003 20:42 | |
| David M Friscia | 12 Jun 2003 10:59 | |
| Public Folder: MySQL | 12 Jun 2003 11:22 | |
| Masood Ahmed | 12 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




