MySQL and MariaDB fail to start due to error in mysqld_safe

[stefanvignir@…]

This affects mysql55-server, mysql56 and mariadb-server.

When starting MySQL or MariaDB using 'sudo cd /opt/local ; /opt/local/lib/mysql56/bin/mysqld_safe &', what gets returned is:

130821 19:33:51 mysqld_safe Logging to '/opt/local/var/db/mysql56/Stefans-MacBook-Pro.local.err'.
touch: /opt/local/var/db/mysql56/Stefans-MacBook-Pro.local.err: Permission denied
chmod: /opt/local/var/db/mysql56/Stefans-MacBook-Pro.local.err: No such file or directory
/opt/local/lib/mysql56/bin/mysqld_safe: line 726: syntax error near unexpected token `then'
/opt/local/lib/mysql56/bin/mysqld_safe: line 726: `    then    # The pid contains a mysqld process'

Lines 725-729 in /opt/local/lib/mysql56/bin/mysqld_safe seem to have an obvious syntax error:

    if 
    then    # The pid contains a mysqld process
      log_error "A mysqld process already exists"
      exit 1
    fi

[larryv (Lawrence Velázquez)]

Duplicate of #40040.

[eric.lebigot@…]

Cc Me!

[eric.lebigot@…]

Cc Me!

[cgrandval@…]

Hi, anyone knows if there will be any change ? I've installed mysql 5.6 (4 days ago) and when i wanna start MySQL with mysqld_safe, i have the same error. Thanks,