MySQL 安装 5.5，5.6，5.7

MySQL 5.5 版本，编译安装使用 cmake 。 cmake 安装之前，如果已经运行过 cmake，尝试运行下面的命令来避免冲突，# make clean #  find / -iname "cmakecache.txt" | rm  编译安装的时候，需要指定 DDEFAULT_CHARET=utf8 ，指定字符集，避免后期出现错误！

编译安装 5.5 # yum install -y make cmake gcc-c++ bison ncurses # wget , tar  # groupadd mysql # useradd -g mysql -s /sbin/nologin -M mysql # mkdir /data/mysql # cd /usr/local/mysql # cmake  -DCMAKE_INSTALL_PREFIX=/usr/local/mysql \ -DMYSQL_DATADIR=/data/mysql/ \ -DDEFAULT_CHARSET=utf8 \ -DDEFAULT_COLLATION=utf8_general_ci \ -DWITH_EXTRA_CHARSETS:STRING=utf8,gbk \ -DWITH_DEBUG=0 \ -DWITH_SSL=yes \ -DWITH_INNOBASE_STORAGE_ENGINE=1 \ -DWITH_READLINE=1 \ -DENABLED_LOCAL_INFILE=1 \ -DMYSQL_TCP_PORT=3306 # make ; echo $? ; make install ; echo $? 安装数据库 # cd /usr/local # chown -R mysql:mysql mysql # cd mysql # ./scripts/mysql_install_db --user=mysql --basedir=/usr/local/mysql --datadir=/data/mysql # chown -R root . # chown -R mysql /data/mysql 编辑配置文件并启动 # cp support-files/my-large.cnf /etc/my.cnf # bin/mysqld_safe --user=mysql & # cp support-files/mysql.server /etc/init.d/mysqld # chmod +x !$ # chkconfig -add mysqld # chkconfig mysqld on # /etc/init.d/mysqld start

编译安装 5.6 # groupadd mysql # useradd -g mysql -s /sbin/nologin mysql # wget  http://mirrors.sohu.com/mysql/MySQL-5.6/mysql-5.6.35.tar.gz # tar ; # cd mysql-5.6 # cmake -DCMAKE_INSTALL_PREFIX=/usr/local/mysql \ -DMYSQL_DATADIR=/data/mysql_data \ -DMYSQL_UNIX_ADDR=/usr/local/mysql/mysql.sock \ -DSYSCONFDIR=/etc \ -DWITH_MYISAM_STORAGE_ENGINE=1 \ -DWITH_ARCHIVE_STORAGE_ENGINE=1 \ -DWITH_BLACKHOLE_STORAGE_ENGINE=1 \ -DWITH_INNOBASE_STORAGE_ENGINE=1 \ -DWITH_MEMORY_STORAGE_ENGINE=1 \ -DWITH_READLINE=1 \ -DMYSQL_TCP_PORT=3306 \ -DENABLED_LOCAL_INFILE=1 \ -DWITH_PARTITION_STORAGE_ENGINE=1 \ -DEXTRA_CHARSETS=all \ -DDEFAULT_CHARSET=utf8 \ -DDEFAULT_COLLATION=utf8_general_ci # make; echo $?; make install ; echo $? 安装数据库 # mkdir /data/mysql_data # chown -R mysql:mysql /data/mysql_data # cd /usr/local/mysql # ./scripts/mysql_install_db --user=mysql --datadir=/data/mysql_data 编辑配置文件 # cp support-files/mysql.server /etc/init.d/mysqld # cp support-files/my-default.cnf /etc/my.cnf # chmod 755 /etc/init.d/mysqld # vim /etc/init.d/mysqld basedir=/usr/local/mysql datadir=/data/mysql_data # service mysqld start

二进制安装 5.7 # wget , tar , mv , # mkdir /data/mysql # chown -R mysql /data/mysql # cd /usr/local/mysql # bin/mysql_install_db --user=mysql --basedir=/usr/local/mysql/ --datadir=/usr/local/mysql/data/     完成之后有个提示  A temporary password is generated for root@localhost: 7xYgMS,i(pne 。  后面是 root 密码。 编辑配置文件 # cp support-files/mysql.server /etc/init.d/mysqld # cp support-files/my-default.cnf /etc/my.cnf # vim /etc/init.d/mysqld basedir=/usr/local/mysql datadir=/data/mysql # vim /etc/my.cnf basedir = /usr/local/mysql datadir = /data/mysql port = 3306 socket = /tmp/mysql.sock # /etc/init.d/mysqld start