방금 전체 게임 소스 코드를 다운로드했고 CentOS 7에 웹 서버를 구축할 계획입니다. 그러나 많은 라이브러리가 필요하며 필요한 단계 중 하나는 사용자 정의 구성을 사용하여 사용자 정의 디렉터리에 MySQL을 설치하는 것입니다.
설치해야 할 항목 목록은 다음과 같습니다.
- ncurses-5.9.tar.gz
- libedit-20141030-3.1.tar.gz
- cmake-2.8.10.2.tar.gz
- mysql-5.6.21.tar.gz
mysql 자체의 경우 sql-common/client.c압축을 푼 후 1911행을 수정 mysql-5.6.21.tar.gz하고 다음 코드를 추가해야 합니다.
const char *cli_read_statistics(MYSQL *mysql);
int cli_unbuffered_fetch(MYSQL *mysql, char **row);
int cli_stmt_execute(MYSQL_STMT *stmt);
int cli_read_binary_rows(MYSQL_STMT *stmt);
my_bool cli_read_prepare_result(MYSQL *mysql, MYSQL_STMT *stmt);
MYSQL_FIELD *cli_list_fields(MYSQL *mysql);
cmake그 후에는 다음과 같이 컴파일 해야 합니다 .
cmake -DCMAKE_INSTALL_PREFIX=/data/local/tool/mysql-5.6.21 \
-DMYSQL_DATADIR=/data/local/tool/mysql-5.6.21/mysql_data \
-DSYSCONFDIR=/data/local/tool/mysql-5.6.21/mysql_etc -DEXTRA_CHARSETS=all \
-DDEFAULT_CHARSET=utf8mb4 \
-DDEFAULT_COLLATION=utf8mb4_unicode_ci \
-DWITH_INNOBASE_STORAGE_ENGINE=1 \
-DWITH_ARCHIVE_STORAGE_ENGINE=1 \
-DWITH_BLACKHOLE_STORAGE_ENGINE=1 \
-DWITH_FEDERATED_STORAGE_ENGINE=1 \
-DWITH_PARTITION_STORAGE_ENGINE=1 \
-DWITH_PERFSCHEMA_STORAGE_ENGINE=1 \
-DMYSQL_UNIX_ADDR=/tmp/mysqld.sock \
-DMYSQL_TCP_PORT=3360 -DWITH_DEBUG=0 \
-DENABLED_LOCAL_INFILE=1 \
-DEDITLINE_INCLUDE_DIR=/data/local/libs/libedit-20141029-3.1/include/editline \
-DEDITLINE_LIBRARY=/data/local/libs/libedit-20141029-3.1/lib/libedit.so \
-DWITH_EDITLINE=system && make && make install
실행하기 전까지는 모든 것이 정상인데 ./scripts/mysql_install_db --defaults-file=./my.cnf --user=mysql다음 오류가 발생합니다.
nstalling MySQL system tables...2024-04-13 10:26:57 0 [Warning] Using unique option prefix character-set-client instead of character-set-client-handshake is deprecated and will be removed in a future release. Please use the full name instead.
2024-04-13 10:26:57 0 [Warning] ./bin/mysqld: ignoring option '--character-set-client-handshake' due to invalid value 'utf8mb4'
2024-04-13 10:26:57 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details).
2024-04-13 10:26:57 12733 [Note] InnoDB: Using atomics to ref count buffer pool pages
2024-04-13 10:26:57 12733 [Note] InnoDB: The InnoDB memory heap is disabled
2024-04-13 10:26:57 12733 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
2024-04-13 10:26:57 12733 [Note] InnoDB: Memory barrier is not used
2024-04-13 10:26:57 12733 [Note] InnoDB: Compressed tables use zlib 1.2.3
2024-04-13 10:26:57 12733 [Note] InnoDB: Using CPU crc32 instructions
2024-04-13 10:26:57 12733 [Note] InnoDB: Initializing buffer pool, size = 128.0M
2024-04-13 10:26:57 12733 [Note] InnoDB: Completed initialization of buffer pool
2024-04-13 10:26:57 12733 [Note] InnoDB: Highest supported file format is Barracuda.
2024-04-13 10:26:57 12733 [Note] InnoDB: 128 rollback segment(s) are active.
2024-04-13 10:26:57 12733 [Note] InnoDB: Waiting for purge to start
2024-04-13 10:26:57 12733 [Note] InnoDB: 5.6.21 started; log sequence number 1600637
ERROR: 1 Can't create/write to file '/data/local/tool/mysql-5.6.21/mysql_data/mysql/db.MYI' (Errcode: 13 - Permission denied)
2024-04-13 10:26:57 12733 [ERROR] Aborting
2024-04-13 10:26:57 12733 [Note] Binlog end
2024-04-13 10:26:57 12733 [Note] InnoDB: FTS optimize thread exiting.
2024-04-13 10:26:57 12733 [Note] InnoDB: Starting shutdown...
2024-04-13 10:26:58 12733 [Note] InnoDB: Shutdown completed; log sequence number 1600647
2024-04-13 10:26:58 12733 [Note] ./bin/mysqld: Shutdown complete
소유자 /data/local/tool/mysql-5.6.21/mysql_data는 mysql.
위의 구성을 사용하여 mysql을 설치하는 다른 대안이 있습니까? 아니면 mysql을 설치 yum하고 뭔가를 수정하여 위의 구성을 복제할 수 있습니까?