常用应用

MySQL

yum install epel-release -y
yum install https://rpms.remirepo.net/enterprise/remi-release-7.rpm -y
yum-config-manager --enable remi -y

安装

设置源

yum localinstall https://repo.mysql.com//mysql80-community-release-el7-1.noarch.rpm

设置源

rpm --import https://repo.mysql.com/RPM-GPG-KEY-mysql-2022

yum install mysql-community-server

启动服务

systemctl start mysqld # 启动

systemctl enable mysqld # 自启动

service mysqld status # 状态

查看版本

mysql -version

远程连接

登录授权

update mysql.user set host='%' where user="root";

flush privileges;

select user,host from mysql.user;

用户授权

grant all privileges on *.* to 'root'@'%';

flush privileges;

show grants for root@'%'\G;

尝试创建数据库

CREATE DATABASE xiuxian;

显示所有数据库

SHOW DATABASES;

退出

exit;

防火墙

检查系统是否安装了FirewallD：

systemctl status firewalld

如果该服务未安装，则需要使用以下命令安装：

sudo yum install firewalld

启动FirewallD服务：

sudo systemctl start firewalld

如果FirewallD服务已经运行，则会显示服务正在运行的消息。

设置FirewallD服务在系统启动时自动启动：

sudo systemctl enable firewalld

查看防火墙

firewall-cmd --query-port=3306/tcp

开启防火墙

firewall-cmd --zone=public --add-port=3306/tcp --permanent

重载防火墙

firewall-cmd --reload

密钥不匹配

更新

sudo yum update mysql80-community-release

重新安装

sudo yum install mysql-community-server

日常指令

sudo systemctl stop mysqld

sudo systemctl start mysqld

免密码登录

vi /etc/my.cnf

[mysqld]
skip-grant-tables

清空密码

use mysql;

update user set authentication_string = '' where user = 'root';

设置密码

ALTER USER '用户名'@'IP地址' IDENTIFIED BY 'XJH002580!';

刷新权限

FLUSH PRIVILEGES;

Redis

备份

redis-cli SAVE

删除

systemctl stop redis
yum remove redis -y

下载并编译

wget http://download.redis.io/releases/redis-6.2.13.tar.gz

redis-6.2.13

tar xzf redis-6.2.13.tar.gz

cd redis-6.2.13

make
make install

后台启动

redis-server --daemonize yes

Nginx

环境

# 安装
yum install make zlib zlib-devel gcc-c++ libtool openssl openssl-devel -y
# 下载
cd /usr/local
wget "http://downloads.sourceforge.net/project/pcre/pcre/8.45/pcre-8.45.tar.gz"
# 解压
tar zxvf "pcre-8.45.tar.gz"
# 编译
cd "pcre-8.45"
./configure
make
make install
# 检查
cd /usr/local/pcre-8.45
pcre-config --version

安装

# 下载
cd /usr/local
wget  "http://nginx.org/download/nginx-1.24.0.tar.gz"
# 解压
tar zxvf "nginx-1.24.0.tar.gz"
# 编译
cd "nginx-1.24.0"
./configure --prefix=/usr/local/nginx --with-http_gzip_static_module --with-http_stub_status_module --with-http_ssl_module --with-http_v2_module "--with-pcre=/usr/local/pcre-8.45"
make
make install
# 检查
/usr/local/nginx/sbin/nginx -v

Git

配置ssh

配置密钥

ssh-keygen -t rsa -C "xxx@xxx.com"

查看密钥

cd ~/.ssh  
cat id_rsa.pub

配置账号

git config --global user.email "xxx@xxx.com"
git config --global user.name "xxx"

显示

查看当前分支大小

git count-objects -vH | grep -E "count|size"

查看当前分支所有大小信息

git count-objects -vH

删除

git rm --cached <flie-name>

删除记录

git log --oneline --decorate --graph main

git rebase --onto <last-commit-to-keep> main

git push --force origin main

MySQL​

安装​

登录​

远程连接​

防火墙​

密钥不匹配​

日常指令​

免密码登录​

Redis​

备份​

删除​

下载并编译​

后台启动​

Nginx​

环境​

安装​

Git​

配置ssh​

显示​

删除​

删除记录​