Im having trouble installing MySql server. Everytime I try to connect to local server with MySQL workbench I get this message:
"Your connection attempt failed for user 'root' from your host to server at localhost:3306: Access denied for user 'root'@'localhost'
Please: 1 Check that mysql is running on server localhost 2 Check that mysql is running on port 3306 (note: 3306 is the default, but this can be changed) 3 Check the root has rights to connect to localhost from your address (mysql rights define what clients can connect to the server and from which machines) 4 Make sure you are both providing a password if needed and using the correct password for localhost connecting from the host address you're connecting from"
I'm running a freshly installied ubuntu 18.04. These are the packeges I have installed on my system:
I've tried this:
mysql -u root -p
Then Im prompted to enter a password, but during installation I was never asked to create one to begin with. And then I get the error no matter what pass I give: ERROR 1698 (28000): Access denied for user 'root'@'localhost'