Report this

What is the reason for this report?

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

Posted on September 24, 2015
Nay

By Nay

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


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!

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.

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

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

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

The developer cloud

Scale up as you grow — whether you're running one virtual machine or ten thousand.

Get started for free

Sign up and get $200 in credit for your first 60 days with DigitalOcean.*

*This promotional offer applies to new accounts only.