mysql instruction waiting for somthing

English Applications
1

hi

i have this mysql instruction

mysql -u root --password= syslog< /tmp/mysql.pipe

part of this script

if  -e /tmp/mysql.pipe ]; then
     while  -e /tmp/mysql.pipe ]
     do
         mysql -u root --password= syslog< /tmp/mysql.pipe
     done
else
     mkfifo /tmp/mysql.pipe
fi

syslog is an existing database
each time it is invocated the terlinal is blocked seems wating for somthing

i have to exite it with ctrl + c to come back to # linux_test1

so

could any body tell me what is wrong this the theird day were i am looking for solution

2

You have to provide more info to get help. It looks like the script is reading SQL commands from the pipe /tmp/mysql.pipe if it exists.
So, there is some other process that writes to that pipe. So, the reading process will wait until the writing process closes the pipe.

3

The obvious error is that the password invocation is incorrect. There should be no = after password unless ‘syslog’ is the password; in that case, there should be no space after =.

Alternatively, did you use PASSWORD() to encrypt the password? In that case you need to provide the encrypted password.

If you are using plain text passwords, you are asking for problems.