MySQL Installation of system tables failed!

最新推荐文章于 2021-05-14 00:18:54 发布

原创最新推荐文章于 2021-05-14 00:18:54 发布 · 6.4k 阅读

0 ·

CC 4.0 BY-SA版权

文章标签：

#system #mysql #redhat #manager #command #cmd

Linux RedHat 专栏收录该内容

9 篇文章

订阅专栏

在Linux初学者尝试在RedHat系统中安装MySQL时遇到问题，安装过程中提示system tables安装失败，错误涉及到mysqld的退出和管道问题。建议检查日志、启动mysqld守护进程，并使用mysql命令行工具连接到mysql数据库查看grant tables，或者查阅相关手册和在线资源寻求解决方案。

刚开始学习Linux，就遇到了问题。

当在RedHat下安装MySQL时提示如下错误，请高手给点指点，谢谢：

rpm -vih MySQL-server-community-5.0.96-1.rhel5.i386.rpm --nodeps --force

warning: MySQL-server-community-5.0.96-1.rhel5.i386.rpm: V3 DSA signature: NOKEY, key ID 5072e1f5
Preparing...                ########################################### [100%]
Giving mysqld 5 seconds to exit nicely
   1:MySQL-server-community ########################################### [100%]
/usr/bin/mysql_install_db: line 1: 13446    断开的管道             cat
/usr/bin/mysql_install_db: line 433: 13444 断开的管道            cat $create_system_tables $fill_system_tables
/usr/bin/mysql_install_db: line 433: 13443 Done(141)               { echo "use mysql;"; cat $create_system_tables $fill_system_tables; }
     13445                       | eval "$filter_cmd_line"
     13447   浮点数例外 | $mysqld_install_cmd_line >/dev/null
Installation of system tables failed!

Examine the logs in /var/lib/mysql for more information.
You can try to start the mysqld daemon with:
/usr/sbin/mysqld --skip-grant &
and use the command line tool
/usr/bin/mysql to connect to the mysql
database and look at the grant tables:

shell> /usr/bin/mysql -u root mysql
mysql> show tables

Try 'mysqld --help' if you have problems with paths. Using --log
gives you a log in /var/lib/mysql that may be helpful.

The latest information about MySQL is available on the web at
http://www.mysql.com
Please consult the MySQL manual section: 'Problems running mysql_install_db',
and the manual section that describes problems on your OS.
Another information source is the MySQL email archive.
Please check all of the above before mailing us!
And if you do mail us, you MUST use the /usr/bin/mysqlbug script!
Starting MySQL. ERROR! Manager of pid-file quit without updating file.
Giving mysqld 2 seconds to start