Difference between revisions of "Mysql skip grant tables"

From Wiki at Neela Nurseries
Jump to: navigation, search
m (add pre format tag)
m (Add key words for improved searchability.)
 
(One intermediate revision 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:

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>