Difference between revisions of "Resetting MySQL root password"
From Notes_Wiki
m |
m |
||
| Line 10: | Line 10: | ||
#Use below command to run mysql without any priviledge information | #Use below command to run mysql without any priviledge information | ||
#:<pre> | #:<pre> | ||
#:: mysqld_safe --skip-grant-tables | #:: mysqld_safe --skip-grant-tables & | ||
#:</pre> | #:</pre> | ||
#Connect to mysql by without any options or authentication | #Connect to mysql by without any options or authentication | ||
| Line 32: | Line 32: | ||
#:: service mysqld stop | #:: service mysqld stop | ||
#:</pre> | #:</pre> | ||
#: '''This did not work in stopping mysql. Had to kill mysqld_safe and later mysql process to stop mysql.''' | |||
#Start mysql again without any password or with the new password set. | #Start mysql again without any password or with the new password set. | ||
Refer: | |||
* https://fullstack-tutorials.com/mysql/reset-mysql-root-password-in-centos-7 | |||
<yambe:breadcrumb self="Resetting MySQL root password">Mariadb configuration | Mariadb configuration</yambe:breadcrumb> | <yambe:breadcrumb self="Resetting MySQL root password">Mariadb configuration | Mariadb configuration</yambe:breadcrumb> | ||
Revision as of 05:09, 25 May 2021
<yambe:breadcrumb self="Resetting MySQL root password">Mariadb configuration | Mariadb configuration</yambe:breadcrumb>
Resetting mysql root password
In case we have root privileges on server and want to reset mysql root password then we can use following steps:
- Stop mysql service if it is running.
- service mysqld stop
- Use below command to run mysql without any priviledge information
- mysqld_safe --skip-grant-tables &
- Connect to mysql by without any options or authentication
- mysql
- Use database mysql using:
- use mysql
- Change root password using:
- update user set password=password('secret') where user='root'
- or disable it using:
- update user set password='' where user='root'
- Stop mysql using command:
- service mysqld stop
- This did not work in stopping mysql. Had to kill mysqld_safe and later mysql process to stop mysql.
- Start mysql again without any password or with the new password set.
Refer:
<yambe:breadcrumb self="Resetting MySQL root password">Mariadb configuration | Mariadb configuration</yambe:breadcrumb>
