mysql 相关

安装 mysql 相关

  1. 查看mariadb数据库 rpm -qa | grep mariadb

  2. 卸载数据库：yum -y remove mari*

  3. 删除数据库文件： rm -rf /var/lib/mysql/*

  4. 根据某某安装

    • 根据rpm安装
    1rpm -ivh mysql-community-common-5.7.24-1.el7.x86_64.rpm
2rpm -ivh mysql-community-libs-5.7.24-1.el7.x86_64.rpm
3rpm -ivh mysql-community-client-5.7.24-1.el7.x86_64.rpm
4rpm -ivh mysql-community-server-5.7.24-1.el7.x86_64.rpm
5rpm -ivh mysql-community-devel-5.7.24-1.el7.x86_64.rpm
6rpm -ivh mysql-community-libs-compat-5.7.24-1.el7.x86_64.rpm

  5. 启动 mysql

    • service mysqld start

  6. 获取初始化密码

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

  7. 登陆

    • mysql -u root -p

  8. 修改root的密码

    • SET PASSWORD = PASSWORD('Root@123123');
    • ALTER USER 'root'@'localhost' PASSWORD EXPIRE NEVER;
    • flush privileges;

  9. 创建一个账号 并且给权限 （给用户top 密码 Top@123123 ）

    • GRANT ALL PRIVILEGES ON . TO 'top'@'%' IDENTIFIED BY 'Top@123123' WITH GRANT OPTION;

安装脚本（前提有本地yum 源）

 1
 2#!/bin/bash
 3PATH=/bin:/sbin:/usr/bin:/usr/sbin:/opt/bin:/opt/sbin:~/bin
 4export PATH 
 5# Check if user is root 
 6if [ $(id -u) != "0" ]; then
 7    echo "Error: You must be root to run this script, please use root to install"
 8    exit 1 
 9fi
10clear
11
12#HOSTNAME="192.168.111.84"                                           #数据库信息
13#PORT="3306"
14#USERNAME="root"
15#PASSWORD=""
16
17#DBNAME="test_db_test"                                                       #数据库名称
18#TABLENAME="test_table_test"                                            #数据库中表的名称
19
20# 查看mariadb数据库：
21rpm -qa | grep mariadb
22#卸载数据库：
23yum -y remove mari*
24#删除数据库文件： 
25rm -rf /var/lib/mysql/*
26
27echo '开始安装mysql'
28yum install -y mysql-community-server.x86_64
29echo '安装完成mysql'
30service mysqld start
31ss

修改root密码 且 创建账户 (前提 mysql 启动)

 1echo '启动完成'
 2#grep 'temporary password' /var/log/mysqld.log
 3
 4defaultmysqlpwd=`grep 'temporary password' /var/log/mysqld.log | awk -F"root@localhost: " '{ print $2}' `
 5echo $defaultmysqlpwd
 6mysqlpwd="Root@123123"
 7temp1="SET PASSWORD = PASSWORD('Root@123123');"
 8temp2="ALTER USER 'root'@'localhost' PASSWORD EXPIRE NEVER;"
 9temp3="flush privileges;"
10temp4="GRANT ALL privileges ON ""*.*""TO 'top'@'%' IDENTIFIED BY 'Top@123123' WITH GRANT OPTION;"
11echo -e ${temp1}${temp2}${temp3}${temp4}
12echo '=================================================='
13echo '第一个'
14echo ${temp1}${temp2}${temp3}${temp4}${temp3}| mysql -u root --password=$defaultmysqlpwd -b --connect-expired-password
15echo ${temp1}${temp2}${temp3}${temp4}${temp3}| mysql -u root --password=$mysqlpwd -b --connect-expired-password
16echo '第二个'
17echo ${temp4}| mysql -u root --password=$mysqlpwd -b --connect-expired-password
18service mysqld restart

其它脚本

 1
 2 #创建数据库
 3#create_db_sql="create database IF NOT EXISTS ${DBNAME}"
 4#mysql -h${HOSTNAME}  -P${PORT}  -u${USERNAME} -p${PASSWORD} -e "${create_db_sql}"
 5
 6#注意：-p${PASSWORD}中间不能有空格#
 7
 8#创建表
 9#create_table_sql="create table IF NOT EXISTS ${TABLENAME} (  name varchar(20), id int(11) default 0 )"
10#mysql -h${HOSTNAME}  -P${PORT}  -u${USERNAME} -p${PASSWORD}  -D ${DBNAME} -e "${create_db_sql}"
11
12#插入数据
13#insert_sql="insert into ${TABLENAME} values('billchen',2)"
14#mysql -h${HOSTNAME}  -P${PORT}  -u${USERNAME} -p${PASSWORD} ${DBNAME} -e  "${insert_sql}"
15
16#查询
17#select_sql="select * from ${TABLENAME}"
18#mysql -h${HOSTNAME}  -P${PORT}  -u${USERNAME} -p${PASSWORD} ${DBNAME} -e "${select_sql}"
19
20#更新数据
21createTime: 2022-01-05T14:40:06+08:00
22updateTime: 2022-01-05T14:40:06+08:00
23createTime: 2022-01-05T14:40:06+08:00
24updateTime: 2022-01-05T14:40:06+08:00
25#mysql -h${HOSTNAME}  -P${PORT}  -u${USERNAME} -p${PASSWORD} ${DBNAME} -e  "${select_sql}"
26
27#删除数据
28#delete_sql="delete from ${TABLENAME}"
29#mysql -h${HOSTNAME}  -P${PORT}  -u${USERNAME} -p${PASSWORD} ${DBNAME} -e  "${delete_sql}"
30#mysql -h${HOSTNAME}  -P${PORT}  -u${USERNAME} -p${PASSWORD} ${DBNAME} -e  "${select_sql}"
31