郁闷ing----mysql启动失败
刚刚安装的mysql 4.1.14
#service mysql start
Starting MySQL................................... [失败]
察看日志,如下:
020130 23:33:49 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 data files
020130 23:33:49 Can't init databases
020130 23:33:49 Aborting
020130 23:33:49 InnoDB: Warning: shutting down a not properly started
InnoDB: or created database!
020130 23:33:49 /usr/sbin/mysqld-max: Shutdown complete
020130 23:33:49 mysqld ended
高手指点,谢了!!!
如果你对这篇内容有疑问,欢迎到本站社区发帖提问 参与讨论,获取更多帮助,或者扫码二维码加入 Web 技术交流群。
绑定邮箱获取回复消息
由于您还没有绑定你的真实邮箱,如果其他用户或者作者回复了您的评论,将不能在第一时间通知您!
发布评论
评论(7)
没有初始化数据库,看INSTALL文件
楼上的能否说的清楚一些,谢了!
/usr/bin/mysql_install_db
[quote]原帖由 "shadowmin"]/usr/bin/mysql_install_db[/quote 发表:
[root@shdb root]# /usr/bin/mysql_install_db
WARNING: The host 'shdb' could not be looked up with resolveip.
This probably means that your libc libraries are not 100 % compatible
with this binary MySQL version. The MySQL daemon, mysqld, should work
normally with the exception that host name resolving will not work.
This means that you should use IP addresses instead of hostnames
when specifying MySQL privileges !
Installing all prepared tables
Fill help tables
To start mysqld at boot time you have to copy support-files/mysql.server
to the right place for your system
PLEASE REMEMBER TO SET A PASSWORD FOR THE MySQL root USER !
To do so, start the server, then issue the following commands:
/usr/bin/mysqladmin -u root password 'new-password'
/usr/bin/mysqladmin -u root -h shdb password 'new-password'
See the manual for more instructions.
NOTE: If you are upgrading from a MySQL <= 3.22.10 you should run
the /usr/bin/mysql_fix_privilege_tables. Otherwise you will not be
able to use the new GRANT command!
You can start the MySQL daemon with:
cd / ; /usr/bin/mysqld_safe &
You can test the MySQL daemon with the benchmarks in the 'sql-bench' directory:
cd sql-bench ; perl run-all-tests
Please report any problems with the /usr/bin/mysqlbug script!
The latest information about MySQL is available on the web at
http://www.mysql.com
Support MySQL by buying support/licenses at https://order.mysql.com
这没什么问题吧?
你把你的shdb加到/etc/hosts里面就好了,其它都是他的说明
数据库没有初始