How to stop background process from running shell script

Question

I'm trying to run mysqld in the background to execute some commands using the mysql client, but when I switch the process to the foreground, my script stops running. This is the script I use:

set -m
daemon="/usr/bin/mysqld --user=mysql --console --skip-name-resolve --skip-networking=0 $@"
$daemon &
exec echo "Test"
exec fg %1

I am not a shell script programming expert, I looked on some websites and found this method of executing commands.

Answer 1

No. The script stops after exec echo "Test". exec Replace the current process (i.e. shell script) with the following command. You can verify by:

daemon="/usr/bin/mysqld --user=mysql --console --skip-name-resolve --skip-networking=0 $@"
$daemon &
exec echo "Test"
echo "Second Test"
exec fg %1

The solution is simple: don't use exec.

BTW: It's not clear why you want to use fg in a shell script. In an interactive shell, fg has no function only within scripts.