I got it fixed, thanks to post #4 on this thread:
http://ubuntuforums.org/showthread.php?t=1836919
Start your mysql client as shown below:
mysql -u debian-sys-maint -p
In another terminal, 'cat' the file /etc/mysql/debian.cnf (you'll have
to 'sudo cat' it). That file contains a password; paste that password in
the first terminal when prompted for it. Then execute the following
commands at the 'mysql>' prompt:
grant all privileges on *.* to 'root'@'localhost' identified by 't1g3r'
with grant option;
flush privileges;
That did it for me!
--
You received this bug notification because you are a member of Ubuntu
Bugs, which is subscribed to Ubuntu.
https://bugs.launchpad.net/bugs/542543
Title:
Access denied for user 'root'@'localhost' to database SOMEDB
To manage notifications about this bug go to:
https://bugs.launchpad.net/ubuntu/+source/mysql-dfsg-5.1/+bug/542543/+subscriptions
--
ubuntu-bugs mailing list
[email protected]
https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs