Python Web部署笔记三(MySQL 5.7)

发表于2020-08-18 23:25:30 - superadmin

MySQL5.7安装

$ wget https://dev.mysql.com/get/mysql80-community-release-el7-3.noarch.rpm
$ yum localinstall mysql80-community-release-el7-3.noarch.rpm
$ yum repolist enabled | grep "mysql.*-community.*" 检查

$ sudo yum-config-manager --disable mysql80-community
$ sudo yum-config-manager --enable mysql57-community
$ sudo yum repolist enabled | grep mysql

$ sudo yum module disable mysql # EL8 systems only
$ sudo yum install mysql-community-server
$ sudo service mysqld start
$ sudo service mysqld status
$ systemctl enable mysqld

$ sudo grep 'temporary password' /var/log/mysqld.log #自动生成的root密码
$ mysql -uroot -p
$ ALTER USER 'root'@'localhost' IDENTIFIED BY 'MyNewPass4!';
$ quit;

$ sudo yum --disablerepo=\* --enablerepo='mysql*-community*' list available # 显示系统支持的其他mysql组件包
$ sudo yum install package-name

配置数据库

$ vi /etc/my.cnf

[mysqld]
datadir=/var/lib/mysql
socket=/var/lib/mysql/mysql.sock
symbolic-links=0
log-error=/var/log/mysqld.log
pid-file=/var/run/mysqld/mysqld.pid

# define by bobo.
port=3306
key_buffer_size=16M
max_allowed_packet=8M

log_timestamps=SYSTEM
#default-time-zone='+8:00'
character-set-server=utf8mb4
collation-server=utf8mb4_unicode_ci
skip-character-set-client-handshake


[client]
port=3306
socket=/var/lib/mysql/mysql.sock

[mysqldump]
quick

[mysql]
no-auto-rehash
connect_timeout=2

$ systemctl restart mysqld

创建数据库，恢复数据

$ source /srv/awesome/www/schema.sql; #登录mysql后操作
$ mysql -uroot -p awesome < /srv/awesome/backup/awesome_back_20200807.sql

修改config_server.py

部署环境数据库地址用户名等