Can’t reset root password with –skip-grant-tables on ubuntu 16

I found that the mysql.sock is deleted when the mysql service is stoped and mysqld_safe can’t create it (I couldn’t find the reason), so my solution was back up the sock folder and restore before start mysqld_safe Start server $ sudo service mysql start Go to sock folder $ cd /var/run Back up the sock … Read more

How do I turn off the mysql password validation?

Here is what I do to remove the validate password plugin: Login to the mysql server as root mysql -h localhost -u root -p Run the following sql command: uninstall plugin validate_password; If last line doesn’t work (new mysql release), you should execute UNINSTALL COMPONENT ‘file://component_validate_password’; I would not recommend this solution for a production … Read more