首页 / MYSQL / MySQL5.7单实例二进制包安装方法

MySQL5.7单实例二进制包安装方法

内容导读

互联网集市收集整理的这篇技术教程文章主要介绍了MySQL5.7单实例二进制包安装方法，小编现在分享给大家，供广大互联网技能从业者学习和参考。文章包含15623字，纯文字阅读大概需要23分钟。

内容图文

myserver sed -i ‘s/shell/myserver/‘ /etc/sysconfig/network

2.2、关闭selinux

sed -i ‘s/SELINUX=enforcing/SELINUX=disabled/‘ /etc/selinux/config
setenforce  0

2.3、修改系统内核参数

cat >> /etc/sysctl.conf <<EOF
fs.file-max=655360
fs.aio-max-nr = 1048576
kernel.sem = 5050 646400 5050 128
kernel.shmmax = 137438953472
kernel.shmall = 4294967296
kernel.shmmni = 4096
net.ipv4.ip_local_port_range = 9000 65500
net.ipv4.tcp_mem = 94500000 915000000 927000000
net.core.wmem_default = 8388608
net.core.rmem_default = 8388608
net.core.rmem_max = 16777216
net.core.wmem_max = 16777216
net.ipv4.tcp_rmem = 4096 87380 16777216
net.ipv4.tcp_wmem = 4096 65536 16777216
net.core.netdev_max_backlog = 32768
net.ipv4.tcp_tw_recycle = 1
net.ipv4.tcp_tw_reuse = 1
net.ipv4.tcp_fin_timeout = 10
net.ipv4.tcp_keepalive_time = 300
net.ipv4.tcp_max_syn_backlog = 32768
net.ipv4.tcp_syncookies = 1
net.ipv4.tcp_timestamps = 0
net.ipv4.conf.default.accept_source_route = 0
vm.swappiness=1
EOF

# 使其生效
sysctl -p

2.4、安装依赖包

# 需要配置yum

yum  clean all
yum -y update
yum -y install gd libxml2-devel libjpeg-devel libpng-devel net-snmp-devel wget telnet vim zip unzip 
yum -y install curl-devel libxslt-devel pcre-devel libjpeg libpng libcurl4-openssl-dev 
yum -y install libcurl-devel libcurl freetype-config freetype freetype-devel unixODBC libxslt 
yum -y install libtool openssl-devel
yum -y install perl-devel perl-ExtUtils-Embed 
yum -y install ncurses-devel.x86_64  openldap-devel.x86_64 lrzsz  openssh-clients gcc-g77  bison 
yum -y install libmcrypt libmcrypt-devel mhash mhash-devel bzip2 bzip2-devel
yum -y install ntpdate rsync svn  patch  iptables iptables-services
yum -y install libevent libevent-devel  cyrus-sasl cyrus-sasl-devel
yum -y install gd-devel libmemcached-devel memcached git libssl-devel libyaml-devel auto 
yum -y install gcc gcc-c++ make autoconf automake ncurses-devel ncurses  cmake libaio libaio-devel  boost
yum -y install perl-DBI perl-DBD-MySQL perl-Time-HiRes perl-IO-Socket-SSL perl perl-devel
yum -y groupinstall "Server Platform Development" "Development tools"
yum -y groupinstall "Development tools"

2.5、基本初始化

mkdir -p /opt/mysql
cd /opt/mysql/
wget https://dev.mysql.com/get/Downloads/MySQL-5.7/mysql-5.7.20-linux-glibc2.12-x86_64.tar.gz
tar -zxf mysql-5.7.20-linux-glibc2.12-x86_64.tar.gz
cd /usr/local/
ln -s /opt/mysql/mysql-5.7.20-linux-glibc2.12-x86_64 mysql

2.6、创建所需要的目录

mkdir -p /gomeo2o/data/mysql/mysql_3306/{data,logs,tmp}
mkdir -p /data/backup/

# 更改权限
groupadd mysql
useradd -g mysql mysql -d /home/mysql -s /sbin/nologin

