31,029
edits
FAQ I Lost my password: Difference between revisions
m
→Reset the root password of Mysql
PolyglotBot (talk | contribs) m (Import interlang links (links to translated versions of this page in other languages) from Multi Language Manager table.) |
Tag: 2017 source edit |
||
| Line 67: | Line 67: | ||
= Linux = | = Linux = | ||
== Reset the root password of Mysql == | == Reset the root password of Mysql or MariaB == | ||
* Connect to a terminal console with user roor. | * Connect to a terminal console with user roor. | ||
* Stop Mysql: | * Stop Mysql: | ||
| Line 79: | Line 79: | ||
<source lang="sql"> | <source lang="sql"> | ||
mysql> UPDATE mysql.user SET Password = PASSWORD('anewpassword') WHERE User = 'root'; | mysql> UPDATE mysql.user SET Password = PASSWORD('anewpassword') WHERE User = 'root'; | ||
or on a more recent version | |||
mysql> SET PASSWORD FOR 'root@localhost' = PASSWORD('anewpassword'); | |||
</source> | |||
Then validate the change with | |||
<source lang="sql"> | |||
mysql> FLUSH PRIVILEGES; | mysql> FLUSH PRIVILEGES; | ||
mysql> QUIT; | mysql> QUIT; | ||