Question

mysqld_safe Can't log to error log and syslog at the same time

Hello, I forgot my MySQL password, and following these steps to reset it… How To Import and Export Databases and Reset a Root Password in MySQL

When I type that command…

# mysqld_safe --skip-grant-tables

I get that message… How I fix it?

150924 14:01:12 mysqld_safe Can't log to error log and syslog at the same time.  Remove all --log-error configuration options for --syslog to take effect.
150924 14:01:12 mysqld_safe Logging to '/var/log/mysql/error.log'.
150924 14:01:12 mysqld_safe A mysqld process already exists
Show comments
Submit an answer

This textbox defaults to using Markdown to format your answer.

You can type !ref in this text area to quickly search our full set of tutorials, documentation & marketplace offerings and insert the link!

Sign In or Sign Up to Answer

These answers are provided by our Community. If you find them useful, show some love by clicking the heart. If you run into issues leave a comment, or add your own answer to help others.

abhisage • April 16, 2017

To tackle the problem: ERROR 1045(28000) : Access denied for user ‘root@localhost’ (using password: no ) Use command: sudo dpkg-reconfigure mysql-server-5.5

bobbao • February 20, 2017

I just signed up maybe you can change the apparmor or selinux to solve it . I met this issue ,and hope it’s useful ^_^

Tom Glod • February 7, 2016

Thanks for the solution…wasted a few hours on this today! grrr