apache2 - Access denied when trying to re-install lamp - Ask Ubuntu


i'm trying install lamp on ubuntu 16.04. had installed, accidentally locked myself out of lamp trying phpmyadmin working, access denied user 'root'@'localhost' whatever try.

i thought easiest solution uninstall packages installed lamp working. used sudo apt-get purge uninstall packages installed. i'm installing packages again same error when trying install mysql. try: sudo mysql_secure_installation , asks me password root. tried leaving empty, giving passwords think set root, returns access denied message.

trying mysql mysql -u root -p returns access denied message, tried solution creating file create user 'root'@'localhost' identified '<password>'; , running sudo mysqld_safe --init-file=<path_to_file> still receive access denied messages.

i'm thinking there file somewhere information, maybe password, needs. tried lot of other solutions nothing seems work.

edit: investigated further, , tried starting mysql service --skip-grant-tables flag stop checking user privs. when run mysql -u root still tells me error 1045 (28000): access denied user 'root'@'localhost' (using password: no). think problem hasn't password, else.

i managed fix killing mysql processes running: ps aux | grep mysql lists processes , killing them sudo kill -9 [pid]. allowed me start mysqld_safe process --skip-grant-tables flag , allowed me mysql mysql -u root. following further reset password root: https://help.ubuntu.com/community/mysqlpasswordreset

also password column has been changed authentication_string in user table in mysql_server 5.7 (latest version of now).

after doing got installed , can access phpmyadmin now!


Comments

Post a Comment

Popular posts from this blog

download - Firefox cannot save files (most of the time), how to solve? - Super User

this not full duplicate of this question or this question , though base question same. however, questions have no answers. for on half year have problems downloading files firefox. when click on download link, download dialog opened asking me do, save or open it. immediately, there error/warning pop-up (twice, can see 1 @ first) ok button. looks this message : "c:\users\%user%\appdata\local\temp\wbbdv9k8.zip.part not saved because source file not read. try again later or contact server administrator." replace '%user%' name of user trying download. after closing pop-up, download dialog disappears , have minimize firefox , open again, see other pop-up. downloading exact same file internet explorer work, not desired. i tried solutions here . tried solutions here . tried disabling extensions. tried fixing permissions on temp folder. tried making files , folder in profile directory non-readonly. tried running firefox administrator. tried ...
Read more

windows - "-2146893807 NTE_NOT_FOUND" when repair certificate store - Super User

i try repair certificate store in windows 10 doing c:\windows\system32>certutil -store -user ‎330000019dba8d5dddb98062a900000000019d "personal" certutil: -store command failed: 0x80090011 (-2146893807 nte_not_found) certutil: object not found. i have double check mmc, certificate details serial number of certificate. still fail repair certificate store. can please help? i getting same error when trying export pfx. turns out had export c:\cert.pfx instead of cert.pfx (it trying export file cert store ( cert:\localmachine\my ).
Read more