0

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.

For example:

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.

user2115136
  • 3

1 Answers1

0

It should just be a matter of:

sudo apt-get install mysql-server

Follow the prompts to enter a root password during installation.

Then connect:

mysql -u root -p

Enter the password set during installation.

Cody
  • 364