Centos7安装MySQL5.7

配置mysql yum源

MySQL Yum 存储库的https://dev.mysql.com/downloads/repo/yum/
wget https://repo.mysql.com//mysql80-community-release-el7-3.noarch.rpm
rpm -Uvh mysql80-community-release-el7-3.noarch.rpm


查看 MySQL Yum 存储库中的所有子存储库
yum repolist all | grep mysql


禁用 8.0 系列的子存储库，并启用 5.7 系列的子存储库。
yum-config-manager --disable mysql80-community
yum-config-manager --enable mysql57-community

安装 MySQL

yum install mysql-community-server -y

启动MySQL

systemctl start mysqld.service

查看MySQL状态

systemctl status mysqld.service

root的密码被设置并存储在错误日志文件中，以下，命令显示密码

grep 'temporary password' /var/log/mysqld.log

登录MySQL

mysql -uroot -p

修改密码

ALTER USER 'root'@'localhost' IDENTIFIED BY 'MyNewPass!';

检查一下MySQL编码

status；

查看MySQL所有安装的包

yum list installed | grep "^mysql"

更多请看MySQL官方文档

MySQL配置文件, 小内存配置，1G内存及下建议MySQL5.5
my.cnf

[mysqld]
skip-external-locking
key_buffer_size = 16K
max_allowed_packet = 1M
table_open_cache = 4
sort_buffer_size = 64K
read_buffer_size = 256K
read_rnd_buffer_size = 256K
net_buffer_length = 2K
thread_stack = 128K
character-set-server=utf8
datadir=/var/lib/mysql
socket=/var/lib/mysql/mysql.sock

[mysqld_safe]
log-error=/var/log/mysqld.log
pid-file=/var/run/mysqld/mysqld.pid

[mysqldump]
quick
max_allowed_packet = 16M

[mysql]
default-character-set=utf8
no-auto-rehash

[myisamchk]
key_buffer_size = 8M
sort_buffer_size = 8M

[mysqlhotcopy]
interactive-timeout

[client]
default-character-set=utf8