Access only available as root

Discussion in 'Databases' started by Bill Lancaster, Jul 31, 2019.

0
  1. #1
    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
     
    Bill Lancaster, Jul 31, 2019 IP
  2. Bill Lancaster

    Bill Lancaster Peon

    Messages:
    2
    Likes Received:
    0
    Best Answers:
    0
    Trophy Points:
    1
    #2
    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
     
    Bill Lancaster, Jul 31, 2019 IP