2.7、创建配置文件

# 排除干扰因素

if [ -f /etc/my.cnf ]; then
    mv /etc/my.cnf /etc/my.cnf.bak
fi 

cat >/gomeo2o/data/mysql/mysql_3306/my_3306.cnf <<EOF
# my_3306.cnf
[client]
port            = 3306
socket          = /gomeo2o/data/mysql/mysql_3306/tmp/mysql_3306.sock

[mysql]
#prompt="\u@\h:\p  \R:\m:\s [\d]>"
#tee=/gomeo2o/data/mysql/mysql_3306/data/query.log
#prompt="\u@\h:\p  \R:\m:\s [\d]>"
prompt = "[\u@\h][\d]>\_"  
connect_timeout = 5
no-auto-rehash

[mysqld]
#misc
user = mysql
basedir = /usr/local/mysql
datadir = /gomeo2o/data/mysql/mysql_3306/data
port = 3306
socket = /gomeo2o/data/mysql/mysql_3306/tmp/mysql_3306.sock

#timeout
interactive_timeout = 300
wait_timeout = 300

#character set
character-set-server = utf8

open_files_limit = 65535
max_connections = 100
max_connect_errors = 100000

skip-name-resolve = 1
disable-partition-engine-check=1
#logs
log-output=file
slow_query_log = 1
slow_query_log_file = /gomeo2o/data/mysql/mysql_3306/logs/mysql_3306_slow.log
log-error = /gomeo2o/data/mysql/mysql_3306/logs/mysql_3306_error.log
log_error_verbosity = 3
pid-file = mysql_3306.pid
long_query_time = 1
#log-slow-admin-statements = 1
#log-queries-not-using-indexes = 1
log-slow-slave-statements = 1

#tmp
tmpdir=/gomeo2o/data/mysql/mysql_3306/tmp
event_scheduler = 1
performance_schema = on
max_allowed_packet = 32M
character_set_server = utf8mb4
#character_set_server = utf8
default-time-zone = system
default-storage-engine = InnoDB
#bind_address = 172.16.151.248
explicit_defaults_for_timestamp = 1


#binlog
binlog_format = row
server-id = 1813306
log-bin = /gomeo2o/data/mysql/mysql_3306/logs/mysql-bin
log-bin-index = /gomeo2o/data/mysql/mysql_3306/logs/mysql-bin.index
binlog_cache_size = 4M
max_binlog_size = 1G
max_binlog_cache_size = 2G
sync_binlog = 1
expire_logs_days = 90
#replicate-wild-ignore-table=mysql.%
replicate-wild-ignore-table=test.%
replicate-wild-ignore-table=information_schema.%

#relay log
skip_slave_start = 1
max_relay_log_size = 1G
relay_log_purge = 1
relay_log_recovery = 1
log_slave_updates
#slave-skip-errors=1032,1053,1062

explicit_defaults_for_timestamp=1
#buffers & cache
table_open_cache = 2048
table_definition_cache = 2048
table_open_cache = 2048
max_heap_table_size = 96M
sort_buffer_size = 2M
join_buffer_size = 2M
thread_cache_size = 256
query_cache_size = 0
query_cache_type = 0
query_cache_limit = 256K
query_cache_min_res_unit = 512
thread_stack = 192K
tmp_table_size = 96M
key_buffer_size = 8M
read_buffer_size = 2M
read_rnd_buffer_size = 16M
bulk_insert_buffer_size = 32M

#myisam
myisam_sort_buffer_size = 128M
myisam_max_sort_file_size = 10G
myisam_repair_threads = 1

#innodb
innodb_buffer_pool_size = 10G
innodb_buffer_pool_instances = 1
innodb_data_file_path = ibdata1:1G:autoextend
innodb_flush_log_at_trx_commit = 1
innodb_log_buffer_size = 64M
innodb_log_file_size = 500M
innodb_log_files_in_group = 3
innodb_max_dirty_pages_pct = 50
innodb_file_per_table = 1
innodb_rollback_on_timeout
innodb_status_file = 1
innodb_io_capacity = 2000
transaction_isolation = READ-COMMITTED
innodb_flush_method = O_DIRECT
gtid_mode = ON
enforce_gtid_consistency = ON 
master_info_repository = TABLE
relay-log-info-repository = TABLE
binlog_checksum = NONE
log_slave_updates = ON
binlog_row_image=FULL

