Mysql skip grant tables - Revision history

Ted: Add key words for improved searchability.

2024-02-22T05:17:26Z

Add key words for improved searchability.

2024-02-13T14:16:27Z

formatting

2024-02-13T14:16:10Z

add pre format tag

2024-02-13T14:15:00Z

hash symbol or num symbol "#" to html

2024-02-13T14:09:11Z

minor edit to remove unintended numbered bullet point formatting

2024-02-13T14:08:25Z

add link to and excerpt from superuser.com mysql forum post

← Older revision		Revision as of 05:17, 22 February 2024
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 13: / Line 13: @@
 *  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:
@@ Line 21: / Line 22: @@
 [mysqld]
-&num; For debugging and recovery only &num;
+* For debugging and recovery only #
 skip-grant-tables
 skip-networking
+"
 </i>
 <!-- comment -->

@@ Line 21: / Line 21: @@
 [mysqld]
-# For debugging and recovery only #
+&num; For debugging and recovery only &num;
 skip-grant-tables
 skip-networking

@@ Line 24: / Line 24: @@
 skip-grant-tables
 skip-networking
+"
 </i>
 <!-- comment -->

← Older revision		Revision as of 14:08, 13 February 2024
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 -->

@@ Line 7: / Line 7: @@
 *  [[MYSQL-notes]]
 *  [[Testlink]]
-<ul>
+</ul>
 See also superuser.com forum post: