New on LowEndTalk? Please Register and read our Community Rules.
All new Registrations are manually reviewed and approved, so a short delay after registration may occur before your account becomes active.
All new Registrations are manually reviewed and approved, so a short delay after registration may occur before your account becomes active.
Resetting mysql password woes
This is what I usually used to do for resetting a forgotten mysql root password: pastebin.com/ZeXKezXU
Unfortunately, as you can see above, the reset password is not being authenticated. Any idea why? This is debian jessie on an ovh ks1.
Comments
this works for me:
sudo /usr/sbin/mysqld --skip-grant-tables --skip-networking & mysql -u root FLUSH PRIVILEGES; SET PASSWORD FOR root@'localhost' = PASSWORD('newpassword');
taken from https://help.ubuntu.com/community/MysqlPasswordReset
That does temporarily login as root. However I'm unable to change the root password after that.
Accidentally posted early, updated.
You might be able to reset the password with dpkg-reconfigure mysql-server or mysql-server-5.5, depending on the package name.
Did you try:
?
I did. Same effect (password is not being updated).
It accepted the password, but again on logging in, I again got
ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: YES)
by any chance could this be related to appmon on Debian/Ubuntu or selinux ? I know I have had a similar problem updating mysql file with appmon running
I dont use appmon.
Do you have localhost mapped to 127.0.0x on host file?
Try ping localhost
Maybe try using 127.0.0.1 instead localhost?
After login, as you said above, execute mysql status look at current user blablabla@xxxx
I do.
Did you mean the
SHOW STATUS
command?Opps yes, I'm on mobile so not really easy to typing
@localhost or @127.0.0.1 there?
I've that problem some times ago, because localhost not mapped to 127.0.0.1
SHOW STATUS
lists a lot of rows. I dont think this is what you were expecting:opps sorry, after login to
mysql
enterstatus
Hmm.. so my issue is the same as yours?
cloudflare f.
check this http://pastebin.com/raw/m7TV8DEQ
Does your
debian-sys-maint
account still work?The account still works, but changing root password does not work. At the moment, I make do by creating a seperate user, and granting all privileges to that one.
this may be a stupid question... are you logging in to the correct database? are you possibly logging into a backup or old database?
It's the correct database
nvm i have a bad sense of humor.
Having fun doing some necroposting i see.