I am using Ubuntu 11.10.
In stalled LAMP using the directions described here
. It worked great. Unfortunately I then followed the security advice outlined here
. After following this advice
mysql> DELETE FROM user WHERE NOT (host = "localhost" AND user = "ReallyLongLongName");
mysql> FLUSH PRIVILEGES;
mysql is now unusable. It could well be that I chose too long a name for "mydbadmin". So when I try to log in I try to log in using
mysql -u ReallyLongLongName -p
ERROR 1045 (28000): Access denied for user 'ReallyLongLongNa'@'localhost' (using password: YES)
Maybe I can fix the problem by adjusting mysql to take longer names. Failing that I need to uninstall mysql so that I can reinstall it.
Could someone please help with this?