MySQL/version/5.7: Difference between revisions
from HTYP, the free directory anyone can edit if they can prove to me that they're not a spambot
< MySQL
Created page with "==Recovering / Setting passwords== A lot of the instructions online for doing this no longer work with 5.7. Obsolete instructions: * [https://stackoverflow.com/questions/4429..." |
exact version |
||
| Line 1: | Line 1: | ||
==Recovering / Setting passwords== | ==Recovering / Setting passwords== | ||
A lot of the instructions online for doing this no longer work with 5.7. | A lot of the instructions online for doing this no longer work with 5.7. The following is true for version 5.7.24-0ubuntu0.18.04.1 | ||
Obsolete instructions: | Obsolete instructions: | ||
Revision as of 02:00, 25 December 2018
Recovering / Setting passwords
A lot of the instructions online for doing this no longer work with 5.7. The following is true for version 5.7.24-0ubuntu0.18.04.1
Obsolete instructions:
- Mysql (MariaDB 10.0.29): Set root password, but still can login without asking password?: the SQL command for changing passwords is different
- SET PASSWORD is deprecated, but may work
- ALTER USER is preferred.
- BUT that won't work when grant tables are skipped; you have to use
update user set authentication_string=PASSWORD("new_password") where User='root';
- Setting, Changing And Resetting MySQL Root Passwords
- default value for --skip-grant-tables is now FALSE, so you have to specify
--skip-grant-tables=TRUE
- default value for --skip-grant-tables is now FALSE, so you have to specify
