title: “Mysql”
createTime: 2022-01-05T14:40:06+08:00
updateTime: 2022-01-05T14:40:06+08:00
draft: false
author: “name”
tags: [“mysql”]
categories: [“install”]
description: “测试的”
mysql 相关
安装 mysql 相关
-
查看mariadb数据库 rpm -qa | grep mariadb
-
卸载数据库:yum -y remove mari*
-
删除数据库文件: rm -rf /var/lib/mysql/*
-
根据某某安装
- 根据rpm安装
rpm -ivh mysql-community-common-5.7.24-1.el7.x86_64.rpm rpm -ivh mysql-community-libs-5.7.24-1.el7.x86_64.rpm rpm -ivh mysql-community-client-5.7.24-1.el7.x86_64.rpm rpm -ivh mysql-community-server-5.7.24-1.el7.x86_64.rpm rpm -ivh mysql-community-devel-5.7.24-1.el7.x86_64.rpm rpm -ivh mysql-community-libs-compat-5.7.24-1.el7.x86_64.rpm
- yum 安装
- wget -i -c http://dev.mysql.com/get/mysql57-community-release-el7-10.noarch.rpm
- yum -y install mysql57-community-release-el7-10.noarch.rpm
- yum -y install mysql-community-server
-
启动 mysql
- service mysqld start
-
获取初始化密码
- grep ‘temporary password’ /var/log/mysqld.log
-
登陆
- mysql -u root -p
-
修改root的密码
- SET PASSWORD = PASSWORD(‘Root@123123’);
- ALTER USER ‘root’@‘localhost’ PASSWORD EXPIRE NEVER;
- flush privileges;
-
创建一个账号 并且给权限 (给用户top 密码 Top@123123 )
- GRANT ALL PRIVILEGES ON . TO ‘top’@‘%’ IDENTIFIED BY ‘Top@123123’ WITH GRANT OPTION;
安装脚本(前提有本地yum 源)
#!/bin/bash
PATH=/bin:/sbin:/usr/bin:/usr/sbin:/opt/bin:/opt/sbin:~/bin
export PATH
# Check if user is root
if [ $(id -u) != "0" ]; then
echo "Error: You must be root to run this script, please use root to install"
exit 1
fi
clear
#HOSTNAME="192.168.111.84" #数据库信息
#PORT="3306"
#USERNAME="root"
#PASSWORD=""
#DBNAME="test_db_test" #数据库名称
#TABLENAME="test_table_test" #数据库中表的名称
# 查看mariadb数据库:
rpm -qa | grep mariadb
#卸载数据库:
yum -y remove mari*
#删除数据库文件:
rm -rf /var/lib/mysql/*
echo '开始安装mysql'
yum install -y mysql-community-server.x86_64
echo '安装完成mysql'
service mysqld start
ss
修改root密码 且 创建账户 (前提 mysql 启动)
echo '启动完成'
#grep 'temporary password' /var/log/mysqld.log
defaultmysqlpwd=`grep 'temporary password' /var/log/mysqld.log | awk -F"root@localhost: " '{ print $2}' `
echo $defaultmysqlpwd
mysqlpwd="Root@123123"
temp1="SET PASSWORD = PASSWORD('Root@123123');"
temp2="ALTER USER 'root'@'localhost' PASSWORD EXPIRE NEVER;"
temp3="flush privileges;"
temp4="GRANT ALL privileges ON ""*.*""TO 'top'@'%' IDENTIFIED BY 'Top@123123' WITH GRANT OPTION;"
echo -e ${temp1}${temp2}${temp3}${temp4}
echo '=================================================='
echo '第一个'
echo ${temp1}${temp2}${temp3}${temp4}${temp3}| mysql -u root --password=$defaultmysqlpwd -b --connect-expired-password
echo ${temp1}${temp2}${temp3}${temp4}${temp3}| mysql -u root --password=$mysqlpwd -b --connect-expired-password
echo '第二个'
echo ${temp4}| mysql -u root --password=$mysqlpwd -b --connect-expired-password
service mysqld restart
其它脚本
#创建数据库
#create_db_sql="create database IF NOT EXISTS ${DBNAME}"
#mysql -h${HOSTNAME} -P${PORT} -u${USERNAME} -p${PASSWORD} -e "${create_db_sql}"
#注意:-p${PASSWORD}中间不能有空格#
#创建表
#create_table_sql="create table IF NOT EXISTS ${TABLENAME} ( name varchar(20), id int(11) default 0 )"
#mysql -h${HOSTNAME} -P${PORT} -u${USERNAME} -p${PASSWORD} -D ${DBNAME} -e "${create_db_sql}"
#插入数据
#insert_sql="insert into ${TABLENAME} values('billchen',2)"
#mysql -h${HOSTNAME} -P${PORT} -u${USERNAME} -p${PASSWORD} ${DBNAME} -e "${insert_sql}"
#查询
#select_sql="select * from ${TABLENAME}"
#mysql -h${HOSTNAME} -P${PORT} -u${USERNAME} -p${PASSWORD} ${DBNAME} -e "${select_sql}"
#更新数据
createTime: 2022-01-05T14:40:06+08:00
updateTime: 2022-01-05T14:40:06+08:00
createTime: 2022-01-05T14:40:06+08:00
updateTime: 2022-01-05T14:40:06+08:00
#mysql -h${HOSTNAME} -P${PORT} -u${USERNAME} -p${PASSWORD} ${DBNAME} -e "${select_sql}"
#删除数据
#delete_sql="delete from ${TABLENAME}"
#mysql -h${HOSTNAME} -P${PORT} -u${USERNAME} -p${PASSWORD} ${DBNAME} -e "${delete_sql}"
#mysql -h${HOSTNAME} -P${PORT} -u${USERNAME} -p${PASSWORD} ${DBNAME} -e "${select_sql}"