Mysql vs MariaDB how to create a socket user tutorial
Creating a Socket based user MariaDB:
CREATE USER 'youruser'@'localhost' IDENTIFIED WITH unix_socket;
Creating a Socket based user in MySQL:
CREATE USER 'youruser'@'localhost' IDENTIFIED WITH auth_socket;
We can see the difference is that in Maria it is called "unix_socket" and MySQL "auth_socket".........
MySQL 5.7 on Debian and Ubuntu - How To Reset Root Password
MySQL on Debian versions is configured differently than the native local MySQL plugin so you will be disappointed when your password on the mysql client fails by default.
Here is how you reset the MySQL root password the proper and "working way"
#first we gracefully stop mysql
sudo systemctl stop mysql;
#then we forcefully kill any mysqld process just in case
sudo killall -9 mysqld mysqld_safe;........