Authentication from MariaDB 10 4

Ian Gilfillan from the MariaDB Foundation covers Authentication from MariaDB 10.4:

0:00 Start
0:21 – what’s changed with authentication from MariaDB 10.4
1:34 – connecting to a new MariaDB installation
4:57 – creating a new user able to connect with both unix_socket and mysql_native_password
6:34 – restoring password login only as it was in MariaDB 10.3 and before
7:45 – restoring access if you’ve lost your password
9:17 – other authentication-related changes from MariaDB 10.4

Knowledge Base links:
* Authentication from MariaDB 10.4 (https://mariadb.com/kb/en/authentication-from-mariadb-104/)
* Troubleshooting Connection Issues (https://mariadb.com/kb/en/troubleshooting-connection-issues/)
* CREATE USER (https://mariadb.com/kb/en/create-user/)
* SET PASSWORD (https://mariadb.com/kb/en/set-password/)
* Authentication Plugin – Unix Socket (https://mariadb.com/kb/en/authentication-plugin-unix-socket/)
* Authentication Plugin – mysql_native_password (https://mariadb.com/kb/en/authentication-plugin-mysql_native_password/)
* mysql.user Table (https://mariadb.com/kb/en/mysqluser-table/)
* mysql.global_priv Table (https://mariadb.com/kb/en/mysqlglobal_priv-table/)