[py]py3/pip/mysql環境安裝

標籤：window   eof   啟動mysql   建表   pack   work   virt   虛擬   show   

win下正確姿勢安裝py3

• 選擇64bit的python3
• 選擇自訂安裝

• 選擇安裝位置

• 安裝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

• 安裝虛擬環境

pip install virtualenvpip install virtualenvwrapperpip install virtualenvwrapper-winmkvirtualenv --python=C:\Python27\python.exe py27envexitmkvirtualenv --python=C:\Python36\python.exe py36envworkon  #查看剛剛建立的環境，mkvirtualenv  -h查看協助

• py3安裝mysql-devel驅動程式

pip install pymysql

pycharm設定

• 匯入配置

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

• 設定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下載安裝

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

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

添加path

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

啟動MySQL服務

"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';

字元集

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另一種設定檔持久化:

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配置及命令參考

- 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環境安裝