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
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.
It means, that MySQL daemon is still online. Use
/etc/init.d/mysqld stopin order to stop the MySQL daemon, then try again to usemysqld_safe --skip-grant-tables.Also, mind you pasting logs here from
/var/log/mysql/error.log?Hi!
But the firts command I type is:
And show me the OK message saying stopped…
Afterward I type:
And get that error message…
I had this problem in ubuntu installation with nginx, mysql and php, did not know what the password, and managed to solve reconfiguring.
source: http://ubuntuforums.org/showthread.php?t=2296259
Thanks a million, did not believe how easy this was.