基于RHEL6.3 安装MySQL踩过的坑

时间:2023-07-01 16:00:26

MySQL版本:Percona-Server-5.6.29

OS:RHEL6.3

  1. 安装出错

     [mysql@oracle ~]$ /home/mysql/scripts/mysql_install_db --user=mysql --basedir=/home/mysql --datadir=/mysql/data  --defaults-file=/home/mysql/etc/my.cnf
    /home/mysql/bin/my_print_defaults: /usr/lib64/libcrypto.so.10: no version information available (required by /home/mysql/bin/my_print_defaults)
    WARNING: The host 'oracle.com' could not be looked up with /home/mysql/bin/resolveip.
    This probably means that your libc libraries are not 100 % compatible
    with this binary MySQL version. The MySQL daemon, mysqld, should work
    normally with the exception that host name resolving will not work.
    This means that you should use IP addresses instead of hostnames
    when specifying MySQL privileges ! Installing MySQL system tables.../home/mysql/bin/mysqld: error while loading shared libraries: libnuma.so.1: cannot open shared object file: No such file or directory

    解决

     yum install numactl.x86_64
  2. 安装出错

     [mysql@oracle ~]$ /home/mysql/scripts/mysql_install_db --user=mysql --basedir=/home/mysql --datadir=/mysql/data  --defaults-file=/home/mysql/etc/my.cnf
    /home/mysql/bin/my_print_defaults: /usr/lib64/libcrypto.so.10: no version information available (required by /home/mysql/bin/my_print_defaults)
    WARNING: The host 'oracle.com' could not be looked up with /home/mysql/bin/resolveip.
    This probably means that your libc libraries are not 100 % compatible
    with this binary MySQL version. The MySQL daemon, mysqld, should work
    normally with the exception that host name resolving will not work.
    This means that you should use IP addresses instead of hostnames
    when specifying MySQL privileges ! Installing MySQL system tables.../home/mysql/bin/mysqld: /usr/lib64/libssl.so.10: no version information available (required by /home/mysql/bin/mysqld)
    /home/mysql/bin/mysqld: /usr/lib64/libcrypto.so.10: no version information available (required by /home/mysql/bin/mysqld)
    2017-08-03 19:53:54 0 [Note] /home/mysql/bin/mysqld (mysqld 5.6.29-76.2-log) starting as process 29077 ...
    2017-08-03 19:53:54 29077 [Warning] Can't create test file /mysql/data/oracle.lower-test
    2017-08-03 19:53:54 29077 [Warning] Can't create test file /mysql/data/oracle.lower-test

    解决

     yum update openssl