Difference between revisions of "Mysql skip grant tables"

From Wiki at Neela Nurseries
Jump to: navigation, search
m (add link to and excerpt from superuser.com mysql forum post)
m (Add key words for improved searchability.)
 
(4 intermediate revisions by the same user not shown)
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 7: Line 10:
 
*  [[MYSQL-notes]]
 
*  [[MYSQL-notes]]
 
*  [[Testlink]]
 
*  [[Testlink]]
<ul>
+
</ul>
  
 
See also superuser.com forum post:
 
See also superuser.com forum post:
Line 13: Line 16:
 
*  https://superuser.com/questions/1127299/how-to-restart-mysql-with-skip-grant-tables-if-you-cant-use-the-root-password
 
*  https://superuser.com/questions/1127299/how-to-restart-mysql-with-skip-grant-tables-if-you-cant-use-the-root-password
  
 +
<pre>
 
<i>
 
<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:
 
"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 25:
  
 
[mysqld]
 
[mysqld]
# For debugging and recovery only #
+
* For debugging and recovery only #
 
skip-grant-tables
 
skip-grant-tables
 
skip-networking
 
skip-networking
###################################
 
 
"
 
"
 
</i>
 
</i>
 +
</pre>
  
 
<!-- comment -->
 
<!-- comment -->

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:

See also superuser.com forum post:

<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>