I am trying to install mysql after i replaced my disk with MySQL on it with a bigger and faster one. After installing mysql-server
on ubuntu, when running select user,host,authentication_string from user where user='root';
, authentication_string
is blank.
I set my password but the only way to login to root is to run the MySQL command with sudo and if I try to put the password in if I run mysql -u root -p
it doesn't work. I have also tried to just leave the password blank when logging in and it has had no effect. Any help is greatly appreciated.
System info: pop!_os amd64 20.04 (ubuntu like)