linux下安装mysql

参考：https://www.jianshu.com/p/276d59cbc529

C语言调用mysql语句：

https://www.cnblogs.com/zhidongjian/p/10097842.html

https://www.cnblogs.com/lywy510/p/3615710.html

参考：https://blog.csdn.net/fy_1852003327/article/details/105890494

 

1、下载rpm包

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

2、安装mysql5.7的包

 yum -y install mysql57-community-release-el7-10.noarch.rpm

3、安装mysql服务器

yum -y install mysql-community-server

4、启动mysql服务

systemctl start mysqld.service

5、查看初始密码

cat /var/log/mysqld.log | grep "cat /var/log/mysqld.log | grep "temporary password" | awk -F 'root@localhost: ' '{print $2}'

6、设置开机自启动

#systemctl enable mysqld.service

7、编辑配置文件

[root@localhost bin]#  vi /etc/my.cnf

[mysqld]
#datadir=/usr/local/mysql/data
port=3306
sql_mode=NO_ENGINE_SUBSTITUTION,STRICT_TRANS_TABLES
symbolic-links=0
max_connections=600
innodb_file_per_table=1
lower_case_table_names=1

8、修改密码

[root@localhost /]#  mysql -u root -p
Enter password:
mysql>set password for root@localhost = password('yourpass');

为了使用mysql动态库及头文件：

9、下载mysql tar包

wget https://dev.mysql.com/get/Downloads/MySQL-5.7/mysql-5.7.31-linux-glibc2.12-x86_64.tar.gz

10、解压

tar -xzvf mysql-5.7.31-linux-glibc2.12-x86_64.tar.gz

11、修改mysql目录名

mv mysql-5.7.31-linux-glibc2.12-x86_64 mysql