mysql 安装、建表及允许远程连接，及django连接mysql

系统centos7 64

1.下载

wget http://dev.mysql.com/get/Downloads/MySQL-5.6/mysql-5.6.33-linux-glibc2.5-x86_64.tar.gz

2.解压

tar -zxvf mysql-5.6.33-linux-glibc2.5-x86_64.tar.gzcp -r mysql-5.6.33-linux-glibc2.5-x86_64 /usr/local/mysql

3.添加组、用户

groupadd mysqluseradd -g mysql mysql

4.安装

cd /usr/local/mysql/mkdir ./data/mysqlchown -R mysql:mysql ././scripts/mysql_install_db --user=mysql --datadir=/usr/local/mysql/data/mysqlcp support-files/mysql.server /etc/init.d/mysqldchmod 755 /etc/init.d/mysqldcp support-files/my-default.cnf /etc/my.cnf#修改启动脚本vi /etc/init.d/mysqld#修改项：basedir=/usr/local/mysql/datadir=/usr/local/mysql/data/mysql#启动服务service mysqld start#测试连接./mysql/bin/mysql -uroot#加入环境变量，编辑 /etc/profile，这样可以在任何地方用mysql命令了export PATH=$PATH:/usr/local/mysql//binsource /etc/profile#启动mysqlservice mysqld start#关闭mysqlservice mysqld stop#查看运行状态service mysqld status

5.授权远程登录

GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' IDENTIFIED BY 'youpassword' WITH GRANT OPTION;FLUSH PRIVILEGES;

6.建库

show databases;create database db_stu charset utf8;use db_stu;

7.加入环境变量

[root@localhost ~]# tail /etc/profileexport PATH="$PATH:/usr/local/mysql/bin"

8.自启动

chkconfig --add mysqldchkconfig --listchkconfig --level 345 mysqld on

9.Django配置D

# 安装pymysqlpip install PyMySQL# D:\python\web06\web06\__init__.pyimport pymysqlpymysql.install_as_MySQLdb()# D:\python\web06\web06\settings.pyDATABASES = {    'default': {        'ENGINE': 'django.db.backends.mysql',        'NAME': 'db_stu',        'USER': 'root',        'PASSWORD': '888',        'HOST': '192.255.255.255',        'PORT': '',        'OPTIONS': {            'autocommit': True,        }    }}

10.修改字符集

alter table table_name convert to character set utf8;