阿里云centos7装置mysql报错conflicts with file from pac

作者:admin | 日期:2018-11-02

  用源代码方法装置完5.7.17之后,展触动mysql,日记文件里提示:

  检查server-key.pem文件的权限(此雕刻个文件在mysql的data目次下):

  缺乏r权限,予以后效实处理。

  MySQL5.7.17在cmake的时分报错如次:

  处理方法是:

  1.在/usr/local下创立壹个名为boost的文件夹

  mkdir -p /usr/local/boost

  2.进入此雕刻个新创立的文件夹然后下载boost

  wget http://www.sourceforge.net/projects/boost/files/boost/1.59.0/boost_1_59_0.tar.gz

  3.松压

  tar -xvzf boost_1_59_0.tar.gz

  4.持续cmake,添加以上白色片断

  cmake . -DCMAKE_INSTALL_PREFIX=/usr/local/mysql \

  -DDEFAULT_CHARSET=utf8 \

  -DDEFAULT_COLLATION=utf8_general_ci \

  -DENABLED_LOCAL_INFILE=ON \

  -DWITH_INNOBASE_STORAGE_ENGINE=1 \

  -DWITH_FEDERATED_STORAGE_ENGINE=1 \

  -DWITH_BLACKHOLE_STORAGE_ENGINE=1 \

  -DWITHOUT_EXAMPLE_STORAGE_ENGINE=1 \

  -DWITH_PARTITION_STORAGE_ENGINE=1 \

  -DWITH_PERFSCHEMA_STORAGE_ENGINE=1 \

  -DCOMPILATION_COMMENT='Mysqlma' \

  -DWITH_READLINE=ON \

  -DWITH_BOOST=/usr/local/boost \

  -DSYSCONFDIR=/data/mysqldata/3306 \

  -DMYSQL_UNIX_ADDR=/data/mysqldata/3306/mysql.sock

  MySQL 5.7的错误日记时间和体系时间不不符,看宗到来费力,查阅官方文档得知从MySQL 5.7.2 末了尾,新增了 log_timestamps 参数,它首要是把持 error log、genera log等日记文件的露示时间参数:

  官文如次:

  This variable controls the timestamp time zone of error log messages, and of general query log and slow query log messages written to files. It does not affect the time zone of general query log and slow query log messages written to tables (mysql.general_log, mysql.slow_log). Rows retrieved from those tables can be converted from the local system time zone to any desired time zone with CONVERT_TZ() or by setting the session time_zone system variable.

  Permitted log_timestamps values are UTC (the default) and SYSTEM (local system time zone).

  Timestamps are written using ISO 8601 / RFC 3339 format: YYYY-MM-DDThh:mm:ss.uuuuuu plus a tail value of Z signifying Zulu time (UTC) or ±hh:mm (an offset from UTC).

  This variable was added in MySQL 5.7.2. Before 5.7.2, timestamps in log messages were written using the local system time zone by default, not UTC. If you want the previous log message time zone default, set log_timestamps=SYSTEM.

  做了如次修改后,露示正日了:


上一篇:零数瑞百家乐游戏

下一篇:没有了