本文最后更新于 2020 年 3 月 13 日,文章已超过 6 个月!内容可能已失效,请自行测试 ~

1、无法以root用户启动
2020-03-09T18:13:03.569389Z 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details).
2020-03-09T18:13:03.569451Z 0 [Note] ./mysqld (mysqld 5.7.2-m12) starting as process 26297 ...
2020-03-09T18:13:03.579561Z 0 [ERROR] Fatal error: Please read "Security" section of the manual to find out how to run mysqld as root!

2020-03-09T18:13:03.579594Z 0 [ERROR] Aborting

2020-03-09T18:13:03.579605Z 0 [Note] Binlog end
2020-03-09T18:13:03.579999Z 0 [Note] ./mysqld: Shutdown complete

解决方法:

  • 1、mysqld –user=root
  • 2.在MySQL配置文件 /etc/my.cnf 中加入user=mysql
1、编译时报错
CMake Error at cmake/readline.cmake:85 (MESSAGE):
  Curses library not found.  Please install appropriate package,

      remove CMakeCache.txt and rerun cmake.On Debian/Ubuntu, package name is libncurses5-dev, on Redhat and derivates it is ncurses-devel.

解决方法:

  • yum -y install ncurses-devel
  • rm -f CMakeCache.txt

本页面为MySQL系列问题记录

将持续进行更新

该文章采用「CC 协议」,转载必须注明作者和本文链接.
分类: Mysql