在CentOS 6上使用CMake安装MySQL可以让我们更加方便地管理MySQL。下面是具体的操作步骤：
1. 安装必要的依赖包:
sudo yum install -y libaio libaio-devel ncurses-devel openssl-devel cmake
2. 下载MySQL源码:
cd /usr/local/src/sudo wget https://cdn.mysql.com//Downloads/MySQL-5.7/mysql-5.7.36.tar.gz
3. 解压源码包并进入安装目录:
sudo tar -zxvf mysql-5.7.36.tar.gzsudo mv mysql-5.7.36 /opt/mysql-5.7cd /opt/mysql-5.7
4. 创建MySQL用户:
sudo groupadd mysqlsudo useradd -r -g mysql -s /bin/false mysql
5. 配置编译选项:
sudo cmake \-DCMAKE_INSTALL_PREFIX=/opt/mysql \-DMYSQL_DATADIR=/opt/mysql/data \-DWITH_INNOBASE_STORAGE_ENGINE=1 \-DWITH_MYISAM_STORAGE_ENGINE=1 \-DENABLED_LOCAL_INFILE=1 \-DDEFAULT_CHARSET=utf8 \-DDEFAULT_COLLATION=utf8_general_ci \-DWITH_EMBEDDED_SERVER=OFF
6. 编译并安装:
sudo makesudo make install
7. 配置MySQL:
sudo cp support-files/my-default.cnf /etc/my.cnfsudo cp support-files/mysql.server /etc/init.d/mysqlsudo chmod +x /etc/init.d/mysqlsudo chkconfig --add mysqlsudo chkconfig mysql onsudo chown -R mysql:mysql /opt/mysql*sudo /opt/mysql/bin/mysqld --initialize-insecure --user=mysqlsudo service mysql start
在以上步骤完成后，MySQL就已经成功安装并启动了。我们可以通过以下命令登录MySQL:
mysql -u root -p
接下来，你就可以开始使用CMake安装的MySQL了!
