mysql8: mysqld_safe: line 810: syntax error near unexpected token `then'

[murrayE]

After installing mysql8-server, I tried running it with command:

sudo /opt/local/share/mysql8/support-files/mysql.server start

After the prompt for, and giving, my password, the following happens:

Starting MySQL
./opt/local/bin/mysqld_safe: line 810: syntax error near unexpected token `then'
/opt/local/bin/mysqld_safe: line 810: `    then    # The pid contains a mysqld process'
 ERROR! The server quit without updating PID file (/opt/local/var/run/mysqld/mysqld.pid).

[ryandesign (Ryan Carsten Schmidt)]

I agree, there is a syntax error in mysqld_safe. Line 802 through 812 are:

# If there exists an old pid file, check if the daemon is already running
# Note: The switches to 'ps' may depend on your operating system
if test -f "$pid_file"
then
  PID=`cat "$pid_file"`
  if kill -0 $PID > /dev/null 2> /dev/null
  then
    if 
    then    # The pid contains a mysqld process
      log_error "A mysqld process already exists"
      exit 1

There should be something after that if on line 809.

In the original source code, those lines in scripts/mysqld_safe.sh are:

# If there exists an old pid file, check if the daemon is already running
# Note: The switches to 'ps' may depend on your operating system
if test -f "$pid_file"
then
  PID=`cat "$pid_file"`
  if @CHECK_PID@
  then
    if @FIND_PROC@
    then    # The pid contains a mysqld process
      log_error "A mysqld process already exists"
      exit 1

So evidently the placeholder @FIND_PROC@ is getting replaced with the empty string, and should be getting replaced with something else instead.

[herbygillot (Herby Gillot)]

In b2c09f817a34bcdd85b3c17eb9e505b9c273c188/macports-ports (master):

mysql8: update to 8.0.23

• Fixes: #61267