1.mysql介绍

mysql是一个数据库，安装它之后，Fox-Edge的数据可以存储到它里面，被它所管理。

2.安装mysql

#更新仓库
apt update -y

#默认安装mysql
apt-get install mysql-server -y

#检查mysql的安装是否成功
systemctl status mysql

#修改配置文件:bind-address = 127.0.0.1修改为bind-address = 0.0.0.0
#关闭binlog日志：在末尾添加 skip-log-bin ，登录后可以用show variables like '%log_bin%%';查询log_bin变为off
sed -i 's/bind-address\t\t= 127.0.0.1/bind-address\t\t= 0.0.0.0/g' /etc/mysql/mysql.conf.d/mysqld.cnf
grep -q "skip-log-bin" /etc/mysql/mysql.conf.d/mysqld.cnf || echo "skip-log-bin" >> /etc/mysql/mysql.conf.d/mysqld.cnf

#重启mysql
systemctl restart mysql

#验证mysql
systemctl status mysql

3.创建账号

创建mysql的root账号(非必须配置，配置它仅为了方便于开发调试)

  
  # -u 指定用户名 -p需要输入密码  回车输入密码
  mysql -u root -p  

  #后面是进入mysql后的操作

  #查看用户权限
  mysql> 
  use mysql;
  select host, user, plugin from user;

  #创建用户:'root'@'%'
  create user 'root'@'%' identified by '12345678';
  grant all privileges on *.* to 'root'@'%';
  flush privileges;
  exit;

4.卸载mysql

  # 检查MySQL服务状态
  systemctl status mysql

  # 如果服务是运行中的，先停止它
  systemctl stop mysql
  
  # 彻底移除MySQL相关的软件包及其配置文件
  apt purge mysql-server mysql-client mysql-common mysql-server-core-* mysql-client-core-*
  
  # 删除主配置目录、数据目录和日志目录
  rm -rf /etc/mysql /var/lib/mysql /var/log/mysql
  
  # 移除所有自动安装且不再需要的依赖包
  apt autoremove

  # 清理下载的软件包缓存（.deb文件）
  apt autoclean

5.一键安装

下面提供了一键安装命令，简化安装过程

apt-get update -y && \
apt-get install mysql-server -y && \
sed -i 's/bind-address\t\t= 127.0.0.1/bind-address\t\t= 0.0.0.0/g' /etc/mysql/mysql.conf.d/mysqld.cnf && \
  grep -q "skip-log-bin" /etc/mysql/mysql.conf.d/mysqld.cnf || echo "skip-log-bin" >> /etc/mysql/mysql.conf.d/mysqld.cnf && \
systemctl restart mysql