Login without password: https://askubuntu.com/questions/915585/how-to-login-mysql-shell-when-mysql-have-no-password works on Ubuntu 20.10.
Create user for further logins without
Create test user with password:and login as that user: Login with password given on the command line: The
IDENTIFIED WITH mysql_native_passwordpart is to overcome "Client does not support authentication protocol requested by server" when connecting from Node.js.
View permissions for each user on each DB: https://serverfault.com/questions/263868/how-to-know-all-the-users-that-can-access-a-database-mysql
Show tables in database:or: