centos安装mysql

cd /usr/local/src/

wget http://repo.mysql.com/mysql57-community-release-el7-8.noarch.rpm 

rpm -ivh mysql57-community-release-el7-8.noarch.rpm 

yum -y install mysql-server 

 

默认配置文件路径： 
配置文件：/etc/my.cnf 
日志文件：/var/log/var/log/mysqld.log 
服务启动脚本：/usr/lib/systemd/system/mysqld.service 
socket文件：/var/run/mysqld/mysqld.pid

 

my.cnf:

1. datadir=/var/lib/mysql
2.  
   socket=/var/lib/mysql/mysql.sock
3.  
   server_id = 1
4.  
   expire_logs_days = 3

启动mysql服务

service mysqld restart

 

查看当前密码：

grep "password" /var/log/mysqld.log    

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

 

重置密码：

<<mysql<<  alter user 'root'@'localhost' identified by 'Root!!2018';  

 

远程连接：

use mysql

grant all privileges  on *.* to root@'%' identified by "password";

flush privileges;

 

安装Linux下的C++开发包：如果不安装，则找不到mysql.h文件

yum install mysql-devel

编译方式：g++ test.cpp `mysql_config --cflags --libs` -o test