mysql的简单yum安装与编译安装

mysql简单安装

下载mysql安装源
wget https://repo.mysql.com/mysql57-community-release-el7-11.noarch.rpm
yum -y install mysql57-community-release-el7-11.noarch.rpm

安装mysql

[root@localhost ~]# yum -y install mysql-community-server mysql
[root@localhost ~]# systemctl start mysqld.service
查看初始化密码
[root@localhost ~]#  grep 'password' /var/log/mysqld.log
2021-08-21T04:22:05.085559Z 1 [Note] A temporary password is generated for root@localhost: T5jpstN6#3rR

登录
[root@localhost ~]# mysql -uroot -p'T5jpstN6#3rR'

修改密码
mysql> alter user 'root'@'localhost' identified by 'Syw.123com';
Query OK, 0 rows affected (0.00 sec)
退出后就可以用自己的密码登录

创建myedudb，并设置utf-8编码格式
mysql> create database myedudb character set utf8 collate utf8_bin;
Query OK, 1 row affected (0.00 sec)

创建admin用户并给admin用户操作数据库的权限
mysql> grant select,insert,update,delete,create,drop,alter,index on myedudb.* to 'admin'@'localhost' identified by 'Syw.123com' ;
Query OK, 0 rows affected, 1 warning (0.00 sec)

更新权限
mysql> flush privileges;
Query OK, 0 rows affected (0.00 sec)

查看刚才添加的权限
mysql> show grants for 'admin'@'localhost';
+--------------------------------------------------------------------------------------------------------+
| Grants for admin@localhost                                                                             |
+--------------------------------------------------------------------------------------------------------+
| GRANT USAGE ON *.* TO 'admin'@'localhost'                                                              |
| GRANT SELECT, INSERT, UPDATE, DELETE, CREATE, DROP, INDEX, ALTER ON `myedudb`.* TO 'admin'@'localhost' |
+--------------------------------------------------------------------------------------------------------+
2 rows in set (0.03 sec)

查看所有数据库
mysql> show databases;
+--------------------+
| Database           |
+--------------------+
| information_schema |
| myedudb            |
| mysql              |
| performance_schema |
| sys                |
+--------------------+

设置开机自启

[root@localhost ~]# systemctl enable mysqld

编译安装

安装编译环境

yum install gcc gcc-c++ glibc automake autoconf libtool make ncurses ncurses-devel bison  openssl openssl-devel -y

下载源码包

wget https://nchc.dl.sourceforge.net/project/boost/boost/1.59.0/boost_1_59_0.tar.gz	#用迅雷下载再传到虚拟机

wget https://github.com/kitware/CMake/releases/download/v3.14.5/cmake-3.14.5.tar.gz

wget https://mirrors.cloud.tencent.com/mysql/downloads/MySQL-5.7/mysql-5.7.33.tar.gz

进入下载目录，对cmake的解压安装

tar zxf cmake-3.14.5.tar.gz
cd cmake-3.14.5
./bootstrap
gmake && gmake install

对boost进行解压更名

tar xf boost_1_59_0.tar.gz -C /usr/local/
进入到local目录
[root@localhost local]# mv boost_1_59_0/ boost

编译

创建mysql的相关目录
mkdir -p /database/mysql/{data,tmp,binlog,logs}
tree -L 2 /database
/database
└── mysql
    ├── binlog
    ├── data
    ├── logs
    └── tmp
    
指定mysql用户属主，属组
groupadd mysql
useradd mysql -s /sbin/nologin -M -g mysql

解压并编译mysql

tar zxf mysql-5.7.33.tar.gz
cd mysql-5.7.33

cmake . -DCMAKE_INSTALL_PREFIX=/database/mysql \
-DMYSQL_DATADIR=/database/mysql/data \
-DMYSQL_UNIX_ADDR=/database/mysql/tmp/mysql.sock \
-DDEFAULT_CHARSET=utf8 \
-DDEFAULT_COLLATION=utf8_general_ci \
-DEXTRA_CHARSETS=gdk,gb2312,utf8,ascii \
-DENABLED_LOCAL_INFILE=ON \
-DWITH_INNOBASE_STORAGE_ENGINE=1 \
-DWITH_FEDERATED_STORAGE_ENGINE=1 \
-DWITH_BLACKHOLE_STORAGE_ENGINE=1 \
-DWITHOUT_EXAMPLE_STORAGE_ENGINE=1 \
-DWITHOUT_PARTITION_STORAGE_ENGINE=1 \
-DWITH_ZLIB=bundled \
-DWITH_EMBEDDED_SERVER=1 \
-DWITH_DEBUG=0 \
-DWITH_BOOST=/usr/local/boost

安装，时间较长
make install

-DCMAKE_INSTALL_PREFIX=/database/mysql #安装路径
-DMYSQL_DATADIR=/database/mysql/data #数据文件目录

配置mysql系统环境变量

echo 'export PATH=/database/mysql/bin:$PATH' >> /etc/profile
tail -1 /etc/profile

使配置文件生效
source /etc/profile
echo $PATH

修改mysql目录的属主和属组
chown -R mysql:mysql /database/mysql/
修改配置文件的属主和属组
chown mysql:mysql /etc/my.cnf

修改mysql配置文件

备份
cp /etc/my.cnf /etc/my.cnf.bak

vim /etc/my.cnf
[client]
port=3306
socket=/database/mysql/tmp/mysql.sock
default-character-set=utf8
[mysqld]
port=3306
user=mysql
basedir=/database/mysql
datadir=/database/mysql/data
pid-file=/database/mysql/mysqld.pid
socket=/database/mysql/tmp/mysql.sock
tmpdir=/database/mysql/tmp
character_set_server=utf8
server-id=1
max_connections=100
max_connect_errors=10
log-bin=/database/mysql/binlog/mysql-bin
log-error=/database/mysql/logs/mysql_5_7_33.err

cd /database/mysql

初始化mysql数据库
./bin/mysqld --initialize-insecure --user=mysql --basedir=/database/mysql --datadir=/database/mysql/data

实例开启ssl连接
./bin/mysql_ssl_rsa_setup --initialize-insecure --user=mysql --basedir=/database/mysql --datadir=/database/mysql/data

cd /database/mysql/data
chmod +r server-key.pem
ls -l server-key.pem

拷贝mysql启动脚本
cd /database/mysql
cp support-files/mysql.server /etc/init.d/mysql
ls -l /etc/init.d/mysql

重新加载mysql配置文件
systemctl daemon-reload

启动
/etc/init.d/mysql start
systemctl enable mysql