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

Posted September 24, 2015
DigitalOcean MySQL Ubuntu

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

Nay

ekekis • October 29, 2015

I had this problem in ubuntu installation with nginx, mysql and php, did not know what the password, and managed to solve reconfiguring.

sudo dpkg-reconfigure mysql-server-5.5

source: http://ubuntuforums.org/showthread.php?t=2296259

Amr Selim • September 7, 2016

Thanks a million, did not believe how easy this was.

Nay • September 24, 2015

Hi!

But the firts command I type is:

/etc/init.d/mysqld stop

And show me the OK message saying stopped… Afterward I type:

mysqld_safe --skip-grant-tables

And get that error message…

saengbok • September 24, 2015

150924 14:01:12 mysqld_safe A mysqld process already exists

It means, that MySQL daemon is still online. Use /etc/init.d/mysqld stop in order to stop the MySQL daemon, then try again to use mysqld_safe --skip-grant-tables.

Also, mind you pasting logs here from /var/log/mysql/error.log ?

Submit an 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.

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

Start Using App Platform