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 :)
Thanks,
Nick
*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)?
Become a contributor for community
Get paid to write technical tutorials and select a tech-focused charity to receive a matching donation.
DigitalOcean Documentation
Full documentation for every DigitalOcean product.
Resources for startups and AI-native businesses
The Wave has everything you need to know about building a business, from raising funding to marketing your product.
The developer cloud
Scale up as you grow — whether you're running one virtual machine or ten thousand.
Start building today
From GPU-powered inference and Kubernetes to managed databases and storage, get everything you need to build, scale, and deploy intelligent applications.
