- [Show page]
- [Old revisions]
- [[unknown link type]]
- []
Differences
This shows you the differences between two versions of the page.
| Both sides previous revision Previous revision | Next revision Both sides next revision | ||
|
linux:mysql [2014/07/21 18:01] kotrlik [Correcting an error] |
linux:mysql [2015/02/13 15:23] admin |
||
|---|---|---|---|
| Line 65: | Line 65: | ||
| ====== Performance ====== | ====== Performance ====== | ||
| * http://www.mysqlperformanceblog.com | * http://www.mysqlperformanceblog.com | ||
| + | |||
| + | |||
| + | ====== Regain root access ====== | ||
| + | |||
| + | From http://www.simplehelp.net/2008/11/26/how-to-reset-a-lost-mysql-root-password/ | ||
| + | |||
| + | <code> | ||
| + | # /etc/init.d/mysql stop | ||
| + | # mysqld_safe --skip-grant-tables & | ||
| + | # mysql -u root | ||
| + | |||
| + | mysql> use mysql; | ||
| + | mysql> update user set password=PASSWORD("NewMySQLPassword") where User="root"; | ||
| + | mysql> flush privileges; | ||
| + | mysql> quit | ||
| + | |||
| + | # /etc/init.d/mysql stop | ||
| + | # /etc/init.d/mysql start | ||
| + | </code> | ||
linux/mysql.txt · Last modified: 2019/10/21 09:53 by admin