linux備份和mysql登陸自動輸入密碼

標籤：linux備份和mysql登陸自動輸入密碼

1.mysql自動登陸，系統自己輸入密碼

(1)安裝億需要的軟體

[[email protected] ~]# yum install expect-*

(2)在指令碼中寫入命令

#!/usr/bin/expect -f             --使用expect軟體
set timeout 2                   --輸出密碼時延時2秒
spawn mysql -u root -p           --mysql登陸命令
expect "system"               --mysql的密碼
send "system\n"                 --mysql的密碼
interact                           --進入mysql

(3)測試

[[email protected] ~]# ./1.sh
spawn mysql -u root -p
Enter password:
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 23
Server version: 5.1.47-log Source distribution

Copyright (c) 2000, 2010, Oracle and/or its affiliates. All rights reserved.
This software comes with ABSOLUTELY NO WARRANTY. This is free software,
and you are welcome to modify and redistribute it under the GPL v2 license

Type ‘help;‘ or ‘\h‘ for help. Type ‘\c‘ to clear the current input statement.

mysql>

2.遠程登陸

 

 

本文出自 “一起走過的日子” 部落格，謝絕轉載！