centos-mysql安装

rpm包安装MySQL-5.7.37

rpm -e mariadb-libs --nodeps

rpm -ivh mysql-community-common-5.7.37-1.el7.x86_64.rpm     #服务器和客户端的通用文件

rpm -ivh mysql-community-libs-5.7.37-1.el7.x86_64.rpm              #数据库客户端应用程序的关系库

rpm -ivh mysql-community-client-5.7.37-1.el7.x86_64.rpm           #数据库客户端应用程序和工具

rpm -ivh mysql-community-server-5.7.37-1.el7.x86_64.rpm          #数据库服务器和相关工具

systemctl start mysqld

rpm -e mariadb-libs --nodeps

rpm -ivh mysql-community-common-5.7.37-1.el7.x86_64.rpm  

rpm -ivh mysql-community-libs-5.7.37-1.el7.x86_64.rpm    

rpm -ivh mysql-community-client-5.7.37-1.el7.x86_64.rpm  

rpm -ivh mysql-community-server-5.7.37-1.el7.x86_64.rpm

systemctl start mysqld

cat /var/log/mysqld.log  | grep password

mysql -uroot -p

本地yum仓库或网络yum

yum -y install mariadb mariadb-server   mariadb客户端   mariadb-server服务器

systemctl restart mariadb

进入mariadb

mysql

yum安装MySQL

wget -i -c http://dev.mysql.com/get/mysql57-community-release-el7-10.noarch.rpm

yum -y install mysql57-community-release-el7-10.noarch.rpm

rpm --import https://repo.mysql.com/RPM-GPG-KEY-mysql-2022

yum -y install mysql-community-server

systemctl start mysqld

cat /var/log/mysqld.log  | grep password

mysql -uroot -p

源码安装MySQL5.7.37

wget -O /etc/yum.repos.d/CentOS-Base.repo http://mirrors.aliyun.com/repo/Centos-7.repo

rpm -qa | grep mysql

rpm -qa | grep mariadb

rpm -e --nodeps mariadb-libs   使用yum删除会将mariadb的依赖关系一并删除

rpm -qa | grep mariadb

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

 

tar -zxf mysql-boost-5.7.37.tar.gz -C /usr/src/

cd /usr/src/mysql-5.7.37/

 

注意 这是一整条命令

 

cmake -DCMAKE_INSTALL_PREFIX=/usr/local/mysql -DMYSQL_DATADIR=/usr/local/mysql/data -DSYSCONFDIR=/usr/local/mysql/etc -DWITH_INNOBASE_STORAGE_ENGINE=ON -DWITH_MYISAM_STORAGE_ENGINE=ON -DDEFAULT_CHARSET=utf8 -DDEFAULT_COLLATION=utf8_general_ci -DENABLED_LOCAL_INFILE=ON -DMYSQL_TCP_PORT=3306 -DMYSQL_UNIX_ADDR=/usr/local/mysql/tmp/mysql.sock -DWITH_INNODB_MEMCACHED=ON -DWITH_BOOST=boost/boost_1_59_0

 

make && make install   如果虚拟机CPU在一个以上 可以用 make -j 多线程同时编译 会加快一下速度

配置MySQL参数

-DCMAKE_INSTALL_PREFIX=/usr/local/mysql                                 指定MySQL安装目录

-DMYSQL_DATADIR=/usr/local/mysql/data                                 指定MySQL数据目录

-DSYSCONFDIR=/usr/local/mysql/etc                                                 指定my.cnf选项文件目录

-DWITH_INNOBASE_STORAGE_ENGINE=ON                                Innodb引擎

-DWITH_MYISAM_STORAGE_ENGINE=ON                                        MyISAM引擎

-DDEFAULT_CHARSET=utf8                                                        服务器字符集，默认latin1

-DDEFAULT_COLLATION=utf8_general_ci                                         服务器排序规则，默认latin1_swedish_ci

-DENABLED_LOCAL_INFILE=ON                                                        是否为加载数据启用本地，默认为OFF

-DMYSQL_TCP_PORT=3306