linux配置mysql

wget http://dev.mysql.com/get/mysql57-community-release-el7-11.noarch.rpm


yum localinstall mysql57-community-release-el7-11.noarch.rpm

校验是否安装成功
yum repolist enabled | grep "mysql.*-community.*"      

yum install mysql-community-server

启动
systemctl start mysqld

状态
systemctl status mysqld

开机自启
systemctl enable mysqld
systemctl daemon-reload


准备修改密码
 
查看初始密码
grep 'temporary password' /var/log/mysqld.log

复制一下

进入mysql
mysql -uroot -p

修改密码
set global validate_password_policy=0;
set global validate_password_length=1;

set password for 'root'@'localhost'=password('xzff2020');

给其他机器授权
GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' IDENTIFIED BY 'xzff2020' WITH GRANT OPTION;FLUSH PRIVILEGES;


改编码
vim /etc/my.cnf

[mysqld]下添加
character-set-server=utf8
init_connect='SET NAMES utf8' 

重启
systemctl restart mysqld