![]() 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. Now, we will set the password to identify rootlocalhost: alter user rootlocalhost identified with mysqlnativepassword by 'Enter strong password here' Once done, flush the privileges in MySQL and exit by using the given command: flush privileges exit. ![]() Usually during the install process it asks me to set a root password, but this time it did not. Let's start with starting MySQL: sudo mysql. 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. 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 |