# Two-Master configure
#server-1 
#auto-increment-offset = 1
#auto-increment-increment = 2 

#server-2                          
#auto-increment-offset = 2
#auto-increment-increment = 2

# semi sync replication settings #
#plugin_dir = /usr/local/mysql/lib/mysql/plugin
#plugin_load = "validate_password.so;rpl_semi_sync_master=semisync_master.so;rpl_semi_sync_slave=semisync_slave.so"
plugin_dir = /usr/local/mysql/lib/plugin #官方版本的路径
plugin_load = "rpl_semi_sync_master=semisync_master.so;rpl_semi_sync_slave=semisync_slave.so" #官方版本的路径


loose_rpl_semi_sync_master_enabled = on     
loose_rpl_semi_sync_master_timeout = 5000      
loose_rpl_semi_sync_master_trace_level = 32   
loose_rpl_semi_sync_master_wait_no_slave = on 
loose_rpl_semi_sync_slave_enabled = on      
loose_rpl_semi_sync_slave_trace_level = 32
loose_rpl_semi_sync_master_enabled = 1
loose_rpl_semi_sync_slave_enabled = 1
loose_rpl_semi_sync_master_timeout = 5000
loose_rpl_semi_sync_master_wait_for_slave_count=1
loose_rpl_semi_sync_master_wait_point=AFTER_SYNC

slave_preserve_commit_order = 1
slave_transaction_retries = 128
log_timestamps = system
show_compatibility_56 = on
slave_parallel_workers = 16
slave_parallel_type = LOGICAL_CLOCK

loose_innodb_numa_interleave = 1
innodb_buffer_pool_dump_pct = 40
innodb_page_cleaners = 16
innodb_undo_log_truncate = 1
innodb_max_undo_log_size = 2G
innodb_purge_rseg_truncate_frequency = 128
#transaction_write_set_extraction = MURMUR32
# READ-UNCOMMITTED, READ-COMMITTED, REPEATABLE-READ, SERIALIZABLE ##
transaction_isolation = READ-COMMITTED
sql_mode = "STRICT_TRANS_TABLES,NO_ENGINE_SUBSTITUTION,NO_ZERO_DATE,NO_ZERO_IN_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,ONLY_FULL_GROUP_BY"


# group replication
##log-bin = mysql 
##server-id = 613306
##gtid_mode = ON
##enforce_gtid_consistency = ON 
##master_info_repository = TABLE
##relay-log-info-repository = TABLE
##binlog_checksum = NONE
##log_slave_updates = ON 
##binlog_format = row
##transaction_write_set_extraction=XXHASH64
##loose-group_replication_group_name = ‘3db33b36-0e51-409f-a61d-c99756e90154‘
##loose-group_replication_start_on_boot = off
##loose-group_replication_local_address= "10.125.141.62:23306"  # 不能超过5位数字
##loose-group_replication_group_seeds= "10.125.141.62:23306,10.125.141.62:23307,10.125.141.62:23308"  # 不能超过5位数字
##loose-group_replication_bootstrap_group= off
# loose-group_replication_single_primary_mode=FALSE   ###本次搭建的是mutil_mode
# loose-group_replication_enforce_update_everywhere_checks= TRUE

[mysqld_safe]
#malloc-lib=/usr/local/mysql/lib/jmalloc.so 
nice=-19
open-files-limit=65535
EOF

2.8、初始化数据库

chown -R mysql.mysql /gomeo2o/data
chown -R mysql.mysql /data/backup/
chmod -R 775 /data/backup/
/usr/local/mysql/bin/mysqld --defaults-file=/gomeo2o/data/mysql/mysql_3306/my_3306.cnf --initialize-insecure &

