翻车合集(附解决方法)

1

问题描述：
在源码安装php时出错
/usr/bin/ld: cannot find -lltdl
collect2: ld returned 1 exit status
make: *** [libphp5.la] Error 1
解决方法：
缺少libtool和libtool-ltdl-devel软件包，yum安装以下即可
yum -y install libtool libtool-ltdl-devel

2

问题描述：
源码安装过mysql后，重新源码安装新版本的mysql，cmake和make && make install正常，mysql初始化时报错
TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details).
2021-06-22T13:53:05.583807Z 0 [ERROR] --initialize specified but the data directory has files in it. Aborting.
2021-06-22T13:53:05.583828Z 0 [ERROR] Aborting
解决方法：
由于/usr/local/mysql目录下存在data目录，删掉即可。
问题后续：
初始化能正常进行，但是出现几个warning
2021-06-22T14:03:01.222449Z 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details).
2021-06-22T14:03:01.405220Z 0 [Warning] InnoDB: New log files created, LSN=45790
2021-06-22T14:03:01.442107Z 0 [Warning] InnoDB: Creating foreign key constraint system tables.
2021-06-22T14:03:01.505562Z 0 [Warning] No existing UUID has been found, so we assume that this is the first time that this server has been started. Generating a new UUID: 8e727ca6-d362-11eb-a308-000c2929037e.
2021-06-22T14:03:01.506517Z 0 [Warning] Gtid table is not ready to be used. Table ‘mysql.gtid_executed’ cannot be opened.
2021-06-22T14:03:01.507880Z 1 [Warning] root@localhost is created with an empty password ! Please consider switching off the --initialize-insecure option
mysql能正常使用。