[Py]py3/pip/mysql Environment installation

Win under correct posture installation Py3

• Select the Python3 of 64bit
• Choosing a Custom Installation

• Select Installation Location

• Install PIP

yum install install python-pip -ycdmkdir ~/.pipcat > .pip/pip.conf<<EOF[global]index-url = http://mirrors.aliyun.com/pypi/simple/ [install]trusted-host=mirrors.aliyun.comEOF

• Install the virtual environment

pip install virtualenvpip install virtualenvwrapperpip install virtualenvwrapper-winmkvirtualenv --python=C:\Python27\python.exe py27envexitmkvirtualenv --python=C:\Python36\python.exe py36envworkon  #查看刚刚创建的环境，mkvirtualenv  -h查看帮助

• Py3 Installing Mysql-devel Drivers

pip install pymysql

Pycharm settings

• Import configuration

wget https://github.com/lannyMa/scripts/blob/master/pycharm/settings.jarfile -> import settings就ok了黄色不伤害眼睛的rgb255 251 232FFFBE8

• Set Terminal

File -> Settings -> Tools -> Terminalfor 64bit:"C:\Program Files\Git\bin\sh.exe" -login -ifor 32bit:"C:\Program Files (x86)\Git\bin\sh.exe" -login -i"C:\Windows\System32\cmd.exe" /C "bash"

MySQL for win download installation

MySQL Community Server 5.7.16
http://dev.mysql.com/downloads/mysql/

cd D:\Program Files\mysql-5.7.19-winx64\binmysqld --initialize-insecure

Add path

D:\Program Files\mysql-5.7.19-winx64\bin

Start the MySQL service

"D:\Program Files\mysql-5.7.19-winx64\bin\mysqld" --installnet start mysqlmysql -u root -p"D:\Program Files\mysql-5.7.19-winx64\bin\mysqld" --removenet stop mysqlcreate database bbs;grant all on bbs.* to [email protected] identified by '123456';grant all on bbs.* to [email protected]'%' identified by '123456';

Character

SET NAMES 'utf8'; SET character_set_client = utf8;SET character_set_connection = utf8;SET character_set_database = utf8;SET character_set_results = utf8;SET character_set_server = utf8;SET collation_connection = utf8_general_ci;SET collation_database = utf8_general_ci;SET collation_server = utf8_general_ci;缺陷是: 登出后设置的就失效了.

show variables like '%storage_engine%';show VARIABLES like '%max_allowed_packet%';show variables like '%storage_engine%';show variables like 'collation_%';show variables like 'character_set_%';

MySQL Another configuration file persistence:

D:\Program Files\mysql-5.7.19-winx64\my.ini[mysqld]default-storage-engine = innodbinnodb_file_per_table = 1character-set-server = utf8collation-server = utf8_general_ciinit-connect = 'SET NAMES utf8'[mysql]default-character-set = utf8[mysql.server]default-character-set = utf8[mysqld_safe]default-character-set = utf8[client]default-character-set = utf8参考: http://blog.csdn.net/u013474104/article/details/52486880

MySQL Configuration and command reference

- mysql生产配置参考https://www.teakki.com/p/57e227aea16367940da625f8- 配置文件查找先后顺序C:\ProgramData\MySQL\MySQL Server 5.7\my.iniC:\windows\my.iniC:\my.iniE:\dev\mysql57\my.ini- 通过配置文件设置字符集default-storage-engine = innodbinnodb_file_per_table = 1character-set-server = utf8collation-server = utf8_general_ciinit-connect = 'SET NAMES utf8'- 查看建表语句show create database test;- 查看权限show grants

[Py]py3/pip/mysql Environment installation