-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

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.