Difference between revisions of "Mysql skip grant tables"

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:

• MYSQL-notes
• Testlink

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>