Linux编译安装MySQL

//创建MySQL账户
groupadd mysql
useradd -g mysql mysql

//解压cmake
tar -zvxf cmake文件 -C 指定位置
./bootstrap
make
make install

//安装插件
yum install -y gcc-c++
yum install ncurses-devel
yum -y install zlib-devel
yum install ‘perl(Data::Dumper)’

cd ../mysql //进入MySQL目录
//编译MySQL
cmake -DCMAKE_INSTALL_PREFIX=/opt/sihe/mysql -DMYSQL_DATADIR=/opt/sihe/mysql/data -DSYSCONFDIR=/etc -DWITH_MYISAM_STORAGE_ENGINE=1 -DWITH_INNOBASE_STORAGE_ENGINE=1 -DWITH_MEMORY_STORAGE_ENGINE=1 -DWITH_READLINE=1 -DMYSQL_UNIX_ADDR=/var/lib/mysql/mysql.sock -DMYSQL_TCP_PORT=3306 -DENABLED_LOCAL_INFILE=1 -DWITH_PARTITION_STORAGE_ENGINE=1 -DEXTRA_CHARSETS=all -DDEFAULT_CHARSET=utf8mb4 -DDEFAULT_COLLATION=utf8mb4_general_ci

//编译和安装
make make install

//设置文件权限
cd mysql文件目录
chown -R mysql .
chgrp -R mysql .
scripts/mysql_install_db --user=mysql
chown -R root .
chown -R mysql data

//copy MySQL下的my.cnf到 /etc/my.cnf
cp my.cnf /etc/my.cnf
//忽略大小写
lower_case_table_names=1
解开注释

//启动数据库
bin/mysqld_safe --user=mysql &
service mysql.server start

修改密码
bin/mysqladmin -uroot password

修改远程访问
GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' IDENTIFIED BY 'SXsh@123' WITH GRANT OPTION;
flush privileges;