Centos7 安装mysql5.7

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

2.yum localinstall mysql57-community-release-el7-8.noarch.rpm 

3.修改 vim /etc/yum.repos.d/mysql-community.repo源 ，改变默认安装的mysql版本。比如要安装5.6版本，将5.7源的enabled=1改成enabled=0。然后再将5.6源的enabled=0改成enabled=1即可

4. yum install mysql-community-server

5. systemctl enable mysqld

    systemctl daemon-reload

　启动MySQL服务

    systemctl restart mysqld

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

7.mysql -uroot -p

8.ALTER USER 'root'@'localhost' IDENTIFIED BY 'MyNewPass4!';

9.添加远程登录用户 GRANT ALL PRIVILEGES ON *.* TO 'caoxiaobo'@'%' IDENTIFIED BY 'Caoxiaobo0917!' WITH GRANT OPTION;

10.安装 mysql-devel

11.编写c程序测试  gcc sql.c -o sql -I/usr/include/mysql -L/usr/lib64/mysql -lmysqlclient