linux mysql 5.7.25安装,mysql 5.7.25 安装部署

Bertha 。 2023-01-20 13:56 2阅读 0赞

mysql 5.7.25 安装简介

1 卸载linux系统上自带的mysql插件(old版本)

rpm -qa|grep -i mysql

rpm –ev \{包名\} --nodeps

2 删除老版本mysql相关的安装目录命令

find / -name mysql

rm –rf \{目录名\}

3安装包下载

官网下载 mysql-5.7.25-linux-glibc2.12-x86\_64.tar.gz 编译过的安装包

tar -xzvf mysql-5.7.25-linux-glibc2.12-x86\_64.tar.gz

mv mysql-5.7.25-linux-glibc2.12-x86\_64 /usr/local/mysql

4主目录权限处理

查看组和用户情况

cat /etc/group | grep mysql

cat /etc/passwd |grep mysql

删除原mysql用户：userdel -r mysql，会删除其对应的组和用户

创建mysql组和mysql用户

groupadd mysql

useradd -r -g mysql mysql

chown -R mysql:mysql /usr/local/mysql (同理对应/var/lib/mysql)

5 修改配置文件：/etc/my.cnf

主库

\[client\]

\#client character set

default\_character\_set = utf8

\[mysqld\]

\#\#\#\#\#\#\#\#\#general config\#\#\#\#\#\#\#\#\#\#

sql\_mode=NO\_ENGINE\_SUBSTITUTION,STRICT\_TRANS\_TABLES

\#user who own mysql server

user = mysql

\#base directory

basedir=/usr/local/mysql

\#data directory

datadir=/var/lib/mysql/data

\#default server character set

character\_set\_server = utf8

\#default engines

default\_storage\_engine = innodb

\#server id

server\_id = 1

\#server port

port = 3306

\#max connections

max\_connections = 4000

\#skip name resolve

skip\_name\_resolve = on

\#pid file

pid-file = /var/lib/mysql/log/mysql.pid

\#connect timeout ,second

connect\_timeout = 10

\#close inactive connections ,second

wait\_timeout = 300

\#close interactive timeout ,second

interactive\_timeout = 300

lower\_case\_table\_names = 1

log\_bin\_trust\_function\_creators=1

\#\#\#\#\#\#log configure\#\#\#\#

\#swith on general log

general\_log = on

\#location of general log

general\_log\_file = /var/lib/mysql/log/master\_general.log

\#swith on bin log

log\_bin = /var/lib/mysql/log/mysql-bin

\#bin log index file

log\_bin\_index = /var/lib/mysql/log/mysql-bin.index

\#swith on slow log

slow\_query\_log = on

\#location of slow qurey log

slow\_query\_log\_file = /var/lib/mysql/log/mysql\_slow.log

\#time of slow qurey ,second

long\_query\_time=3

\#swith on error log

log\_error = /var/lib/mysql/log/mysql.err

\#auto clean bin log ,day

expire\_logs\_days = 14

\#binlog format set

binlog\_format=row

innodb\_buffer\_pool\_size = 32G         \# 50%-70% of total RAM

innodb\_log\_file\_size = 512M

innodb\_flush\_log\_at\_trx\_commit = 1

innodb\_flush\_method = O\_DIRECT

从库

\[client\]

\#client character set

default\_character\_set = utf8

\[mysqld\]

\#\#\#\#\#\#\#\#\#general config\#\#\#\#\#\#\#\#\#\#

sql\_mode=NO\_ENGINE\_SUBSTITUTION,STRICT\_TRANS\_TABLES

\#user who own mysql server

user = mysql

\#base directory

basedir=/usr/local/mysql

\#data directory

datadir=/var/lib/mysql/data

\#default server character set

character\_set\_server = utf8

\#default engines

default\_storage\_engine = innodb

\#server id

server\_id = 2

\#server port

port = 3306

\#max connections

max\_connections = 4000

\#skip name resolve

