摘要:
新建 mysql_autobackup.sh脚本,内容如下 #!/bin/bash /usr/bin/mysqldump -uusrname -ppassword databasename > /root/mysql_backup/mysql_$(date +%Y%m%d_%H%M%S).sql f 阅读全文
摘要:
先用root登录运行如下代码 create user 'usrname'@'%' IDENTIFIED by 'password'; flush privileges; grant select, insert, update [DELETE]on databasename.* to usrname 阅读全文