Comments - Cannot reset password for the root user in MariaDB (Mac keeps changing it on restart)

1 week, 4 days ago Ian Gilfillan

I formatted your output for you :)

"Invalid" as a password means that password authentication is disabled. See Authentication from MariaDB 10.4.

"some users may wish to log in as MariaDB root without using sudo. Hence the old authentication method — conventional MariaDB password — is still available. By default it is disabled (“invalid” is not a valid password hash), but one can set the password with a usual SET PASSWORD statement."

 
Content reproduced on this site is the property of its respective owners, and this content is not reviewed in advance by MariaDB. The views, information and opinions expressed by this content do not necessarily represent those of MariaDB or any other party.