linux下mysql安装及操作指令

rpm方式安装mysql
msyql官网下载mysql rpm类型文件全家桶，选个目录楞里头
执行下面的脚本

#!/bin/bash

echo "开始安装mysql......"

if [ ! -d "rpm" ];then
    echo "正在解压tar包"
    mkdir rpm
    tar -xvf mysql*.tar -C rpm/
fi
cd rpm/

echo "正在安装依赖"
yum -y install numactl perl libaio net-tools

echo "正在安装相关rpm包"
rpm -ich mysql-community-common-5.7.29-1.el7.x86_64.rpm &&
rpm -ivh mysql-community-libs-5.7.29-1.el7.x86_64.rpm &&
rpm -ivh mysql-community-client-5.7.29-1.el7.x86_64.rpm &&
rpm -ivh mysql-community-server-5.7.29-1.el7.x86_64.rpm &&
mysqld --initialize

cd ..

echo "正在覆盖配置文件"
if [ -f "my.conf" ];then
    cp -rf my.cnf /etc
    sed -i "s|"'${username}'"|$1|g" /etc/my.cnf
fi


echo "正在设置文件夹权限"
chown mysql:mysql /var/lib/mysql -R

echo "正在设置开机启动"
systemctl enable mysqld

echo "正在启动mysql"
systemctl start mysqld.service

echo "结束安装mysql......"

//安装完成后启动mysql
systemctl start mysqld.service

//先修改/etc/mysql/my.ini文件,在文件最后加上(skip_grant_tables)，mysql可以免登录。
//修改mysql root用户密码
update mysql.user set authentication_string=password(‘password’) where user=‘root’;

//root用户登录后创建新用户
create user 'test'@'localhost' identified by 'password';
//修改用户密码
ALTER USER 'test'@'localhost' IDENTIFIED BY 'password';
SET PASSWORD = PASSWORD('password');
//给用户分配所有权限
grant all privileges on `test`.* to 'test'@'localhost';
GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' IDENTIFIED BY 'password' WITH GRANT OPTION;
//创建数据库
CREATE DATABASE test

//linux下mysql备份库

1普通备份
mysqldump --default-character-set=utf8  -u username -p password  --single-transaction  test> /data/mysql/mysqlDbBack/test.sql
2.按日期备份
TIME=$(date "+%Y-%m-%d_%H%M%S")
mkdir /data/mysql/mysqlDbBack/$TIME/
mysqldump --default-character-set=utf8 -u username -p password  --single-transaction  test > /data/mysql/mysqlDbBack/$TIME/test.sql_$TIME
//linux下mysql备份表
mysqldump --default-character-set=utf8  -u username -p password  --single-transaction  test(库名) test(表名) > /data/mysql/mysqlDbBack/test.sql
//linux下mysql恢复库
mysql -u username -p password sunriver_lims_prod < /data/mysql/mysqlDbBack/$TIME/test.sql_$TIME