Linux centos7安装MySQL5.7记录

下载安装
wget http://dev.mysql.com/get/mysql57-community-release-el7-11.noarch.rpm
sudo yum -y install mysql57-community-release-el7-11.noarch.rpm
yum repolist enabled | grep mysql.*
sudo yum install mysql-community-server


启动服务
systemctl start  mysqld.service
systemctl status mysqld.service
ps -uax|grep mysqld


查看登录密码
[gdut17@localhost ~]$ sudo grep "password" /var/log/mysqld.log
2020-11-13T12:32:14.566843Z 1 [Note] A temporary password is generated for root@localhost: 0o)zpWWTf6(r
[gdut17@localhost ~]$ mysql -u root -p
Enter password: 


改密码
mysql> set global validate_password_policy=0;
Query OK, 0 rows affected (0.00 sec)

mysql> set global validate_password_length=6;
Query OK, 0 rows affected (0.00 sec)

mysql> alter user 'root'@'localhost' identified by '123456';
Query OK, 0 rows affected (0.00 sec)

安装C客户端

sudo yum install mysql-community-devel.x86_64  
[gdut17@localhost ~]$ whereis mysql
mysql: /usr/bin/mysql /usr/lib64/mysql /usr/include/mysql /usr/share/mysql /usr/share/man/man1/mysql.1.gz

gcc test.c -I/usr/include/mysql -L/usr/lib64/mysql -lmysqlclient