MySQL源码编译与配置

admin

1.安装依赖包
yum install -y cmake ncurses-devel libtirpc*

2.安装boost
tar xzf boost_1_70_0.tar.gz
mv boost_1_70_0 /usr/local/boost

3.安装rpcsvc
tar zxvf rpcsvc-proto-1.4.tar.gz
cd rpcsvc-proto-1.4/
./configure
make
make install

4.安装mysql-boost
tar xzf mysql-boost-8.0.18.tar.gz
cd mysql-8.0.18/
cmake -DCMAKE_INSTALL_PREFIX=/usr/local/mysql -DWITH_BOOST=/usr/local/boost -DFORCE_INSOURCE_BUILD=1 -DDEFAULT_CHARSET=utf8 -DDEFAULT_COLLATION=utf8_general_ci
make
make install

5.mysql配置文件
/etc/my.cnf
/etc/my.cnf.d/client.cnf
/etc/my.cnf.d/mysql-default-authentication-plugin.cnf
/etc/my.cnf.d/mysql-server.cnf

6.创建mysql用户
useradd -M -s /sbin/nologin mysql
setfacl -m u:mysql:rwx -R /usr/local/mysql
setfacl -m d:u:mysql:rwx -R /usr/local/mysql

7.初始化数据库
/usr/local/mysql/bin/mysqld --initialize --user=mysql

#临时密码
eyksvSSa5c*T

8.启动服务
/usr/local/mysql/bin/mysqld_safe --user=mysql &

9.mysql服务开机启动
vi /etc/rc.local
/usr/local/mysql/bin/mysqld_safe --user=mysql &

10.重置密码
/usr/local/mysql/bin/mysqladmin -uroot -p'HF&s#9Zped3s' password '123';
set password='123';
alter user 'root'@'localhost' identified by '123';

11.客户端登录
/usr/local/mysql/bin/mysql -uroot -p123

12.查看进程
pstree |grep mysqld

13.查看端口
netstat -tunpl |grep mysqld

14.关闭服务
pkill mysqld