-3

Here is what /var/log/mysql/error.log says

[ERROR] /usr/sbin/mysqld: unknown option '--mysql/'

Full log: http://pastebin.com/hhUY2LXi

Mysql config: http://pastebin.com/cNMux19T

Command to start mysql: sudo service mysql start

Any ideas or debugging steps will realy help

3
  • What is the command you are using to start the service. What does the config file look like?
    – user9517
    Dec 6, 2015 at 15:32
  • sudo service mysql start is the command.
    – paptom
    Dec 6, 2015 at 15:37
  • And here is the mysql config. Also added in the description pastebin.com/cNMux19T
    – paptom
    Dec 6, 2015 at 15:45

3 Answers 3

3

You have an error (new line) line 108 of your configuration :

# chroot = /var/lib/
mysql/
3
  • Changed that, didn't help :/
    – paptom
    Dec 6, 2015 at 17:36
  • 1
    Changed how? Can you paste new error.log? You must be getting a new error.
    – HTTP500
    Dec 6, 2015 at 17:43
  • Despite the OPs protestations this is the solution to the posted question.
    – user9517
    Dec 8, 2015 at 8:44
2

Try to comment line 108

# Read the manual, too, if you want chroot!
# chroot = /var/lib/
mysql/

To become like that

# Read the manual, too, if you want chroot!
# chroot = /var/lib/
# mysql/

then restart mysql otherwise use the full mysql url

/var/lib/mysql

With out the end slash

2
  • Changed that, didn't help :/
    – paptom
    Dec 6, 2015 at 17:36
  • Despite the OPs protestations this is the solution to the posted question.
    – user9517
    Dec 8, 2015 at 8:44
-5

So it turns out that there was an long running process which filled up ram cache. I ran sudo sysctl -w vm.drop_caches=3 and i was able to restart mysql

4
  • 2
    I'm really struggling to see how this solved the problem. Cache will be freed when a program requests memory. It really shouldn't be an issue and you should almost never need to drop caches outside a testing environement.
    – user9517
    Dec 8, 2015 at 8:29
  • 1
    NOOOOOO, don't do this! Whatever was wrong with your system, this did not fix it.
    – womble
    Dec 8, 2015 at 9:52
  • So mysql stopped for a reason (probably a background dump got stuck) and i couldn't restart it due to lack of memory. Still doesn't make sense?
    – paptom
    Dec 8, 2015 at 19:42
  • Nope, you couldn't start it initially because (as the two answers above) say your my.cnf was borked. After that you never presented any evidence that the original problem was not solved.
    – user9517
    Dec 8, 2015 at 23:29

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .