mysql编译安装

1、安装编译环境

yum -y install gcc  gcc-c++  ncurses  ncurses-devel bison cmake make

2、上传压缩包并解压

tar -zxvf tar -zxvf mysql-5.7.32-el7-x86_64.tar.gz

mv mysql-5.7.32-el7-x86_64  /opt/mysql-5.7.32

3、创建管理用户

groupadd -r mysql

useradd -M -s /sbin/nologin  mysql -g mysql

4、预编译

cd mysql-5.7.37

cmake -DCMAKE_INSTALL_PREFIX=/usr/local/mysql  -DMYSQL_UNIX_ADDR=/usr/local/mysql/mysql.sock -DDEFAULT_CHARSET=utf8 -DDEFAULT_COLLATION=utf8_general_ci -DWITH_BOOST=boost

5、编译安装

make -j 4 && make install

6、添加配置文件

解决办法：vi /etc/my.cnf

=======================================

##配置自带

socket=/usr/local/mysql/mysql.sock

##添加内容

port = 3306

basedir=/usr/local/mysql

datadir=/usr/local/mysql/data

character-set-server=utf8

default-storage-engine=InnoDB

max_connections=5120

query_cache_size=0

tmp_table_size=18M

log-error = /data/mysql/mysql-error.log

thread_cache_size=8

myisam_max_sort_file_size=64G

myisam_sort_buffer_size=35M

key_buffer_size=25M

read_buffer_size=64K

read_rnd_buffer_size=256K

sort_buffer_size=256K

innodb_flush_log_at_trx_commit=1

innodb_log_buffer_size=1M

innodb_buffer_pool_size=47M

innodb_log_file_size=24M

innodb_thread_concurrency=8

=======================================

7、安装初始化

cd /usr/local/mysql

bin/mysqld --initialize   --lower-case-table-names=1 

bin/mysqld --initialize-insecure --user=mysql --basedir=/usr/local/mysql --datadir=/usr/local/mysql/data

bin/mysql_ssl_rsa_setup --user=mysql --basedir=/usr/local/mysql --datadir=/usr/local/mysql/data

#拷贝配置文件

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

vi /etc/profile 

# 在profile文件末尾增加两行 

PATH=/usr/local/mysql/bin:/usr/local/mysql/lib:$PATH 

export PATH 

#使PATH搜索路径立即生效：

source /etc/profile

# 启动数据库

systemctl start mysqld

#获取临时密码

cat /var/log/mysql/mysqld.log|grep pass|awk '{print $NF}'

mysql -uroot -p //登陆mysql

password： 复制粘贴临时密码登陆验证

============