I googled here and there and tried various answers I found on the net, including the accepted answer above. As a result I wasn't able to login into MySQL.
DBNGIN DEFAULT PASSWORD INSTALL
I installed MySQL 5.7 from the repo ( sudo apt install mysql-server) and surprisingly during installation, the setup didn't prompt to enter root password. I just installed Linux Mint 19 (based on Ubuntu 18.04) on my machine. => To zap this alternate authentication mode and return the MySQL root user to using passwords: ALTER USER IDENTIFIED WITH mysql_native_password BY 'SOME_NEW_ROOT_PASSWORD' |īecause it's using auth_socket, the root password cannot be changed: the SET PASSWORD command fails, and mysql_secure_installation desn't attain anything. | user | plugin | HEX(authentication_string) | Mysql> GRANT ALL PRIVILEGES ON *.* TO WITH GRANT OPTION Ĭomparing "me" with "root": mysql> SELECT user, plugin, HEX(authentication_string) FROM er WHERE user = 'me' or user = 'root'
DBNGIN DEFAULT PASSWORD HOW TO
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')
0 kommentar(er)
