This is possibly a problem that affects lots of users, I have have found similar posts, but none of the solutions have worked for me.
I have installed mysql on my ubuntu 13.10, however I do not seem to have any rights to do anything. I cannot connect via root, though I do know the root password. I can connect through my user name, though in doing this I get no access rights to create, delete, nor do anything else that is useful.
mysql> CREATE DATABASE sphider; ERROR 1044 (42000): Access denied for user ''@'localhost' to database 'sphider'
or if I try to log in using root:
root@rozlockwood-Z87M-D3H:/home/rozlockwood# mysql -u root -p Enter password: ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: YES)
Any help please.