剛剛不小心誤刪root…真是悲劇

1.關閉服務
#/etc/init.d/mysql stop

2.安全模式啟動，不檢查權限
#mysqld_safe –-skip-grant-tables &

3.進入mysql指令
#mysql

4.選擇mysql資料庫
mysql> use mysql

5.加入名為root的user
mysql> insert into user set user=’root’;

6.更新密碼
mysql> update user set password=password(‘123456′) where user=’root’;

7.更新權限設定
mysql> update user set Host=’localhost’,select_priv=’y’, insert_priv=’y’,update_priv=’y’,
Alter_priv=’y’,delete_priv=’y’,create_priv=’y’,drop_priv=’y’,reload_priv=’y’,shutdown_priv=’y’,
Process_priv=’y’,file_priv=’y’,grant_priv=’y’,References_priv=’y’,index_priv=’y’,create_user_priv=’y’,
show_db_priv=’y’,super_priv=’y’,create_tmp_table_priv=’y’,Lock_tables_priv=’y’,execute_priv=’y’,
repl_slave_priv=’y’,repl_client_priv=’y’,create_view_priv=’y’,show_view_priv=’y’,create_routine_priv=’y’,
alter_routine_priv=’y’,create_user_priv=’y’,Event_priv=’y’,Trigger_priv=’y’ where user=’root’;

8.套用新權限
mysql> flush privileges;

9.離開mysql
mysql> quit

10.強制關閉mysql服務
#killall mysqld

11.正常啟動mysql
#/etc/init.d/mysql start

1.先安裝cifs-utils,smbfs掛載cifs或smbfs
# apt-get install cifs-utils smbfs

2.測試掛載異地資料夾
# mount-t cifs //[ip]/[remote_folder] /backup -o username=user,password=pass
# mount -t smbfs //[ip]/[remote_folder] /backup -o username=user,password=pass

#df -h 查看掛載情況 //*.*.*.*/backup 1.9T 32G 1.8T 2% /backup

3.寫備份script
# vi /opt/autobackup.sh

#!/bin/sh
mount -t smbfs //*.*.*.*/backup /backup -o username=user,password=*****
today=`/bin/date +%Y%m%d`
mkdir -p /backup/$today
mysqldump -u root –password=***** –all-databases –lock-tables=0 > /backup/$today/all_databases.sql
rsync -av /var/www /backup/www_backups

 

#chmod 700 /opt/autobackup.sh
修改成可執行

4.測試執行備份
# /opt/autobackup.sh

5.加入自動排程
# crontab -e

30 23 * * * /opt/autobackup.sh

每天23點30分執行一次備份

以上mysql每天的備份都存在該天的資料夾

www為差異備份，鏡像至backup_www

Install Standard Java runtime environment
# apt-get install default-jre

List of jre:
# apt-cache search jre
default-jre – Standard Java or Java compatible Runtime
default-jre-headless – Standard Java or Java compatible Runtime (headless)
docbook-xsl – stylesheets for processing DocBook XML to various output formats
gcj-4.6-jre – Java runtime environment using GIJ/classpath
gcj-4.6-jre-headless – Java runtime environment using GIJ/classpath (headless version)
gcj-4.6-jre-lib – Java runtime library for use with gcj (jar files)
gcj-jre – Java runtime environment using GIJ/classpath
gcj-jre-headless – Java runtime environment using GIJ/classpath (headless version)
icedtea-6-jre-cacao – Alternative JVM for OpenJDK, using Cacao
icedtea-6-jre-jamvm – Alternative JVM for OpenJDK, using JamVM
libreoffice – office productivity suite
openjdk-6-jre – OpenJDK Java runtime, using Hotspot JIT
openjdk-6-jre-headless – OpenJDK Java runtime, using Hotspot JIT (headless)
openjdk-6-jre-lib – OpenJDK Java runtime (architecture independent libraries)
icedtea-7-jre-cacao – Alternative JVM for OpenJDK, using Cacao
icedtea-7-jre-jamvm – Alternative JVM for OpenJDK, using JamVM
libanimal-sniffer-java – JDK/API verification tools
libcommons-exec-java – a library to reliably execute external processes from within the JVM
libgeronimo-osgi-support-java – Java libraries providing OSGi lookup support for Geronimo projects
libgeronimo-osgi-support-java-doc – Documentation for libgeronimo-osgi-support-java
libjrexx-java – automaton based regular expression API for java
openjdk-6-jre-zero – Alternative JVM for OpenJDK, using Zero/Shark
openjdk-7-jre – OpenJDK Java runtime, using Hotspot JIT
openjdk-7-jre-headless – OpenJDK Java runtime, using Hotspot JIT (headless)
openjdk-7-jre-lib – OpenJDK Java runtime (architecture independent libraries)
openjdk-7-jre-zero – Alternative JVM for OpenJDK, using Zero/Shark

• apt-get install mysql-server apache2 php5 libapache2-mod-auth-mysql php5-mysql phpmyadmin

• apt-get install mysql-server

• apt-get install apache2

• apt-get install php5

• apt-get install libapache2-mod-auth-mysql

• apt-get install php5-mysql

• apt-get install phpmyadmin