./scripts/mysql_install_db --datadir=/app/data --user=mysql
初始化完成之后
使用/etc/init.d/mysql start启动一直失败[root@izuf63nb42ltsh1wvt3nwvz mysql]# /etc/init.d/mysql start 
Starting MariaDB.180925 21:57:38 mysqld_safe Logging to '/var/log/mariadb/mariadb.log'.
180925 21:57:38 mysqld_safe Starting mysqld daemon with databases from /app/data
                                                           [FAILED]
err.log也没有报错信息,有没有大神告知一下原因

解决方案 »

  1.   

    配置文件如下:
    [client]
    port=3306
    socket=/tmp/mysql.sock
    default-character-set=utf8mb4
    [mysqld_safe]
    socket=/tmp/mysql.sock
    nice=0
    [mysqld]
    character-set-client-handshake=FALSE
    character-set-server=utf8mb4
    collation-server=utf8mb4_unicode_ci
    init_connect='SET NAMES utf8mb4'
    user= mysql
    pid-file=/app/mysqld.pid
    socket=/tmp/mysql.sock
    port=3306
    basedir=/usr/local/mysql
    datadir=/app/data
    tmpdir=/tmp
    lc_messages_dir=/usr/share/mysql
    lc_messages=en_US
    skip_name_resolve=on
    skip-external-locking
    max_connections=5000
    wait_timeout=600
    max_allowed_packet=16M
    thread_cache_size=256
    sort_buffer_size=4M
    bulk_insert_buffer_size=16M
    tmp_table_size=64M
    max_heap_table_size=64M
    myisam_recover=BACKUP
    key_buffer_size=256M
    table_open_cache=400
    myisam_sort_buffer_size=1024M
    concurrent_insert=2
    read_buffer_size=8M
    read_rnd_buffer_size=8M
    query_cache_limit=512K
    query_cache_size=256M
    general_log_file=/var/log/mysql/mysql.log
    general_log=1
    log_error=/var/log/mysql/err.log
    log_warnings=2slow_query_log=1
    slow_query_log_file=/var/log/mysql/mariadb-slow.log
    long_query_time=1
    log_slow_verbosity=query_plan
    log_bin=/var/log/mysql/mariadb-bin
    log_bin_index=/var/log/mysql/mariadb-bin.index
    expire_logs_days=10
    max_binlog_size=100M
    default_storage_engine=InnoDB
    innodb_buffer_pool_size=256M
    innodb_log_buffer_size=8M
    innodb_file_per_table=1
    innodb_open_files=400
    innodb_io_capacity=400
    innodb_flush_method=O_DIRECT
    [mysqldump]
    quick
    quote-names
    max_allowed_packet=16M
    [mysql]
    default-character-set=utf8mb4
    [isamchk]
    key_buffer=16M
    !includedir /etc/mysql/conf.d/
      

  2.   

    没有错误日志,没有报错,我换了官方的my-huge.cnf就解决了
      

  3.   


    没有错误日志,没有报错,我换了官方的my-huge.cnf就解决了
      

  4.   

    在 /etc/my.cnf中 修改