Linux企业应用——mysql（一）之mysql初始化、mysql与phpadmin、mysql主从复制

一、mysql源码编译与初始化

1.参考官方文档进行编译

yum install -y cmake gcc-c++  ncurses-devel bison
tar zxf mysql-boost-5.7.36.tar.gz
cd mysql-5.7.36
cmake -DCMAKE_INSTALL_PREFIX=/usr/local/mysql -DMYSQL_DATADIR=/data/mysql -DMYSQL_UNIX_ADDR=/data/mysql/mysql.sock -DWITH_INNOBASE_STORAGE_ENGINE=1 -DENABLED_LOCAL_INFILE=1 -DWITH_EXTRA_CHARSETS=all -DDEFAULT_CHARSET=utf8mb4 -DDEFAULT_COLLATION=utf8mb4_unicode_ci -DWITH_BOOST=/root/mysql-5.7.36/boost/boost_1_59_0
make
make install

2.初始化

拷贝mysql启动脚本

cd /usr/local/mysql/support-files
cp mysql.server /etc/init.d/mysqld

修改配置文件

vim /etc/my.cnf

[mysqld]
datadir=/data/mysql
socket=/data/mysql/mysql.sock

添加环境变量

vim ~/.bash_profile
PATH=$PATH:$HOME/bin:/usr/local/php/bin:/usr/local/mysql/bin
source ~/.bash_profile

创建用户和数据目录