Computer and IT knowledge - things to know

mysql / mariadb > no access to localhost 127.0.0.1

problem occured on ubuntu 18.04.xx

>> connect not possible via:
mysql -u root -p -h 127.0.0.1 -P 3306

>> only connect via console / pipe is possible

solution:
use mysql;
update user set plugin='mysql_native_password' where user='root';
flush privileges;
exit;

computer2know :: thank you for your visit :: have a nice day :: © 2023