当前位置: 技术问答>linux和unix
linux下mysql安装
来源: 互联网 发布时间:2015-07-31
本文导语: 我用的是源码编译方式安装的,mysql能够安装完后,不能启动服务。提示错误 040927 14:34:30 mysqld started InnoDB: Error: auto-extending data file ./ibdata1 is of a different size InnoDB: 0 pages (rounded down to MB) than specified in...
我用的是源码编译方式安装的,mysql能够安装完后,不能启动服务。提示错误
040927 14:34:30 mysqld started
InnoDB: Error: auto-extending data file ./ibdata1 is of a different size
InnoDB: 0 pages (rounded down to MB) than specified in the .cnf file:
InnoDB: initial 640 pages, max 0 (relevant if non-zero) pages!
InnoDB: Could not open or create data files.
InnoDB: If you tried to add new data files, and it failed here,
InnoDB: you should now edit innodb_data_file_path in my.cnf back
InnoDB: to what it was, and remove the new ibdata files InnoDB created
InnoDB: in this failed attempt. InnoDB only wrote those files full of
InnoDB: zeros, but did not yet use them in any way. But be careful: do not
InnoDB: remove old data files which contain your precious data!
040927 14:34:30 Can't init databases
040927 14:34:30 Aborting
040927 14:34:30 InnoDB: Warning: shutting down a not properly started
InnoDB: or created database!
040927 14:34:30 /usr/local/mysql/libexec/mysqld: Shutdown Complete
040927 14:34:30 mysqld ended
040927 14:34:30 mysqld started
InnoDB: Error: auto-extending data file ./ibdata1 is of a different size
InnoDB: 0 pages (rounded down to MB) than specified in the .cnf file:
InnoDB: initial 640 pages, max 0 (relevant if non-zero) pages!
InnoDB: Could not open or create data files.
InnoDB: If you tried to add new data files, and it failed here,
InnoDB: you should now edit innodb_data_file_path in my.cnf back
InnoDB: to what it was, and remove the new ibdata files InnoDB created
InnoDB: in this failed attempt. InnoDB only wrote those files full of
InnoDB: zeros, but did not yet use them in any way. But be careful: do not
InnoDB: remove old data files which contain your precious data!
040927 14:34:30 Can't init databases
040927 14:34:30 Aborting
040927 14:34:30 InnoDB: Warning: shutting down a not properly started
InnoDB: or created database!
040927 14:34:30 /usr/local/mysql/libexec/mysqld: Shutdown Complete
040927 14:34:30 mysqld ended
|
mysql低版本安装后不会自动启动服务的,所有要手工启动服务,然后在mysql进去
如果是4.0或以上版本应该安装完后自动启动服务器了,在命令行mysql就可以进去了,
建议用rpm方式安装,然后确定下系统mysql安装是否成功(有的系统在安装的时候已经装的有低版本的,这时的强制安装才行)
如果是4.0或以上版本应该安装完后自动启动服务器了,在命令行mysql就可以进去了,
建议用rpm方式安装,然后确定下系统mysql安装是否成功(有的系统在安装的时候已经装的有低版本的,这时的强制安装才行)
|
是用ROOT启动的吗?
#/etc/init.d/mysqld start
#/etc/init.d/mysqld start