mysql8.0.11源码安装和rpm安装

mysql8.0.11源码安装操作

1、卸载掉系统自带的数据库

rpm -qa | grep mariadb
rpm -e --nodeps mariadb-libs-5.5.60-1.el7_5.x86_64

2、创建用户

groupadd mysql
useradd -r -g mysql -s /bin/false mysql

3、创建数据库存放数据的目录，并赋予权限

mkdir -p /u01/mysql/data
chown -R mysql:mysql /u01/mysql/data/
chmod 755 /u01/mysql/data/ -R

4、安装相关的依赖

yum -y install wget  cmake gcc gcc-c++ ncurses  ncurses-devel  libaio-devel  openssl openssl-devel

5、下载安装包并解压安装

wget https://cdn.mysql.com//Downloads/MySQL-8.0/mysql-boost-8.0.11.tar.gz
tar -xf mysql-boost-8.0.11.tar.gz -C /usr/local/
cd /usr/local/mysql-8.0.11/
cmake . -DCMAKE_INSTALL_PREFIX=/usr/local/mysql -DMYSQL_DATADIR=/u01/mysql/data -DSYSCONFDIR=/etc -DMYSQL_TCP_PORT=3306 -DWITH_BOOST=/usr/local/mysql-8.0.11/boost
make  && make install

7、权限配置

chown -R mysql:mysql /usr/local/mysql
chmod -R 755 /usr/local/mysql

8、数据库配置

cat /etc/my.cnf 
[mysqld]
port=3306
basedir=/usr/local/mysql
datadir=/u01/mysql/data
lower_case_table_names=1
max_connections=4096
max_connect_errors=10
character-set-server=utf8
default-authentication-plugin=mysql_native_password
log-error=/var/log/mysqld.log
pid-file=/var/run/mysqld/mysqld.pid
[mysql]
default-character-set=utf8
[client]
port=3306
default-character-set=utf8

9、创建配置中相关的目录，并赋权限

touch /var/log/mysqld.log
chown mysql:mysql /var/log/mysqld.log
chmod 755 /var/log/mysqld.log
mkdir -p /var/run/mysqld/
chown -R mysql:mysql /var/run/mysqld
touch /var/run/mysqld/mysqld.pid
chmod -R 755 /var/run/mysqld/mysqld.pid

10、初始化数据库

cd /usr/local/mysql/
./bin/mysqld --initialize --user=mysql --datadir=/u01/mysql/data/
./bin/mysql_ssl_rsa_setup
./bin/mysqld_safe --user=mysql &

11、建立数据库命令的软连接，获取密码，登录数据库，并修改数据库密码

ln -s /usr/local/mysql/bin/mysql /usr/bin/mysql
grep "A temporary password" /var/log/mysqld.log
mysql -uroot -p“临时密码”
ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY 'Wege%2018';
CREATE USER 'sprint01'@'%' IDENTIFIED BY 'Sprint02@mysql';
CREATE USER 'wg_dba'@'%' IDENTIFIED BY 'Wgdb%2017';
grant all privileges on *.* to 'sprint01'@'%'；
grant all privileges on *.* to 'wg_dba'@'%'；
FLUSH PRIVILEGES;

进入到数据库中后修改密码：

12、加入自启列表中

cd /usr/local/mysql/
cp support-files/mysql.server /etc/init.d/mysqld
chkconfig --add mysqld
chkconfig --level 345 mysqld on

13、主从配置

主：

1）配置server_id和binlog，重启数据库
2）授权同步的用户
CREATE USER 'repl'@'192.168.1.%' IDENTIFIED WITH mysql_native_password BY 'wenge%2018';
GRANT REPLICATION SLAVE ON *.* TO 'repl'@'192.168.199.198';
3）show master status；

从：

1）配置server_id，重启数据库
2）同步 
change master to 
master_host='192.168.1.70',
master_user='repl',
master_password='wenge%2018',
master_log_file='mysql-bin.000001',
master_log_pos=1923;
3）start slave；
4）show slave status\GRANT;

mysql8.0.11 rpm安装

1、卸载系统自带的数据库mariadb

rpm -qa|grep mariadb
rpm -e --nodeps mariadb-devel-5.5.60-1.el7_5.x86_64
rpm -e --nodeps mariadb-libs-5.5.60-1.el7_5.x86_64

2、安装依赖

rpm -ivh libaio-0.3.109-13.el7.x86_64.rpm
yum -y install openssl-devel
yum install perl-JSON

3、下载mysql

wget https://dev.mysql.com/get/Downloads/MySQL-8.0/mysql-8.0.11-1.el7.x86_64.rpm-bundle.tar
解压
mkdir /tmp/mysql
tar -xf mysql-8.0.11-1.el7.x86_64.rpm-bundle.tar -C /tmp/mysql
安装（顺序如下）
cd /tmp/mysql
rpm -ivh mysql-community-common-8.0.11-1.el7.x86_64.rpm
rpm -ivh mysql-community-libs-8.0.11-1.el7.x86_64.rpm
rpm -ivh mysql-community-client-8.0.11-1.el7.x86_64.rpm
rpm -ivh mysql-community-server-8.0.11-1.el7.x86_64.rpm

4、创建用户

groupadd mysql
useradd -g mysql mysql

5、初始化

root：mysqld --initialize --user=mysql或者mysqld --initialize-insecure --user=mysql。
mysql：mysqld --initialize或者mysqld --initialize-insecure。

6、其服务

systemctl  start  mysqld

7、修改密码

ALTER USER 'root'@'localhost' IDENTIFIED BY 'tangtang';