　# 查看日志
# tail -f /gomeo2o/data/mysql/mysql_3306/logs/error.log

2.9、启动数据库推荐做法

/usr/local/mysql/bin/mysqld_safe --defaults-file=/gomeo2o/data/mysql/mysql_3306/my_3306.cnf &

2.10、进入mysql,修改账号

/usr/local/mysql/bin/mysql  -uroot -p -P3306 -S /gomeo2o/data/mysql/mysql_3306/tmp/mysql_3306.sock

set sql_log_bin = 0;
create user ‘rpl_user‘@‘%‘;
grant replication slave on *.* to ‘rpl_user‘@‘10.%‘ identified by ‘BR8KLwXCKHgN‘;
update mysql.user set authentication_string=password(‘rootpwd2017‘) where user=‘root‘;
flush privileges;
set sql_log_bin = 1;
reset  master ; reset slave all;
exit;

######## 配置主从复制方法开始 ########
#    CHANGE MASTER TO MASTER_HOST=‘172.16.1.10‘,MASTER_USER=‘rpl_user‘,
#    MASTER_PASSWORD=‘BR8KLwXCKHgN‘,MASTER_PORT=3306,
#    MASTER_CONNECT_RETRY=10,MASTER_AUTO_POSITION =1;
#    
#    start slave;
#    show slave status\G;
######## 配置主从复制方法结束 ########

2.12、设置便捷使用方式

/usr/local/mysql/bin/mysql_config_editor set --host=localhost --login-path=3306_localhost_login --user=root --port=3306  --password --socket=/gomeo2o/data/mysql/mysql_3306/tmp/mysql_3306.sock

# 请输入root密码： rootpwd2017

alias mysql.3306.start=‘/usr/local/mysql/bin/mysqld_safe --defaults-file=/gomeo2o/data/mysql/mysql_3306/my_3306.cnf &‘
alias mysql.3306.stop=‘/usr/local/mysql/bin/mysqladmin --defaults-file=/gomeo2o/data/mysql/mysql_3306/my_3306.cnf --login-path=3306_localhost_login shutdown &‘
alias mysql.3306.login=‘/usr/local/mysql/bin/mysql --defaults-file=/gomeo2o/data/mysql/mysql_3306/my_3306.cnf --login-path=3306_localhost_login‘
# alias mysql.3306.all_dump=‘/usr/local/mysql/bin/mysqldump --defaults-file=/gomeo2o/data/mysql/mysql_3306/my_3306.cnf --login-path=3306_localhost_login  -R -E --triggers -e --max_allowed_packet=16777216 --net_buffer_length=16384  --default-character-set=utf8mb4 --set-gtid-purged=OFF --master-data=2 --single-transaction --all-databases --quick | gzip >/data/backup/all_database_bak_`date +%Y-%m-%d_%H_%M_%S`.sql.gz‘


cat  >>/root/.bashrc <<EOF
alias mysql.3306.start=‘/usr/local/mysql/bin/mysqld_safe --defaults-file=/gomeo2o/data/mysql/mysql_3306/my_3306.cnf &‘
alias mysql.3306.stop=‘/usr/local/mysql/bin/mysqladmin --defaults-file=/gomeo2o/data/mysql/mysql_3306/my_3306.cnf --login-path=3306_localhost_login shutdown &‘
alias mysql.3306.login=‘/usr/local/mysql/bin/mysql --defaults-file=/gomeo2o/data/mysql/mysql_3306/my_3306.cnf --login-path=3306_localhost_login‘
# alias mysql.3306.all_dump=‘/usr/local/mysql/bin/mysqldump --defaults-file=/gomeo2o/data/mysql/mysql_3306/my_3306.cnf --login-path=3306_localhost_login  -R -E --triggers -e --max_allowed_packet=16777216 --net_buffer_length=16384  --default-character-set=utf8mb4 --set-gtid-purged=OFF --master-data=2 --single-transaction --all-databases --quick | gzip >/data/backup/all_database_bak_`date +%Y-%m-%d_%H_%M_%S`.sql.gz‘
EOF

