部署社交网站- MYSQL主从 与 MFS 文件系统
yum install ncurses ncurses-devel bison cmake -y ##安装依赖包 useradd -s /sbin/nologinmysqltar zxvf mysql-5.7.17.tar.gz -C
tar zxvf boost_1_59_0.tar.gz -C /usr/local/
cd /usr/local/
mv boost_1_59_0 boost
cd mysql-5.7.17/
cmake \
-DCMAKE_INSTALL_PREFIX=/usr/local/mysql ## 指定安装目录
-DMYSQL_UNIX_ADDR=/usr/local/mysql/mysql.sock
-DSYSCONFDIR=/etc ##指定初始化参数文件目录
-DSYSTEMD_PID_DIR=/usr/local/mysql
-DDEFAULT_CHARSET=utf8 ##指定默认字符集
-DDEFAULT_COLLATION=utf8_general_ci #默认使用的字符集校对规则
-DWITH_INNOBASE_STORAGE_ENGINE=1
-DWITH_ARCHIVE_STORAGE_ENGINE=1
-DWITH_BLACKHOLE_STORAGE_ENGINE=1
-DWITH_PERFSCHEMA_STORAGE_ENGINE=1
-DMYSQL_DATADIR=/usr/local/mysql/data
-DWITH_BOOST=/usr/local/boost ##指定Boost库的位置，5.7版本必须添加
-DWITH_SYSTEMD=1
！！注意：如果在CMAKE的过程中有报错，当报错解决后，需要把源码目录中的CMakeCache.txt文件删除，然后再重新CMAKE，否则错误依旧
make && make install ##安装过程时间较长
chown -R mysql.mysql /usr/local/mysql/ ##权限设置
vi /etc/my.cnf
port = 3306
default-character-set=utf8
socket = /usr/local/mysql/mysql.sock
port = 3306
default-character-set=utf8
socket = /usr/local/mysql/mysql.sock
user = mysql ##用户
basedir = /usr/local/mysql ##基础目录
datadir = /usr/local/mysql/data ##数据目录
port = 3306 ##端口
character_set_server=utf8 ##服务语言设置
pid-file = /usr/local/mysql/mysqld.pid ##pid文件位置
socket = /usr/local/mysql/mysql.sock ##socket文件位置
server-id = 1 ##服务ID
sql_mode=NO_ENGINE_SUBSTITUTION,STRICT_TRANS_TABLES,NO_AUTO_CREATE_USER,NO_AUTO_VALUE_ON_ZERO,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,PIPES_AS_CONCAT,ANSI_QUOTES
chown mysql:mysql /etc/my.cnf
echo 'PATH=/usr/local/mysql/bin:/usr/local/mysql/lib:$PATH' >> /etc/profile
echo 'export PATH' >> /etc/profile
source /etc/profile
## 方便使用mysql命令，设置环境变量
/usr/local/mysql/bin/mysqld
--initialize-insecure
--user=mysql
--basedir=/usr/local/mysql
--datadir=/usr/local/mysql/data
## 初始化数据库
cp usr/lib/systemd/system/mysqld.service /usr/lib/systemd/system/
systemctl daemon-reload
systemctl start mysqld
netstat -anpt | grep 3306
## 3306端口开启 服务开启成功
systemctl enable mysqld
mysqladmin -u root -p password "abc123" 给root账户设置密码为abc123
页:
[1]