關閉服務器? ? sh shutdown.sh啟動服務器? ? sh startup.sh查看實時日志? tail -f ../logs/catalina.out 啟動系統(tǒng)并查看日志? ./startup.sh && tail -f ../logs/catalina.out查看運行的服務器? ps -ef|grep tomcat? ? ? ? ? ? ps -ef|grep java殺進程? kill -9 28014查看iptables? more /etc/sysconfig/iptables導出數(shù)據(jù)庫 mysqldump -uroot -proot icpip >d:\icpip.sql導入數(shù)據(jù)庫 mysql -uroot -proot -h127.0.0.1 icpipbackupfile.sql
備份MySQL數(shù)據(jù)庫為帶刪除表的格式
備份MySQL數(shù)據(jù)庫為帶刪除表的格式亏推，能夠讓該備份覆蓋已有數(shù)據(jù)庫而不需要手動刪除原有數(shù)據(jù)庫萝勤。
mysqldump -–add-drop-table -uusername -ppassword databasename > backupfile.sql
直接將MySQL數(shù)據(jù)庫壓縮備份
mysqldump -hhostname -uusername -ppassword databasename | gzip > backupfile.sql.gz
備份MySQL數(shù)據(jù)庫某個(些)表
mysqldump -hhostname -uusername -ppassword databasename specific_table1 specific_table2 > backupfile.sql
同時備份多個MySQL數(shù)據(jù)庫
mysqldump -hhostname -uusername -ppassword –databases databasename1 databasename2 databasename3 > multibackupfile.sql
僅僅備份數(shù)據(jù)庫結構
mysqldump --no-data? --databases ahqxt -uroot -pahqxt123 -h172.16.10.165 > /home/qxt/dataSh.sql ;
2增显、mysql>GRANT ALL PRIVILEGES ON *.* TO 'root'@'%'WITH GRANT OPTION
//賦予任何主機訪問數(shù)據(jù)的權限
GRANT ALL PRIVILEGES ON *.* TO? 'root'@'%' IDENTIFIED BY '123456' WITH GRANT OPTION;
例如，你想myuser使用mypassword從任何主機連接到mysql服務器的話夜惭。
GRANT ALL PRIVILEGES ON *.* TO? 'mysql'@'%' IDENTIFIED BY '123456' WITH GRANT OPTION;
GRANT ALL PRIVILEGES ON *.* TO 'mysql'@'%'IDENTIFIED BY 'os_mysql' WITH GRANT OPTION;
GRANT ALL PRIVILEGES ON *.* TO 'root'@'localhost'IDENTIFIED BY '123456' WITH GRANT OPTION;
如果你想允許用戶myuser從ip為192.168.1.6的主機連接到mysql服務器劳跃，并使用mypassword作為密碼
GRANT ALL PRIVILEGES ON *.* TO 'myuser'@'192.168.1.3'IDENTIFIED BY 'mypassword' WITH GRANT OPTION;
3癌蚁、mysql>FLUSH PRIVILEGES
//修改生效
4唱遭、mysql>EXIT
