mysql
Conan_ft
just do it
展开
专栏收录文章
- 默认排序
- 最新发布
- 最早发布
- 最多阅读
- 最少阅读
-
Dockerfile 制作httpd镜像,发布网站
[root@conan dockerfile]# cat DockerfileFROM centos:7MAINTAINER Conan_ft (634598660@qq.com)RUN yum -y install httpd unzip && mkdir -p /var/www/htmlADD conanhttpd.zip /usr/RUN unzip /usr/conanhttpd.zip -d /var/www/html/CMD [“httpd”,"-DFOREGROU原创 2021-11-20 11:41:11 · 736 阅读 · 0 评论 -
python 调用mysql数据库
import mysql.connector####### 数据库配置信息mydb = mysql.connector.connect(host=“10.10.10.10”,port=‘3306’,user=“vivian”,passwd=“123456”,database=“vivian”)#连接数据库mycursor = mydb.cursor()#创建数据库#mycursor.execute(“create database if not exists vivian”)#查看原创 2020-11-19 13:47:26 · 375 阅读 · 0 评论 -
mysql 审计日志表备份及清理
#################################################cat >>/home/backup_audit_log.sh<<EOF#!bin/bash#author conan#read -p "Please input remote server: " serverread -p "Please input mysql user: " userread -sp "Please input mysql user’s passwor原创 2020-09-11 23:21:16 · 1562 阅读 · 0 评论 -
mysql 集群搭建,使用nginx代理
wegt https://cdn.mysql.com//Downloads/MySQL-Cluster-7.6/mysql-cluster-gpl-7.6.14-el7-x86_64.tar.gzsystemctl stop firewalld.servicesystemctl disable firewalld.servicesed -i ‘s/SELINUX=enforcing/SELINUX=disabled/g’ /etc/selinux/configgroupadd mysqlusera原创 2020-05-30 21:05:49 · 614 阅读 · 0 评论 -
mysql install shell
#!/bin/bash###author conanecho " mysql install"mysql_file="/usr/local/mysql*.tar.gz"############### whether mysql file existsif [ ! -f $mysql_file ];thentar -zxvf /usr/local/mysql*.tar.gzelseecho " please upload mysql free installation package und原创 2020-05-08 21:55:14 · 179 阅读 · 0 评论
分享