Difference between revisions of "Mysql skip grant tables"
From Wiki at Neela Nurseries
m (minor edit to remove unintended numbered bullet point formatting) |
m (hash symbol or num symbol "#" to html) |
||
| Line 21: | Line 21: | ||
[mysqld] | [mysqld] | ||
| − | + | # For debugging and recovery only # | |
skip-grant-tables | skip-grant-tables | ||
skip-networking | skip-networking | ||
Revision as of 14:15, 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:
"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
"