source  /root/.bash_profile

cat  >>/etc/rc.local <<EOF
#  alias mysql.3306.start=‘/usr/local/mysql/bin/mysqld_safe --defaults-file=/gomeo2o/data/mysql/mysql_3306/my_3306.cnf &‘
#  alias mysql.3306.stop=‘/usr/local/mysql/bin/mysqladmin --defaults-file=/gomeo2o/data/mysql/mysql_3306/my_3306.cnf --login-path=3306_localhost_login shutdown &‘
#  alias mysql.3306.login=‘/usr/local/mysql/bin/mysql --defaults-file=/gomeo2o/data/mysql/mysql_3306/my_3306.cnf --login-path=3306_localhost_login‘
##  alias mysql.3306.all_dump=‘/usr/local/mysql/bin/mysqldump --defaults-file=/gomeo2o/data/mysql/mysql_3306/my_3306.cnf --login-path=3306_localhost_login  -R -E --triggers -e --max_allowed_packet=16777216 --net_buffer_length=16384  --default-character-set=utf8mb4 --set-gtid-purged=OFF --master-data=2 --single-transaction --all-databases --quick | gzip >/data/backup/all_database_bak_`date +%Y-%m-%d_%H_%M_%S`.sql.gz‘
EOF

3、gtid故障处理一例

############################################# gtid故障处理开始 #############################################
#     模拟在从库删除库，然后再主库删除该库，报如下错误
#      Last_SQL_Error: Error ‘Can‘t drop database ‘db1‘; database doesn‘t exist‘ on query. Default database: ‘db1‘. Query: ‘drop database db1‘
#       Replicate_Ignore_Server_Ids: 
#                  Master_Server_Id: 623306
#                       Master_UUID: 11526eb0-fcbc-11e6-af7d-005056b937e2
#                  Master_Info_File: mysql.slave_master_info
#                         SQL_Delay: 0
#               SQL_Remaining_Delay: NULL
#           Slave_SQL_Running_State: 
#                Master_Retry_Count: 86400
#                       Master_Bind: 
#           Last_IO_Error_Timestamp: 
#          Last_SQL_Error_Timestamp: 170227 15:44:06
#                    Master_SSL_Crl: 
#                Master_SSL_Crlpath: 
#                Retrieved_Gtid_Set: 11526eb0-fcbc-11e6-af7d-005056b937e2:1-2
#                 Executed_Gtid_Set: 11526eb0-fcbc-11e6-af7d-005056b937e2:1,
#     1760a7a5-fcbc-11e6-8f14-005056b90358:1
#                     Auto_Position: 1
#              Replicate_Rewrite_DB: 
#                      Channel_Name: 
#                Master_TLS_Version: 
#     
#     处理方法：
#     stop slave;
#     set gtid_next=‘11526eb0-fcbc-11e6-af7d-005056b937e2:2‘;
#     begin;
#     commit;
#     set gtid_next=‘automatic‘;
#     start slave;
#     show slave status\G;
############################################# gtid故障处理结束 #############################################

四、配套卸载删除脚本

[root@myserver mysql]# sh Uninstall_mysql.sh 
  请注意,你正在关闭mysqld服务!!!
[Y/N]: Y
你已经选择关闭mysqld服务操作,即将关闭!!!
 1 2 3 4 5 6 7 8 9 10
mysql卸载完毕...

[root@myserver mysql]# chmod +x Uninstall_mysql.sh

cat Uninstall_mysql.sh 
#!/bin/bash
mysqld_count=`ps -ef|grep -v ‘grep‘ | grep mysqld |wc -l`
echo "  请注意,你正在关闭mysqld服务!!!"


