start mysql with --skip-slave-start

Question

I need to start mysql server with '--skip-slave-start' option, as stated in tutorials/docs. How can I achive that? trying the next commands does not work: ``` service mysql start --skip-slave-start ``` start: invalid option: --skip-slave-start ``` mysql>SLAVE START --skip-slave-start; ``` ERROR 1064 (42000): You have an error in your SQL syntax;

Accepted Answer

You're getting a syntax error with this:

```
mysql>SLAVE START --skip-slave-start;
```

because that's not a valid statement.

This here

```
service mysql start --skip-slave-start
```

invokes another script calling mysqld. Either you adjust the script, or easiest would be you put the option in your config file (most probably under `/etc/my.conf`

like this

```
[mysqld]
skip-slave-start
```

start mysql with --skip-slave-start

Solution

Problem