源码包安装(Python mysql redis)，,一 源码包安装(1)

源码包安装(Python mysql redis)，,一 源码包安装(1)

一 源码包安装

(1)python3.6源码包安装    ./configure       ------> 定制功能     make     make install     mysql 源码包    cmake    make     make install  (2) redis 源码包安装     make修改环境变量vim /etc/profile添加以下一行:export PATH=/opt/redis-3.2.10/src:$PATH生效配置source /etc/profile(3) 让python链接redisunzip redis-py-master.zip cd redis-py-masterpython3 setup.py install对redis的单实例进行连接操作python3>>>import redis>>>r = redis.StrictRedis(host=‘localhost‘, port=6379)>>>r.set(‘name‘, ‘oldguo‘)True>>>r.get(‘name‘)‘oldguo‘

二经典互联网架构项目

三 二进制包mysql(mysql5.7.20)

3.1 解压及制作软连接tar xf mysql-5.7.20-linux-glibc2.12-x86_64.tar.gzln -s mysql-5.7.20-linux-glibc2.12-x86_64 mysql3.2 编辑环境变量vim  /etc/profile添加以下一行:export PATH=/opt/mysql/bin:$PATH生效配置:source /etc/profile3.3 卸载自带mariadbyum remove mariadb-libs3.4 生成配置文件(/etc/my.cnf)vim /etc/my.cnf[mysqld]basedir=/opt/mysqldatadir=/opt/mysql/datasocket=/tmp/mysql.sockuser=mysqllog_error=/var/log/mysql.loglog_bin=/opt/mysql/data/mysql-binserver_id=100[mysql]socket=/tmp/mysql.sock3.5 创建用户和数据目录,并授权useradd mysql mkdir  /opt/mysql/data chown -R mysql.mysql /opt/mysql3.6 初始化数据[root@python3 ~]# mysqld --initialize-insecure --basedir=/opt/mysql --datadir=/opt/mysql/data --user=mysql2019-01-04T03:58:03.128958Z 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details).2019-01-04T03:58:03.142436Z 0 [ERROR] Could not open file ‘/var/log/mysql.log‘ for error logging: Permission denied2019-01-04T03:58:03.142492Z 0 [ERROR] Aborting报错解决:touch /var/log/mysql.log chown -R mysql.mysql /var/log/mysql.log再次初始化:mysqld --initialize-insecure --basedir=/opt/mysql --datadir=/opt/mysql/data --user=mysql3.7 启动mysql cd /opt/mysql/support-files./mysql.server startcp mysql.server /etc/init.d/mysqld/etc/init.d/mysqld restart扩展:使用systemctl 管理mysqlvim /etc/systemd/system/mysqld.service[Unit]Description=MySQL ServerDocumentation=man:mysqld(8)Documentation=http://dev.mysql.com/doc/refman/en/using-systemd.htmlAfter=network.targetAfter=syslog.target[Install]WantedBy=multi-user.target[Service]User=mysqlGroup=mysqlExecStart=/opt/mysql/bin/mysqld --defaults-file=/etc/my.cnfLimitNOFILE = 5000systemctl restart mysqldnetstat -tulnp |grep 33063.8 测试python3链接mysql创建mysql链接用户grant all on *.* to root@‘10.0.0.%‘ identified by ‘123‘;create database bbs charset utf8;python代码测试:pip3 install --upgrade pippip3 install pymysqlvim testmysql.py#!/usr/bin/python3import pymysqldb = pymysql.connect("10.0.0.100","root","123","bbs" )cursor.execute("SELECT VERSION()")data = cursor.fetchone()print ("Database version : %s " % data)db.close()python3  testmysql.py 

源码包安装(Python mysql redis)