1. Advertising
    y u no do it?

    Advertising (learn more)

    Advertise virtually anything here, with CPM banner ads, CPM email ads and CPC contextual links. You can target relevant areas of the site and show ads based on geographical location of the user if you wish.

    Starts at just $1 per CPM or $0.10 per CPC.

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