I'm wanting some assistance in understanding mysql root account that connects by unix socket. I do not understand the unix_socket very well. Logging in without a password concerns me as I may be misunderstanding how the login is happening.
I'm running Ubuntu server 18.04.1 LTS and installed mysql-server Ver 14.14 Distrib 5.7.23. I ran mysql_secure_installation.
I cannot login to mysql with the password at all.
mysql -u root -p
I can login to mysql if executed as sudo without password.
sudo mysql -u root
I understand this is because it's using the unix_socket instead of mysql_native_password.
Can a non-sudo user login to the mysql server with my current setup?