日常3.1--关于linux的操作记录（CentOS-MySQL）（

从以下简洁简短的命令可以看出，mysql的安装和配置明显是比jdk的少走了不少弯路（感谢大神Buff加护）

>>> 安装MySQL

1.下载mysql源安装包
wget http://dev.mysql.com/get/mysql57-community-release-el7-8.noarch.rpm

2.安装mysql源
yum localinstall mysql57-community-release-el7-8.noarch.rpm

3.检查mysql源是否安装成功
yum repolist enabled | grep "mysql.*-community.*"

3.安装mysql

yum install mysql-community-server

为了保证这个内容不会太过简短，就顺手偷偷加一些常用操作的记录

>>> 启动MySQL服务
systemctl start mysqld

>>> 查看MySQL的启动状态
systemctl status mysqld

>>> 重启MySQL服务
systemctl restart mysqld

>>> 开机启动
systemctl enable mysqld
systemctl daemon-reload

>>> 设置用户密码
set password for 'your user name'@'localhost'=password('your password');

>>> 添加远程登录用户
GRANT ALL PRIVILEGES ON *.* TO 'your user name'@'%' IDENTIFIED BY 'your password' WITH GRANT OPTION;

>>> 配置默认编码格式（/etc/my.cnf）
[mysqld]
character_set_server=utf8
init_connect='SET NAMES utf8'

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

下一篇主要记录一波maven私服的配置