ceiling的博客

mariadb 5.5.54安装1、安装包可以在https://mariadb.org/ 官网下载2、安装所需的组件包      yum install -y cmake gcc gcc-c++ ncurses-devel3、添加mysql用户    groupadd mysql    useradd -g mysql mysql -s /bin/false4、建立

1、安装依赖包yum install gcc python-devel mysql-devel zlib-devel openssl-devel2、下载安装https://pypi.org/project/MySQL-python/#filesgunzip MySQL-python-1.2.5.tar.gz$ tar -xvf MySQL-python-1.2.5.tar$ cd My...

1、安装配置heartbeat https://blog.youkuaiyun.com/qq_37594711/article/details/795039092、安装配置 drbd  https://blog.youkuaiyun.com/qq_37594711/article/details/795165273、安装配置 mysqld https://blog.youkuaiyun.com/qq_37594711/article...

1、先关闭mysql服务，修改配置文件/etc/my.cnf,在mysqld 模块里添加skip-grant 和 skip-networking或 手动启动mysql服务加参数./mysqld_safe --skip-grant-tables --skip-networking-user=mysql&2、启动mysqld服务，可以不输入密码直接进入root用户，修改密码update

1、MyISAM引擎备份加读锁mysqldump -A -F -B --lock-all-tables | gzip /root/mysql$(date +%F).sql.gz2、InnoDN引擎备份加行锁mysqldump -A -F -B --single-transaction | gzip /root/mysql$(date +%F).sql.gz3、删除二进制文件bin-

1、主库打开bin-log选项修改mysql配置文件log-bin=mysql-binexpire_logs_days = 7; bin-log保存时间2、授权同步用的帐号grant replication slave on *.* to rep@'192.168.1.%' identified by '123456';3、锁表flush table with read l

建库create database discuz character set utf8 collate utf8_bin;建用户grant all privileges on wordpress.* to wordpress@localhost identified by 'wordpress';grant create,select,insert,update,delete,drop o...

1、新建目录mkdir -p /data/{3307,3308}/data2、编辑多实例配置文件,3308可复制后更改端口[client]  port = 3307  socket = /data/3307/mysql.sock[mysqld]port = 3307socket = /data/3307/mysql.sockbasedir = /usr/loca

#!/bin/bashbakdir=/backup_mysql/bakdir2=/backup_mysql/mysqluser=rootpass=date=`date "+%Y%m%d%H%M"`database=`mysql -u"$user" -e "show databases" |sed 1d|grep -v schema`if [ ! -d

 用于pyhon连接mysql的函数，可传入sql语句、和where等参数#!/usr/bin/python# -*- coding: UTF-8 -*-import MySQLdbdef mysql_select(sql,parm): '''这是查询使用的函数''' #global data db = MySQLdb.connect...