bash script: auto-give-password
I've installed zoneminder 1.30 on centos 6 and the mysql setup needs several commands run to set up the database. I'm trying to write a bash script that automates this setup process but it always stops at this command:
Code:
mysql -uroot -p < /usr/share/zoneminder/db/zm_create.sql
and always asks for the password. I've tried loads of different things to automate the password but nothing works. This is my latest try:
Code:
#!/bin/bash
service mysqld start <--this works fine
/usr/bin/mysql_secure_installation <<EOF
y
secret
secret
y
n
y
y
EOF <---- this section works fine too
expect -c "
spawn /usr/bin/mysql -uroot -p < /usr/share/zoneminder/db/zm_create.sql
expect -nocase \"password:\" {send \"secret\r\"; interact}
" <--- this stops with command error
I've also tried:
Code:
mysql -uroot -p < /usr/share/zoneminder/db/zm_create.sql <<EOF
secret
EOF <--- this script stops and asks for password
what do I need to do to get this script to give the password automatically? |
