Difference between revisions of "Mysql skip grant tables"
From Wiki at Neela Nurseries
m (hash symbol or num symbol "#" to html) |
m (add pre format tag) |
||
| Line 13: | Line 13: | ||
* https://superuser.com/questions/1127299/how-to-restart-mysql-with-skip-grant-tables-if-you-cant-use-the-root-password | * https://superuser.com/questions/1127299/how-to-restart-mysql-with-skip-grant-tables-if-you-cant-use-the-root-password | ||
| + | <pre> | ||
<i> | <i> | ||
"When you don't know your root password (or an error like 'ERROR 1045 (28000): Access denied for user 'root'@'localhost' prevents access) you can get access by adding the option to the MySQL config file. First open it for editing: | "When you don't know your root password (or an error like 'ERROR 1045 (28000): Access denied for user 'root'@'localhost' prevents access) you can get access by adding the option to the MySQL config file. First open it for editing: | ||
| Line 21: | Line 22: | ||
[mysqld] | [mysqld] | ||
| − | + | * For debugging and recovery only # | |
skip-grant-tables | skip-grant-tables | ||
skip-networking | skip-networking | ||
" | " | ||
</i> | </i> | ||
| + | </pre> | ||
<!-- comment --> | <!-- comment --> | ||
Revision as of 14:16, 13 February 2024
"Signpost page" to make searches for MYSQL password reset steps easier - TMH
Neela Nurseries wiki articles related to this topic:
-
See also superuser.com forum post:
<i> "When you don't know your root password (or an error like 'ERROR 1045 (28000): Access denied for user 'root'@'localhost' prevents access) you can get access by adding the option to the MySQL config file. First open it for editing: sudo nano /etc/mysql/my.cnf Then search for [mysqld] and enter these values below it: [mysqld] * For debugging and recovery only # skip-grant-tables skip-networking " </i>
