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.
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
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
Click below to sign up and get $100 of credit to try our products over 60 days!
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.
Hi!
But the firts command I type is:
And show me the OK message saying stopped… Afterward I type:
And get that error message…
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 usemysqld_safe --skip-grant-tables
.Also, mind you pasting logs here from
/var/log/mysql/error.log
?