Difference between revisions of "Mysql skip grant tables"
From Wiki at Neela Nurseries
m (minor edit to remove unintended numbered bullet point formatting) |
m (Add key words for improved searchability.) |
||
| (3 intermediate revisions by the same user not shown) | |||
| Line 1: | Line 1: | ||
"Signpost page" to make searches for MYSQL password reset steps easier - TMH | "Signpost page" to make searches for MYSQL password reset steps easier - TMH | ||
| + | |||
| + | Keywords: mysql recover root pass phrase | ||
| + | |||
Neela Nurseries wiki articles related to this topic: | Neela Nurseries wiki articles related to this topic: | ||
| Line 7: | Line 10: | ||
* [[MYSQL-notes]] | * [[MYSQL-notes]] | ||
* [[Testlink]] | * [[Testlink]] | ||
| − | <ul> | + | </ul> |
See also superuser.com forum post: | See also superuser.com forum post: | ||
| Line 13: | Line 16: | ||
* 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 25: | ||
[mysqld] | [mysqld] | ||
| − | + | * For debugging and recovery only # | |
skip-grant-tables | skip-grant-tables | ||
skip-networking | skip-networking | ||
" | " | ||
</i> | </i> | ||
| + | </pre> | ||
<!-- comment --> | <!-- comment --> | ||
Latest revision as of 05:17, 22 February 2024
"Signpost page" to make searches for MYSQL password reset steps easier - TMH
Keywords: mysql recover root pass phrase
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>
