MSYQL中系统找不到指定的路径的解决方法

系统找不到指定的路径。

    这是由于上次卸载软件后服务中还有mysql服务,所以安装前看看服务中还有没有mysql,有的话先mysqld-nt --remove ，中国自学编程网整理发布，www.zzzj.com . 　　　

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>