sudo dpkg -P mysql-server mysql-server-5. Fortunately the internet is a wonderful place, and I found some instructions on how to completely remove all traces of MySQL server, and start again. UPDATE: As it turns out, this was not the only issue I was having, turns out the MySQL install was also corrupt somehow. Thankfully the folks over at Digital Ocean have released an article which explains this information and provides the steps to switch the root user authentication from auth_socket to using a password. ![]() Not a huge issue, as I could create another user to access any database, but as it’s a local install, connecting as the root MySQL user is just much easier.Īs it turns out, on Ubuntu installs running MySQL 5.7 or later, the root user is set to authenticate using the auth_socket plugin rather than using a password. ![]() This meant that I wouldn’t be able to access the database using the root user. Usually during the install process it asks me to set a root password, but this time it did not. This plugin requires that the name of the operating system user that invokes the MySQL client matches the name of the MySQL user specified in the command, so you must invoke. While I unusually run my client websites inside on of my custom Vagrant boxes, for working on personal projects or plugin/theme customisation everything’s much faster when it’s able to use the full power of the machine I’m working on.Īfter I switched back to a computer as my every day workstation, I came across a weird little issue with installing MySQL. In Ubuntu systems running MySQL 5.7 (and later versions), the root MySQL user is set to authenticate using the authsocket plugin by default rather than with a password. ![]() One of the things I love about using Ubuntu as my primary operating system is that I can have quickly set up a ‘bare metal’ LAMP development environment.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |