源码编译安装mysql-5.7.14
1.下载并上传 MySQL-5.7.14.tar.gz view plain copy
“专业、务实、高效、创新、把客户的事当成自己的事”是我们每一个人一直以来坚持追求的企业文化。 创新互联是您可以信赖的网站建设服务商、专业的互联网服务提供商! 专注于成都网站制作、成都做网站、软件开发、设计服务业务。我们始终坚持以客户需求为导向,结合用户体验与视觉传达,提供有针对性的项目解决方案,提供专业性的建议,创新互联建站将不断地超越自我,追逐市场,引领市场!
tar -zxf msql-5.7.14.tar.gz
2.安装依赖包 view plain copy
yum -y install gcc gcc-c++ ncurses ncurses-devel cmake
3.下载Boost库 view plain copy
wget http://downloads.sourceforge.net/project/boost/boost/1.59.0/boost_1_59_0.tar.gz
4.添加用户 view plain copy
groupadd mysql
useradd -r -g mysql -s /bin/false mysql
5.预编译 view plain copy
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 plain copy
make
make install
7.修改 /etc/my.cnf view plain copy
[mysqld]
datadir=/application/mysql/data
socket=/application/mysql/tmp/mysql.sock
user=mysql
# Disabling symbolic-links is recommended to prevent assorted security risks
symbolic-links=0
character_set_server=utf8
8.修改权限 view plain copy
chown -R mysql:mysql mysql-5.7.14/
9.建立数据库目录 view plain copy
mkdir data
chown mysql:mysql data
10.初始化view plain copy
bin/mysqld --initialize --user=mysql --basedir=/application/mysql --datadir=/application/mysql/data
11.设置加密连接 view plain copy
bin/mysql_ssl_rsa_setup
12.加入系统服务view plain copy
cp support-files/mysql.server /etc/init.d/mysqld
修改 mysqld 文件里的 basedir datadir 属性
chkconfig mysqld on # 设置开机自启动
chkconfig --list | grep mysqld
13.启动 重启 停止 view plain copy
service mysqld start
service mysqld restart
service mysqld stop
14.登录并修改初始密码 copy
SET PASSWORD FOR 'root'@'localhost'=PASSWORD('newpassword');
安装中遇到的问题 view pcopy
Starting MySQL... ERROR! The server quit without updating PID file (/application/mysql/Rong.pid).
1.查看错误日志 /var/log/mysqld.log 检查错误原因 view plain copy
[ERROR] Fatal error: Can't open and lock privilege tables: Table 'mysql.user' doesn't exist
2.原因:在进行初始化数据库权限表的时候默认创建的权限表在默认目录/usr/local/mysql/var下面,而实际是在 /application/mysql/data
3.通过需改 /etc/my.cnf 下 --datadir参数来解决问题
当前标题:源码编译安装mysql-5.7.14
网站网址:http://scyanting.com/article/ggieei.html