郁闷ing----mysql启动失败

发布于 2022-10-03 19:57:15 字数 916 浏览 17 评论 0

刚刚安装的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 技术交流群。

扫码二维码加入Web技术交流群

发布评论

需要 登录 才能够评论, 你可以免费 注册 一个本站的账号。

评论(7

女皇必胜 2022-10-10 19:57:15

没有初始化数据库,看INSTALL文件

淡忘如思 2022-10-10 19:57:15

楼上的能否说的清楚一些,谢了!

梦忆晨望 2022-10-10 19:57:15

/usr/bin/mysql_install_db

偏爱自由 2022-10-10 19:57:15

[quote]原帖由 "shadowmin"]/usr/bin/mysql_install_db[/quote 发表:
    

海之角 2022-10-10 19:57:15

[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

清风无影 2022-10-10 19:57:15

这没什么问题吧?
你把你的shdb加到/etc/hosts里面就好了,其它都是他的说明

贵在坚持 2022-10-10 19:57:15

数据库没有初始

~没有更多了~
我们使用 Cookies 和其他技术来定制您的体验包括您的登录状态等。通过阅读我们的 隐私政策 了解更多相关信息。 单击 接受 或继续使用网站,即表示您同意使用 Cookies 和您的相关数据。
原文