mysql安装时常出现的问题

 mysql安装时常出现的问题

在本地计算机 无法启动mysql服务错误 1067: 进程意外终止

这个问题一般是配置文件my.ini的问题,我们一般安装版的默认就行,如果是noinstall的就应该配置my.ini,一般把mysql目录下的my_*.ini任何一个文件改为my.ini就行,且放到当 前目录下面, mysqld-nt --install net start mysql 就ok了,如果还有问题就在my.ini里找问题,肯定是这的问题

重装MySQL后的第一次操作一般会出现的问题:发生系统错误 3。

系统找不到指定的路径。

这是由于上次卸载软件后服务中还有mysql服务,所以安装前看看服务中还有没有mysql,有的话先mysqld-nt --remove

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>