1.编译安装mysql参数如下
cmake \
-DCMAKE_INSTALL_PREFIX=/opt/mysql \
-DMYSQL_DATADIR=/data/mysql/data \
-DSYSCONFDIR=/opt/mysql/etc \
-DWITH_MYISAM_STORAGE_ENGINE=1 \
-DWITH_INNOBASE_STORAGE_ENGINE=1 \
-DWITH_MEMORY_STORAGE_ENGINE=1 \
-DWITH_READLINE=1 \
-DMYSQL_UNIX_ADDR=/var/lib/mysql/mysql.sock \
-DMYSQL_TCP_PORT=3306 \
-DENABLED_LOCAL_INFILE=1 \
-DWITH_PARTITION_STORAGE_ENGINE=1 \
-DEXTRA_CHARSETS=all \
-DDEFAULT_CHARSET=utf8 \
-DDEFAULT_COLLATION=utf8_general_ci
2.修改增加配置文件
mysql_make是mysql的解压目录
cp ${mysql_make}/mysql/support-files/my-default.cnf /etc/my.conf
cp
${mysql_make}/mysql/support-files/mysql.server /etc/init.d/mysqld
vi /opt/mysql/bin/mysqld_safe
vi /etc/init.d/mysqld //修改一些必要信息
vi /etc/my.conf
vi /etc/profile //添加系统环境
里边有些信息要查看里边英文说明进行修改!