mysql secure installation access denied error for root user

Installed a brand new instance of mysql server on ubuntu 10.04. After installation tried to secure the installation using

sudo /usr/bin/mysql_secure_installation

when asked for root password for mysql, i entered the correct password. but it says access denied for root@localhost after asking for Enter current root password. I checked and verified my password is correct by connecting through mysql -u root -p command. What could be the reason?

1 answers, votes, 1237 views

Submit Answer

asked by Visitor
1 year 35 weeks ago

Post Comment

1 Answers

Answer

I had the same issue before and it was due to the # (hash) in the password. Not sure this is a bug or by design.

So, uninstalled and reinstalled mysql server with a root password that doesn't contain # (hash) and this time it worked fine.

answer by Visitor
1 year 35 weeks ago

Ubuntu 11.04 released!

Ubuntu 11.04 code named natty narwhal is released download ubuntu 11.04

Read ubuntu 11.10 reviews and share yours now!!

ubun2