1.下载并上传 mysql-5.7.14.tar.gzview plaincopy

tar-zxfmsql-5.7.14.tar.gz

2.安装依赖包view plaincopy

yum-yinstallgccgcc-c++ncursesncurses-develcmake

3.下载Boost库view plaincopy

wgethttp://downloads.sourceforge.net/project/boost/boost/1.59.0/boost_1_59_0.tar.gz

4.添加用户view plaincopy

groupaddmysql

useradd-r-gmysql-s/bin/falsemysql

5.预编译view plaincopy

cmake.\

-DCMAKE_INSTALL_PREFIX=/application/mysql-5.7.14\

-DMYSQL_DATADIR=/application/mysql-5.7.14/data\

-DDOWNLOAD_BOOST=1\

-DWITH_BOOST=/software/boost_1_59_0\

-DMYSQL_UNIX_ADDR=/application/mysql-5.7.14/tmp/mysql.sock\

-DDEFAULT_CHARSET=utf8\

-DDEFAULT_COLLATION=utf8_general_ci\

-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

6.编译安装view plaincopy

make

makeinstall

7.修改 /etc/my.cnfview plaincopy

[mysqld]

datadir=/application/mysql/data

socket=/application/mysql/tmp/mysql.sock

user=mysql

#Disablingsymbolic-linksisrecommendedtopreventassortedsecurityrisks

symbolic-links=0

character_set_server=utf8

8.修改权限view plaincopy

chown-Rmysql:mysqlmysql-5.7.14/

9.建立数据库目录view plaincopy

mkdirdata

chownmysql:mysqldata

10.初始化view plaincopy

bin/mysqld--initialize--user=mysql--basedir=/application/mysql--datadir=/application/mysql/data

11.设置加密连接view plaincopy

bin/mysql_ssl_rsa_setup

12.加入系统服务view plaincopy

cpsupport-files/mysql.server/etc/init.d/mysqld

修改mysqld文件里的basedirdatadir属性

chkconfigmysqldon#设置开机自启动

chkconfig--list|grepmysqld

13.启动 重启 停止view plaincopy

servicemysqldstart

servicemysqldrestart

servicemysqldstop

14.登录并修改初始密码copy

SETPASSWORDFOR'root'@'localhost'=PASSWORD('newpassword');

安装中遇到的问题view pcopy

StartingMySQL...ERROR!TheserverquitwithoutupdatingPIDfile(/application/mysql/Rong.pid).

1.查看错误日志 /var/log/mysqld.log 检查错误原因view plaincopy

[ERROR]Fatalerror:Can'topenandlockprivilegetables:Table'mysql.user'doesn'texist

2.原因：在进行初始化数据库权限表的时候默认创建的权限表在默认目录/usr/local/mysql/var下面，而实际是在 /application/mysql/data

3.通过需改 /etc/my.cnf 下 --datadir参数来解决问题