如何在Linux中安装Mysql5.6

2025-03-29 技术教程

这篇文章给大家介绍如何在Linux中安装Mysql5.6 ，内容非常详细，感兴趣的小伙伴们可以参考借鉴，希望对大家能有所帮助。

1.2创建 mysql用户与组

groupadd-r-g306mysqluseradd-r-g306-u306-m-s/sbin/nologinmysql

1.3解压

tarxfmysql-5.6.40-linux-glibc2.12-x86_64.tar.gz-C/usr/local

1.4创建mysql软连接

cd/usr/localln-smysql-5.6.40-linux-glibc2.12-x86_64mysql

1.5修改所属主,所属组权限

chown-Rmysql.mysql/usr/local/mysql-5.6.40-linux-glibc2.12-x86_64chownmysql.mysql/usr/local/mysql

1.6创建目录，修改mysql目录的所属主

mkdir-p/data/mysql{,_binlog}chown-Rmysql.mysql/data/mysqlchown-Rmysql.mysql/data/mysql_binlog

1.7创建配置文件目录

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

1.8配置文件 vim /etc/mysql/my.cnf

[client]port=3306socket=/data/mysql/mysql.sock[mysqld]port=3306user=mysqlbasedir=/usr/local/mysqldatadir=/data/mysqlsocket=/data/mysql/mysql.sockpid-file=/data/mysql/mysql.pidlog-error=/data/mysql/mysql_error.logcharacter-set-server=utf8init_connect='SETNAMESutf8'innodb_log_file_size=256Minnodb_file_format=barracudainnodb_strict_mode=0innodb_file_per_table=on#跳过主机名解析skip-name-resolve#服务器ID，集群必填配置，区分机器编号，每台机器不同server_id=1#开启二进制日志，行级记录，同步写入磁盘log_bin=/data/mysql_binlog/mysql-binbinlog_format=rowsync_binlog=1sql_mode='STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION'symbolic-links=0

1.9修改PATH环境变量

]#vim/etc/profile.d/mysql.sh　　　　PATH=/usr/local/mysql/bin:$PATH]#source/etc/profile.d/mysql.sh

2.0创建数据库文件

cd/usr/local/mysql/./scripts/mysql_install_db--datadir=/data/mysql--user=mysql

2.1准备启动脚本

cd/usr/local/mysql/./scripts/mysql_install_db--datadir=/data/mysql--user=mysql

2.2安全初始化

ln-s/data/mysql/mysql.sock/tmp/mysql.sockmysql_secure_installationroot没有密码-->直接回车-->是否设置密码Y输入密码-->是否删除匿名用户Y-->是否禁止root远程连接N-->是否删除test测试数据库Y-->是否重新载入数据库Y--->OK

2.3主从复制架构

2.3.1配置文件

master 主数据库

log_bin=/bin_log_PATH/mysql-bin开启二进制日志binlog_format=row二进制日志记录方式，行级记录server_id=1

2.3.2创建主从复制专用权限用户

mysql>grantreplicationsalveon*.*to'repluer'@'172.16.1.%'identifiedby'123456'

2.3.3刷新二进制日志

mysql>resetmaster;mysql>showmasterstatus;

2.3.3 slave 从数据库配置文件

server_id=2

2.4建立主从关联

mysql>changemastertomaster_host='172.16.1.211',master_user='repluser',master_password='123456',master_log_file='mysql-bin.000001',master_log_pos=120;