mysqlmysql-5.1

mysql acces denied to user in localhost


I kind of locked myself out of mysql, don't know or remember how.
I have tried different things but no luck so far.
I have the root user who has all the privileges with the host localhost.
Like shown in the screenshot : https://i.sstatic.net/zKFYF.jpg

When trying to connect from the computer where mysql is installed I get the message
Access denied for user root@localhost
Like shown in the screenshot : https://i.sstatic.net/Dt7S4.jpg

100% sure I have the right password, so It's not a password issue.

Any help on what could be the issue??
Thanks!


Solution

  • Try mysql -h localhost -u root -p.