linux对数据库的

数据库的建立以及用户的创建（以及数据库的备份与还原脚本文件）

下载 mariadb-server和mariadb-client

yum -y install mariadb-server
yum -y install mariadb-client

开启服务

systemctl start mariadb

配置文件的设置

vi /etc/my.cnf.d/server.cnf
添加
[mysqld]
init_connect=‘SET collation_connection = utf8_unicode_ci’
init_connect=‘SET NAMES utf8’
character-set-server=utf8
collation-server=utf8_unicode_ci
skip-character-set-client-handshake

#在[client]中添加

#default-character-set=utf8
vi /etc/my.cnf.d/mysql-clients.cnf
在[mysql]中添加

default-character-set=utf8

数据库用户的设置

mysql -uroot -p921730779 进到数据库
use mysql
create user qq@localhost identified by ‘921730779’; 创建用户
grant all on . to qq@localhost identified by ‘921730779’;//赋予用户权限
select host,user,password from user; //查看用户是否创建成功
GRANT ALL PRIVILEGES ON . TO ‘wl’@’%'IDENTIFIED BY ‘123’ WITH GRANT OPTION;

数据库的备份和还原的shell脚本

#! /bin/bash
read -p "请输入你要进行的操作  1：备份数据库  2：还原数据库 3:设置自动备份任务 " num
case $num in
1)
read -p "请输入用户名:" name
read -p "请输入密码:" password
read -p "请输入数据库名称:" dbname
echo "现在进行数据库的备份"
mysqldump -u$name -p$password $dbname > /root/dump/db1.sql
if [ $? -eq 0 ];then
echo "备份成功"
else
echo "备份失败"
fi

;;
2)
read -p "请输入用户名:" name
read -p "请输入密码:" password
read -p "请输入数据库名称:" dbname
echo "现在进行数据库的还原"
mysql -u$name -p$password $dbname < /root/dump/db1.sql
if [ $? -eq 0 ];then
echo "还原成功"
else
echo "还原失败"
fi
;;

3)
read -p "请输入用户名:" name
read -p "请输入密码:" password
read -p "请输入数据库名称:" dbname
read -p "请输入自动化备份的小时：" hour
read -p "请输入自动化备份的分钟数: " min
echo "现在进行任务的建立"
mysqldump -u$name -p$password $dbname > /root/dump/db1.sql 
echo "$min $hour * * * mysqldump -u$name -p$password $dbname > /root/dump/db2.sql" >job.txt
crontab job.txt
crontab -l
if [ $? -eq 0 ];then
echo "设置成功"
else
echo "设置失败"
fi

;;

*)
echo "您所输入的内容有误"
esac