I was following this guide on MySQL installation, and it states that I should create a user with the following general statement:
CREATE USER 'username'@'host' IDENTIFIED WITH authentication_plugin BY 'password';
I assume that if I’m using auth_socket I don’t have to bother with ‘By ‘password’’
Any help would be appreciated :)
*edit: it also mentions
Note that even though you’ve set a password for the root MySQL user, this user is not currently configured to authenticate with a password when connecting to the MySQL shell. but doesn’t ever seem to change this (only authentication for the created user)?
These answers are provided by our Community. If you find them useful, show some love by clicking the heart. If you run into issues leave a comment, or add your own answer to help others.