database - Resetting a MySQL admin password? (Other solutions don't seem to be working) -


sorry such basic question, i'm struggling of solutions i've found online working. i've managed lose mysql password local machine , i'm locked out

i've tried resetting using command:

mysqladmin password example_new_password

but gives me error saying "mysqladmin: connect server @ 'localhost' failed. error: 'access denied user 'root'@'localhost' (using password: no)'

and i've tried following these instructions (https://goo.gl/lvv1jo), when there's no .pid file or named 'mysqld' in /var/lib/mysql couldn't there

can point me in right direction? i'm little lost @ moment

you can try:

sudo dpkg-reconfigure mysql-server-n.n 

where n.n mysql version.

if doesn't work, have here: https://help.ubuntu.com/community/mysqlpasswordreset


Comments