脚本自动备份mysql

#!/bin/sh # Database info DB_USER="USERNAMExxx" DB_PASS="PASSWORDxxx" DB_HOST="localhost" DB_NAME="DBNAMExxx" # Others vars BIN_DIR="/usr/bin"

- 阅读全文 -

MYSQL如何用phpMyAdmin设置外部IP可以访问

MYSQL默认情况下,只允许localhost(127.0.0.1)连接,如果需要外部IP连接到MySQL,需要向MySQL数据库里的“user”表里添加相关授权。操作办法如下:1.登陆phpMyAdmin2.进入MySQL数据库,执行sql指令:GRANT ALL PRIVILEGES ON *.* TO 'username'@'IP' IDENTIFIED BY 'userpassword'

- 阅读全文 -