Hi All -
I have a new droplet with Ubuntu 18.04 and am installing MySql using
sudo apt-get install mysql server
It seems to install fine but does not ask for a root password on install, I am pretty sure this is as it is expected to work.
With this from the cli I can log into it with just using ‘mysql’, while that is handy it is not very secure.
So I stop the services and use
I go through the steps, set a root password, remove anon users, stop remote root access etc…
Restart the service
I have tried flushing privileges
I can still log in with no password.
I have then tried a couple of other methods that were outlined here, again no luck.
Any thoughts ? What am I forgetting or missing ?
I am beginning to feel real dumb.
This textbox defaults to using Markdown to format your answer.
You can type !ref in this text area to quickly search our full set of tutorials, documentation & marketplace offerings and insert the link!
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.
Join our DigitalOcean community of over a million developers for free! Get help and share knowledge in Q&A, subscribe to topics of interest, and get courses and tools that will help you grow as a developer and scale your project or business.
Click below to sign up and get $100 of credit to try our products over 60 days!