MYSQL setup Ebuntu

[E_G_R2]

IGNORE, figured it out a after a brew

 

 

 

Hi,

 

no expert, just following some online instructions. I've got a Ubuntu server that I've installed a LAMP server on using these instructions

 

sudo apt-get install lamp-server^ -y

 

I was expecting to have to setup a password for root but this didn't happen.

 

Used - mysql>SELECT user,authentication_string,plugin,host FROM mysql.user;

 

to ascertain that there was no password for root so I was going to set this via the command:

 

mysql>ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY 'password';

 

My problem is that after running the 'SELECT' command I get '> so no commands seem to work. How do I get out of this?

Edited October 18, 2018 by E_G_R2