重装MYSQL后启动故障调试

Microsoft Windows XP [版本 5.1.2600]
(C) 版权所有 1985-2001 Microsoft Corp.

C:\Documents and Settings\sunshine>cd c:\mysql\bin

C:\mysql\bin>mysql -u root -p
Enter password:
ERROR 2003: Can't connect to MySQL server on 'localhost' (10061)

C:\mysql\bin>mysql -u root -p0000
ERROR 2003: Can't connect to MySQL server on 'localhost' (10061)

C:\mysql\bin>mysqld-nt

C:\mysql\bin>mysql -u root -p
Enter password: ****
ERROR 2003: Can't connect to MySQL server on 'localhost' (10061)

C:\mysql\bin>mysql -help
ERROR 2005: Unknown MySQL Server Host 'elp' (11001)

C:\mysql\bin>mysqld

C:\mysql\bin>mysql -u root -p
Enter password:
ERROR 2003: Can't connect to MySQL server on 'localhost' (10061)

C:\mysql\bin>net start mysql
发生系统错误 3。

系统找不到指定的路径。


C:\mysql\bin>mysqlshow
mysqlshow: Can't connect to MySQL server on 'localhost' (10061)

C:\mysql\bin>mysqld-nt -install
The service already exists!
The current server installed:

C:\mysql\bin>mysqld-nt -remove
Service successfully removed.

C:\mysql\bin>mysqld -install
Service successfully installed.

C:\mysql\bin>mysqld

C:\mysql\bin>mysqld --console
InnoDB: The first specified data file .\ibdata1 did not exist:
InnoDB: a new database to be created!
040712 18:19:27 InnoDB: Setting file .\ibdata1 size to 10 MB
InnoDB: Database physically writes the file full: wait...
040712 18:19:27 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...
040712 18:19:28 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
040712 18:19:34 InnoDB: Started
mysqld: ready for connections.
Version: '4.0.20a-debug' socket: '' port: 3306


C:\mysql\bin>mysqld --skip-name-resolve
-

Microsoft Windows XP [版本 5.1.2600]
(C) 版权所有 1985-2001 Microsoft Corp.

C:\Documents and Settings\sunshine>cd c:\mysql\bin

C:\mysql\bin>mysqld

C:\mysql\bin>mysql
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 1 to server version: 4.0.20a-debug

Type 'help;' or '\h' for help. Type '\c' to clear the buffer.

mysql>