function shutdown_and_delete_files () {
if [ "${mysqld_count}" -eq 2 ]; then 
        /usr/local/mysql/bin/mysqladmin --defaults-file=/gomeo2o/data/mysql/mysql_3306/my_3306.cnf --login-path=3306_localhost_login shutdown &
fi

# 模拟打印进度条
for i in {1..10}
do 
        echo -n " $i"
        sleep 1
done

# 删除链接文件

if [ -L /usr/local/mysql ]; then
        unlink /usr/local/mysql
fi

echo  ""

# 删除相应的文件

rm -rf /opt/mysql/mysql-5.7.20-linux-glibc2.12-x86_64
rm -rf /etc/my.cnf.bak 
rm -rf /data/backup/*
cp /root/.bashrc /root/.bashrc.bak
cp /etc/rc.local /etc/rc.local.bak
sed  -i  ‘/mysql.3306/d‘ /root/.bashrc
sed  -i  ‘/mysql.3306/d‘ /etc/rc.local
rm -rf /gomeo2o/data/*
echo "mysql卸载完毕..."
echo ""
}



read -p "[Y/N]: " answer
case "${answer}" in
        Y|y|YES|yes)
                echo "你已经选择关闭mysqld服务操作,即将关闭!!!"
                shutdown_and_delete_files
                ;;
        N|n|NO|no)
                echo "你已经取消关闭mysqld服务操作..."
                ;;
        *)
                #echo "Error choice"
                echo "Useage: [Y|YES|y|yes N|NO|n|no]"
                ;;
esac

MySQL5.7单实例二进制包安装方法

标签：swa not form str too configure post func logic

本文系统来源：http://www.cnblogs.com/bjx2020/p/8080568.html

内容总结

以上是互联网集市为您收集整理的MySQL5.7单实例二进制包安装方法全部内容，希望文章能够帮你解决MySQL5.7单实例二进制包安装方法所遇到的程序开发问题。如果觉得互联网集市技术教程内容还不错，欢迎将互联网集市网站推荐给程序员好友。

内容备注

版权声明：本文内容由互联网用户自发贡献，该文观点与技术仅代表作者本人。本站仅提供信息存储空间服务，不拥有所有权，不承担相关法律责任。如发现本站有涉嫌侵权/违法违规的内容，请发送邮件至 gblab@vip.qq.com 举报，一经查实，本站将立刻删除。

内容手机端

扫描二维码推送至手机访问。

本文链接：https://qyyshop.com/info/495975.html

来源：【匿名】

【上一篇】MySQL数据管理5 【下一篇】用IE远程创建Mysql数据库的简易程序

更多 ►

【MySQL5.7单实例二进制包安装方法】教程文章相关的互联网学习教程文章

windows2016 安装mysql5.7

下载msi安装包，一路下一步。安装好后，做下简单配置。默认的my.ini和datadir在C:\ProgramData\MySQL Server 5.7下更改默认my.ini的方法为修改注册表[HKEY_LOCAL_MACHINE\SYSTEM\ControlSet001\Services\MySQL57]修改ImagePath 中的参数即可还有一点要注意的就是，修改了my.ini中的datadir后，一定要给network service的读写权限原文：http://www.cnblogs.com/draweye/p/6824518.html

centeros7远程访问mysql5.7【代码】

先启动firewall防火墙：service firewalld start打开3306端口：firewall-cmd --add-port=3306/tcp --permanentmysql授权root账户远程访问：update mysql.user set Host=‘%‘where HOST=‘localhost‘ and User=‘root‘;flush privileges;重启mysql服务器：service mysqld restart搞定收工！！！！抱怨一句，今天上海好热啊原文：http://www.cnblogs.com/wenhainan/p/7249741.html

MySQL5.7传输表空间——迁移分区表

Mysql 传输表空间--将InnoDB分区表复制到另一个实例（二）实验环境：（都是mysql5.7）源库：192.168.2.200 mysql5.7.16 zhangdb下的emp_2分区表的目标库：192.168.2.100 mysql5.7.18 test下（将zhangdb的emp表，导入到目标库的test schema下）--：在源数据库中创建测试分区表emp_2，然后导入数据MySQL [zhangdb]> CREATE TABLE emp_2(id BIGINT unsigned NOT NULL AUTO_INCREMENT,x VARCHAR(500) NOT NULL,y ...

学习笔记--mysql5.7新版本

mysql5.7 在redhat6上安装新版本的mysql，若存在旧版本的mysql应卸载掉mysql —version 查看mysql版本rpm -qa | grep mysql 查看已经安装的mysql(需卸载的mysql包)新版本安装包：mysql-5.7.11-1.el6.x86_64.rpm-bundle.tar解压并安装：yum install -y mysql-community-*安装成功后启动mysql服务：/etc/init.d/mysqld start执行mysql_secure_installation进行安全初始化向导[root@server1 mnt]# mysql_secure_installation Secu...

mysql5.7忘记密码时，修改root密码【代码】

（1）.由于MySQL5.7在安装完后，第一次启动时，会在root目录下生产一个随机的密码，文件名为 .mysql_secret 所以，登录时需要用随机密码登录，然后通过以下命令修改密码 “SET PASSWORD = PASSWORD(‘new password’);”（2）. 在忘记root密码的时候，以windows为例： 1. 关闭正在运行的MySQL服务。 2. 打开DOS窗口，转到mysql\bin目录3. 输入mysqld --skip-grant-tables 回车--skip-grant-tables 的意思是启动MySQL服务的时候...

centos7下mysql5.7的安装【代码】

1.通过yum repository安装，地址https://dev.mysql.com/downloads/repo/yum/ 2.下载rpm文件wget https://dev.mysql.com/get/mysql80-community-release-el7-3.noarch.rpm3.可以参考https://dev.mysql.com/doc/mysql-yum-repo-quick-guide/en/安装mysql5.7 4.Adding the MySQL Yum Repositoryrpm -Uvh mysql80-community-release-el7-3.noarch.rpm[root@iZbp1gg50ddqbgxf1jpqwwZ home]# rpm -Uvh mysql80-community-release-el7-3.n...

CentOS7 yum方式安装MySQL5.7 + 远程连接【代码】【图】

1 下载并安装MySQL官方的 Yum Repository[root@localhost ~]# wget -i -c http://dev.mysql.com/get/mysql57-community-release-el7-10.noarch.rpm 使用上面的命令就直接下载了安装用的Yum Repository，大概25KB的样子，然后就可以直接yum安装了。[root@localhost ~]# yum -y install mysql57-community-release-el7-10.noarch.rpm 之后就开始安装MySQL服务器。[root@localhost ~]# yum -y install mysql-community-server 这步...

MySQL5.7 count()函数【代码】

我们都用过count()函数，最常用的就是全表统计行数。select count(*) from tableName;count(*) 这里是计算全表的行数。我们看官网的解释是：COUNT(*) counts the number of rows。我们建表测试一下：CREATE TABLE `tb_testFn_count` ( `id` INT(5) UNSIGNED NOT NULL AUTO_INCREMENT, `title` VARCHAR(10) DEFAULT NULL, `description` VARCHAR(10) DEFAULT NULL, PRIMARY KEY (id) )ENGINE=InnoDB AUTO_INCREMENT=6...

YUM CentOS 7 64位下mysql5.7安装配置【代码】【图】

配置YUM源在MySQL官网中下载YUM源rpm安装包：http://dev.mysql.com/downloads/repo/yum/#下载mysql源安装包# wget http://dev.mysql.com/get/mysql57-community-release-el7-8.noarch.rpm# 安装mysql源# yum localinstall mysql57-community-release-el7-8.noarch.rpm 检查mysql源是否安装成功# yum repolist enabled | grep "mysql.*-community.*"看到下图表示安装成功安装MySQL# yum install mysql-community-server 启动MySQ...

MYSQL5.7二进制包的安装

mysql5.7 二进制包安装1. 下载包 wget http://mirrors.sohu.com/mysql/MySQL-5.7/mysql-5.7.12-linux-glibc2.5-x86_64.tar.gz2. 解压 tar xxvf mysql-5.7.12-linux-glibc2.5-x86_64.tar.gzmv mysql-5.7.12-linux-glibc2.5-x86_64 /usr/local/mysql3. 初始化useradd -M -s /sbin/nologin mysql mkdir -p /data/mysqlchown mysql /data/mysqlcd /usr/local/mysql./bin/mysqld --initialize --user=mysql --datadir=/data/mysq...

安装mysql5.7【代码】

环境： CentOS7 mysql源选择本地源：[root@master ~]# ll win-share/mysql/57/ 总用量 207346 -rwxrwxrwx. 1 root root 26468960 2月 28 22:17 mysql-community-client-5.7.33-1.el7.x86_64.rpm -rwxrwxrwx. 1 root root 315280 12月 11 13:20 mysql-community-common-5.7.33-1.el7.x86_64.rpm -rwxrwxrwx. 1 root root 2458780 12月 11 13:21 mysql-community-libs-5.7.33-1.el7.x86_64.rpm -rwxrwxrwx. 1 root root 126...

docker安装mysql5.7【代码】

docker pull mysql:5.7 mkdir -p /mydata/mysql/conf cat > /mydata/mysql/conf/my.cnf << EOF [client] default-character-set=utf8[mysql] default-character-set=utf8[mysqld] init_connect=‘SET collation_connection=utf_unicode_ci‘ init_connect=‘SET NAMES uft8‘ character-set-server=utf8 collation-server=utf8_unicode_ci skip-character-set-client-handshake # 解决客户端连接慢，跳过域名解析 skip-name-resolv...

MySQL5.7脚本自动安装

脚本里面没有把同步时间写进去，这个写在最前面yum install -y ntp ntpdatecp -f /usr/share/zoneinfo/Asia/Shanghai /etc/localtime执行下列语句之前，请详细了解ntp和ntpdate的区别，由于我这里是测试环境，所以ntpdate并无问题，正式环境请慎用ntpdate（ntp是逐渐校正时间，ntpdate是跳跃式的直接修改时间，可能会对应用造成不良影响）（另外，在虚拟机上测试时，ntpd不是太明显）service ntpdate start /sbin/chkconfig --add ...

mysql5.7新增加用户和授权【代码】

迁移mysql数据库，运行项目的时候发现nginx和uWSGI都配置正确，可就是网站打不开，看了log文件，发现错误：django.db.utils.OperationalError: (1044, "Access denied for user ‘lcp‘@‘%‘ to database ‘work_blog‘")看到这意识到mysql数据库现在只有root账户，并没lcp这个。所以需要增加这个用户，并设置密码和相应权限，下面是一个通用命令：mysql -u root -p CREATE USER ‘myuser‘@‘localhost‘ IDENTIFIED BY ‘mypass...

centos7.3 使用yum快速安装mysql5.7【代码】

配置mysql yum源1.下载yum源 shell> wget http://dev.mysql.com/get/mysql57-community-release-el7-8.noarch.rpm 2.安装yum源包 shell>yum localinstall mysql57-community-release-el7-8.noarch.rpm 3.检查mysql源是否安装成功 shell> yum repolist enabled | grep "mysql.*-community.*" 4.安装mysql shell> yum install mysql-community-server 5.启动MySQL服务 shell> systemctl start mysqld 6.查看MySQL的启动状态 shell> s...

首页 / MYSQL / MySQL5.7单实例二进制包安装方法

MySQL5.7单实例二进制包安装方法

内容导读

内容图文

2.2、关闭selinux

2.3、修改系统内核参数

2.4、安装依赖包

2.5、基本初始化

2.6、创建所需要的目录

2.7、创建配置文件

2.8、初始化数据库

2.9、启动数据库推荐做法

2.10、进入mysql,修改账号

2.12、设置便捷使用方式

3、gtid故障处理一例

四、配套卸载删除脚本

内容总结

内容备注

内容手机端

【MySQL5.7单实例二进制包安装方法】教程文章相关的互联网学习教程文章

实例 - 相关标签

MYSQL - 技术教程分类

MYSQL - 最新教程

MYSQL - 最热教程