Question

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

Posted September 24, 2015 33.6k views
Ubuntu MySQL DigitalOcean

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
4 comments

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.

3 answers

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

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

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

Submit an Answer