1. CentOS7 安装 MySQL
- # wget http://dev.mysql.com/get/mysql-community-release-el7-5.noarch.rpm
- # rpm -ivh mysql-community-release-el7-5.noarch.rpm
- # yum install mysql-community-server
重启 MySQL 服务
# service mysqld restart
初次安装 mysql,root 账户没有密码
# mysql -u root
设置密码 // 可无
mysql> set password for root@localhost =password(password);
mysql 配置文件为 / etc/my.cnf
最后加上编码配置
- [mysql]
- default-character-set =utf8
远程连接设置
mysql> grant all privileges on *.* to root@%identified by password;
2. 安装 MySQL-python 模块
1.1 作用
Python 操作 MySQL 需要 MySQL-python 模块驱动
1.2 安装 MySQL-python
1) 下载地址: https://pypi.python.org/pypi/MySQL-python/
2) 解压:
#unzip MySQL-python-1.2.5.zip
3) 进入文件:
- #cd MySQL-python-1.2.5
- 4) #yum -y install mysql-devel
- 5) #yum install gcc python-devel
- 6) #python setup.py install
7) 安装成功, 测试:
- #python
- >>>import MySQLdb
来源: http://www.bubuko.com/infodetail-2518195.html