• 安装依懒库

    1. yum install -y libaio gcc gcc-c++ boost-devel scons check-devel openssl-devel openssh-clients
  • mysql 下载
    https://downloads.mysql.com/archives/community/
    安装MySQL - 图1

    1. wget https://cdn.mysql.com/archives/mysql-5.5/mysql-5.5.37-linux2.6-x86_64.tar.gz
  • 解压文件

    1. tar -zxf mysql-5.5.37-linux2.6-x86_64.tar.gz
  • 文件移动到/usr/local下面,并更名为mysql

    1. mv mysql-5.5.37-linux2.6-x86_64/ /usr/local/mysql/
  • 建 mysql 用户和用户

    1. groupadd mysql
    2. useradd -g mysql mysql
  • 移除mariadb-libs库文件

    1. yum remove mariadb-libs
  • 初始化数据库
    ``` cd /usr/local/mysql/

./scripts/mysql_install_db —no-defaults —datadir=/usr/local/mysql/mysqldb/ —user=mysql

  1. - 修改 mysql 目录所有用户

chown -R mysql:mysql .

修改 mysqldb 权限

chmod 755 mysqldb

  1. - mysql 启动脚本

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

复制 mysql 配置文件

cp /usr/local/mysql/support-files/my-huge.cnf /etc/my.cnf

修改 mysql 配置文件

vim /etc/my.cnf

  1. ```
  2. [mysqld]
  3. datadir=/usr/local/mysql/mysqldb #mysql 数据目录
  • 添加客户端启动

    ln -s /usr/local/mysql/bin/mysql /usr/bin #软连接 mysql 命令
    
  • 启动
    ``` service mysqld start

添加服务

chkconfig —add mysqld


-  设置密码并测试

bin/mysqladmin -u root password ‘123456’

mysql -uroot -p123456


<a name="137b907f"></a>
## 允许同一网段访问

-  关闭防火墙

systemctl stop firewalld # 临时 systemctl disable firewalld # 永久


-  允许`192.168.1.%`以root用户登录(密码:123456)

GRANT ALL PRIVILEGES ON . TO ‘root’@’192.168.1.%’ IDENTIFIED BY ‘123456’ WITH GRANT OPTION;

FLUSH PRIVILEGES;


-  测试<br />![](https://raw.githubusercontent.com/Imprevia/Drawing_bed/master/img/20211005173751.png#id=duq7H&originHeight=589&originWidth=860&originalType=binary&ratio=1&status=done&style=none) 

![](https://raw.githubusercontent.com/Imprevia/Drawing_bed/master/img/20211005173632.png#id=V3Hxf&originHeight=433&originWidth=424&originalType=binary&ratio=1&status=done&style=none)

其他节点以同样的方式安装mysql

<a name="0d98c747"></a>
# 其他

使用`scp`将`mysql-5.5.37-linux2.6-x86_64.tar.gz`传输给其他节点

-  所有节点安装

yum install openssh-clients -y


-  传输

scp -p mysql-5.5.37-linux2.6-x86_64.tar.gz 192.168.1.62:/root ```