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 link to and excerpt from superuser.com mysql forum post) |
||
| Line 9: | Line 9: | ||
<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 | ||
| + | |||
| + | <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> | ||
<!-- comment --> | <!-- comment --> | ||
Revision as of 14:08, 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]
