Difference between revisions of "Mysql skip grant tables"
From Wiki at Neela Nurseries
m (add link to and excerpt from superuser.com mysql forum post) |
m (minor edit to remove unintended numbered bullet point formatting) |
||
Line 24: | Line 24: | ||
skip-grant-tables | skip-grant-tables | ||
skip-networking | skip-networking | ||
− | |||
" | " | ||
</i> | </i> | ||
<!-- comment --> | <!-- comment --> |
Revision as of 14:09, 13 February 2024
"Signpost page" to make searches for MYSQL password reset steps easier - TMH
Neela Nurseries wiki articles related to this topic:
- For debugging and recovery only #
-
See also superuser.com forum post:
"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]