To login as the MySQL root user, one can use sudo: sudo mysql -user=rootīut how to then change the root password? To illustrate what's going on, I created a new user 'me', with full privileges, with: mysql> CREATE USER IDENTIFIED BY 'my_new_password' It allows a password-free login, provided that one is logged into the Linux system with the same user name. The default installation uses auth_socket for authentication, in lieu of passwords! MySQL server 5.7 was already installed by default on my new Linux Mint 19.īut, what's the MySQL root password? It turns out that: UPDATE er SET authentication_string=PASSWORD('new_password') where user='root' Įnter password: // Yay! 'new_password' now works! Mysql> COMMIT // When you don't have auto-commit switched onĮither: mysql> ALTER USER IDENTIFIED BY 'new_password' Mysql> UPDATE user SET plugin='mysql_native_password' WHERE User='root' | debian-sys-maint | localhost | mysql_native_password | | mysql.sys | localhost | mysql_native_password | | ssion | localhost | mysql_native_password | Mysql> SELECT User, Host, plugin FROM er Note the lines which read: user = debian-sys-maintĮnter password: // type 'blahblahblah', ie. With special credit to this answer for digging me out of the frustration on this. Here's what worked for me, on Ubuntu 18.04, from the top

There's so many answers out there saying to reinstall mysql or use some combo of mysqld_safe -skip-grant-tablesĪnd / or UPDATE er SET Password=PASSWORD('password')

Install mysql 5.7 on mac