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:

  1. Stop mysql service if it is running.
    service mysqld stop
  2. Use below command to run mysql without any priviledge information
    mysqld_safe --skip-grant-tables &
  3. Connect to mysql by without any options or authentication
    mysql
  4. Use database mysql using:
    use mysql
  5. Change root password using:
    update user set password=password('secret') where user='root'
    or disable it using:
    update user set password='' where user='root'
  6. 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.
  7. 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>