skip\_name\_resolve = on

\#pid file

pid\_file = /var/lib/mysql/log/mysql.pid

\#connect timeout ,second

connect\_timeout = 10

\#close inactive connections ,second

wait\_timeout = 300

\#close interactive timeout ,second

interactive\_timeout = 300

lower\_case\_table\_names = 1

log\_bin\_trust\_function\_creators=1

slave-skip-errors=1032,1060,1062

\#\#\#\#\#\#log configure\#\#\#\#

\#swith on general log

general\_log = on

\#location of general log

general\_log\_file = /var/lib/mysql/log/mysql\_general.log

\#swith on bin log

log\_bin = /var/lib/mysql/log/mysql-bin

\#bin log index file

log\_bin\_index = /var/lib/mysql/log/mysql-bin.index

\#swith on slow log

slow\_query\_log = on

\#location of slow qurey log

slow\_query\_log\_file = /var/lib/mysql/log/mysql\_slow.log

\#time of slow qurey ,second

long\_query\_time=3

\#swith on error log

log\_error = /var/lib/mysql/log/mysql.err

\#auto clean bin log ,day

expire\_logs\_days = 14

relay-log-index=/var/lib/mysql/log/relay-slave.index

relay-log=/var/lib/mysql/log/relay-slave

slave\_net\_timeout = 60

innodb\_buffer\_pool\_size = 32G

innodb\_log\_file\_size = 512M

innodb\_flush\_log\_at\_trx\_commit = 1

innodb\_flush\_method = O\_DIRECT

6 创建文件/tmp/mysql.sock：设置用户组及用户，授权

touch /tmp/mysql.sock

chown mysql:mysql /tmp/mysql.sock

chmod 755 /tmp/mysql.sock

7 安装和初始化数据库

cd /usr/local/mysql/bin/

./mysqld --initialize --user=mysql --basedir=/usr/local/mysql--datadir=/var/lib/mysql/data

8 安全启动mysql: ps -ef | grep mysql

./mysqld\_safe --user=mysql &

9 查询默认密码在log\_error日志里, 找到后保存到安全的地方

/var/lib/mysql/log/mysql.err

10 登陆设置新密码

cd /usr/local/mysql/bin/

./mysql -u root -p (log\_error记录)

set password=password("123456");

grant all privileges on \*.\* to 'root'@'%' identified by '123456';

flush privileges; 到此安装流程完毕

11 开机服务启动设置：

cp -a /usr/local/mysql/support-files/mysql.server /etc/init.d/mysql (service mysql start stop启动)

chkconfig --add mysql

chkconfig --level 345 mysql on

chkconfig --list mysql

ln -s /usr/local/mysql/bin/mysql /usr/bin  (软连接 快捷方式)

12 配置主从同步

主库

添加同步专用账号  GRANT REPLICATION SLAVE,RELOAD,SUPER ON \*.\* TO 'slave'@'192.168.1.%' IDENTIFIED BY 'Attack@123';

flush privileges;

show master status;

从库

stop slave;

change master to master\_host='192.168.1.60',master\_user='slave',master\_password='Attack@123',

master\_log\_file='mysql-bin.000001',master\_log\_pos=154;

start slave;

show slave status \\G;

linux mysql 5.7.25安装,mysql 5.7.25 安装部署

发表评论取消回复

还没有评论，来说两句吧...

相关阅读

相关 JAVA开发部署（linux下安装mysql）

相关 MySQL数据库管理系统安装部署——Linux

相关 linux mysql 5.7.25安装,mysql 5.7.25 安装部署

相关 mysql 的linux安装,mysql-linux安装

相关 linux安装mysql 菜鸟_Linux安装MySQL

相关 Linux部署安装MySQL---二进制文件安装

相关 Linux Mysql8.0.11 安装部署

相关在linux环境安装部署mysql

相关 docker部署安装MySQL

相关 Linux环境 MySQL 5.7 安装部署