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:
-
datadir=/var/lib/mysql
-
socket=/var/lib/mysql/mysql.sock
-
server_id = 1
-
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