Develop a scheduled task today and add it to the cron list. However, there is a problem. You need to enter the Database Password during script execution:
Mysql-u root-p <SQLuse db; set names utf8; 'cat task. SQL 'SQL
After running the above Code, a message is displayed:
Enter password:
After searching, we found that CT can help us complete this task:
Save the above Code to a file: db. sh and write the following code:
#! /Usr/bin/login CT-fspawn db. shexpect "Enter password:" send -- "password \ n" interact
Then, we will enter the database interaction interface.
The first line indicates the program to run the script;
The second line focuses on starting a program we want to execute under Objective CT;
The third line is also the focus. We need to tell secondary CT to help us complete interaction when information appears;
The fourth line is the content to be sent when the password is prompted;
The fifth line means to maintain interaction and do not exit. If this statement is not provided, the script will exit immediately after successfully logging on to the database.