mysql实践(1)

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     //添加系统环境

里边有些信息要查看里边英文说明进行修改！