Difference between revisions of "Mysql skip grant tables"

From Wiki at Neela Nurseries
Jump to: navigation, search
m (add pre format tag)
(formatting)
Line 7: Line 7:
 
*  [[MYSQL-notes]]
 
*  [[MYSQL-notes]]
 
*  [[Testlink]]
 
*  [[Testlink]]
<ul>
+
</ul>
  
 
See also superuser.com forum post:
 
See also superuser.com forum post:

Revision as of 14:16, 13 February 2024

"Signpost page" to make searches for MYSQL password reset steps easier - TMH

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>