Have just set up a new Kubuntu machine (18.04). Some how I've taken a wrong turn in setting up mysql and can only access mysql as 'root'. In other words, in Terminal:- :~$ mysql -u root -p gives "ERROR 1698 (28000): Access denied for user 'root'@'localhost'". but :~$ sudo mysql -u root -p works fine Any advice welcome
This https://askubuntu.com/questions/766334/cant-login-as-mysql-user-root-from-normal-user-account-in-ubuntu-16-04 seems to do the trick