wgbaowei的专栏

#!/bin/sh # mysql_backup.sh: backup mysql databases and keep newest 5 days backup.     db_user="root"     db_passwd="imsuser"     db_host="localhost"     db_name="ims"  

二：赋予脚步可执行权限 chmod +x mysql_backup.sh 三：添加定时执行计划 vi /etc/crontab 添加：00 5 * * * root /backup/mysql_backup.sh 每日5点钟备份一次数据库 四：补充 linux 开机自动启动  cd /usr/bin  ln -s -f /usr/local/jdk1.7.0

#!/bin/bash #PATH=/bin:/sbin:/usr/bin:/usr/sbin:/usr/local/bin:/usr/local/sbin:~/bin #export PATH #export LANG=en_US.UTF-8 password="/;p0.lo9" savedir=/usr/backup cd "$savedir" time="$(date +"%

GRANT ALL ON *.* TO test@'192.168.10.169' IDENTIFIED BY ’test123' WITH GRANT OPTION IP为：192.168.10.169 用户名：test 密码：test123

启动 mysql 服务的时候报如下错误： Fatal error: Can't open and lock privilege tables: Table 'mysql.host' doesn't exist 解决方法： mysql_install_db --user=mysql  初始化数据库即可

一、插入数据乱码：Incorrect string value: '\xE6\x9B\xB9\xE5\x86\xAC...' for column 'realname' at r 1、alter database team_club character set utf8; 2、alter table activity convert to character set utf8 3、al