Server info I'm running an Ubuntu 14.04 server with apache and some other goodies installed.
Problem I previously had a plesk trial installed but it expired so I uninstalled it. Ever since then mysql has been messed up. The issue I'm having is that I cannot login to the root user. I think that I may have accidentally skipped the part where I add the password for that user.
Things I've Tried From what I understand, I need to stop mysql and start it in safe mode so I do not need to enter a password.
I have used set password for root@localhost When logged in with the root user in mysql safe mode I tried set password with no user specified, thinking this would edit the current user's password. After I change the password and restart the mysql server it seems that nothing has been changed.
I have also tried logging into phpmyadmin in safemode and creating another user with all privileges. When safe mode is disabled, these changes are non-existant.
All of my attempts have been made from a remote location.
At this point in time I'm starting to think that I should just reinstall mysql completely so that it can possibly be reset. Should I just restart from scratch? Or shall I give it another try? I think that if I cannot get it to work I will just wipe the server and start again with an open source control panel.