MySQL5.6版本安装并配置多实例Mysql数据库


本地环境:centos7.6+mysql5.6版本

mysql5.6版本安装

1、安装Mysql需要的依赖包和编译软件
1)安装依赖包
yum install -y ncurses-devel libaio-devel

2)安装cmake编译工具

  cmake
  定制功能:存储引擎、字符集、压缩等
  定制安装位置、数据存储位置、文件位置(socket)
yum install cmake -y

3)创建mysql管理用户
useradd -s /sbin/nologin -M mysql -u1024
id mysql

4)获取Mysql包解压,采用编译安装的方式安装Mysql
包是从国内开源镜像网站下载的:mysql-5.6.50.tar.gz

本地上传mysql-5.6.50.tar.gz包到/application/mysql/下;
到当前目录:
tar mysql-5.6.50.tar.gz
cd mysql-5.6.50

cmake . -DCMAKE_INSTALL_PREFIX=/application/mysql/mysql-5.6.50
-DMYSQL_DATADIR=/application/mysql/mysql-5.6.50/data
-DMYSQL_UNIX_ADDR=/application/mysql/mysql-5.6.50/tmp/mysql.sock
-DDEFAULT_CHARSET=utf8
-DDEFAULT_COLLATION=utf8_general_ci
-DEXTRA_CHARSETS=gbk,gb2312,utf8,ascii
-DENABLED_LOCAL_INFILE=ON
-DWITH_INNOBASE_STORAGE_ENGINE=1
-DWITH_FEDERATED_STORAGE_ENGINE=1
-DWITH_BLACKHOLE_STORAGE_ENGINE=1
-DWITHOUT_EXAMPLE_STORAGE_ENGINE=1
-DWITHOUT_PARTITION_STORAGE_ENGINE=1
-DWITH_FAST_MUTEXES=1
-DWITH_ZLIB=bundled
-DENABLED_LOCAL_INFILE=1
-DWITH_READLINE=1
-DWITH_EMBEDDED_SERVER=1
-DWITH_DEBUG=0

----------------------cmake报错:
-- Running cmake version 2.8.12.2
-- Could NOT find Git (missing: GIT_EXECUTABLE)
-- The C compiler identification is unknown
-- The CXX compiler identification is unknown
CMake Error: your C compiler: "CMAKE_C_COMPILER-NOTFOUND" was not found. Please set CMAKE_C_COMPILER to a valid compiler path or name.
CMake Error: your CXX compiler: "CMAKE_CXX_COMPILER-NOTFOUND" was not found. Please set CMAKE_CXX_COMPILER to a valid compiler path or name.
CMake Error at cmake/os/Linux.cmake:34 (STRING):
string sub-command REPLACE requires at least four arguments.
Call Stack (most recent call first):
CMakeLists.txt:184 (INCLUDE)

CMake Error at cmake/os/Linux.cmake:34 (STRING):
string sub-command REPLACE requires at least four arguments.
Call Stack (most recent call first):
CMakeLists.txt:184 (INCLUDE)

-- MySQL 5.6.50
-- Packaging as: mysql-5.6.50-Linux-i686
-- Could NOT find Threads (missing: Threads_FOUND)
-- Could NOT find Threads (missing: Threads_FOUND)
-- Check if the system is big endian
-- Searching 16 bit integer
CMake Error at /usr/share/cmake/Modules/TestBigEndian.cmake:44 (message):
no suitable type found
Call Stack (most recent call first):
configure.cmake:728 (TEST_BIG_ENDIAN)
CMakeLists.txt:468 (INCLUDE)

-- Configuring incomplete, errors occurred!
See also "/application/mysql/mysql-5.6.50/CMakeFiles/CMakeOutput.log".
See also "/application/mysql/mysql-5.6.50/CMakeFiles/CMakeError.log".
----------------------cmake报错:
原因:
解决: