Difference between revisions of "Mysql skip grant tables"
From Wiki at Neela Nurseries
(Created page with " "Signpost page" to make searches for MYSQL password reset steps easier - TMH Neela Nurseries wiki articles related to this topic: <ul> * MYSQL-notes * Testlink <u...") |
m (Add key words for improved searchability.) |
||
| (5 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: | ||
| + | |||
| + | * https://superuser.com/questions/1127299/how-to-restart-mysql-with-skip-grant-tables-if-you-cant-use-the-root-password | ||
| + | |||
| + | <pre> | ||
| + | <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> | ||
| + | </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>
