{"id":698,"date":"2012-01-31T20:48:57","date_gmt":"2012-02-01T03:48:57","guid":{"rendered":"http:\/\/jim-zimmerman.com\/?p=698"},"modified":"2017-10-18T12:34:57","modified_gmt":"2017-10-18T19:34:57","slug":"how-to-reset-mysql-root-password-when-forgotten","status":"publish","type":"post","link":"https:\/\/jim-zimmerman.com\/?p=698","title":{"rendered":"How to reset MySQL root password, when forgotten.."},"content":{"rendered":"

This was bit more challenging in CentOS 7:<\/p>\n

I couldn’t get MySQL\/MariaDB to start up in safe mode. I kept getting the following no matter what options I tried:<\/p>\n

170324 15:23:36 [ERROR] Can’t find messagefile ‘\/share\/mysql\/errmsg.sys’
\n170324 15:23:36 [ERROR] Aborting<\/p><\/blockquote>\n

I know this is probably overkill, but I finally decided I would just pass mysqld_safe, fully qualified, all the same parameters as I noticed when I had mysql running as well as the –init-file to reset the root password I forgot:<\/p>\n

\/usr\/bin\/mysqld_safe –basedir=\/usr –datadir=\/var\/lib\/mysql –plugin-dir=\/usr\/lib64\/mysql\/plugin –user=mysql –init-file=\/tmp\/a.sql –log-error=\/var\/lib\/mysql\/hostname.err –pid-file=\/var\/lib\/mysql\/hostname.pid –skip-grant-tables<\/p><\/blockquote>\n

I probably just needed to basedir option.<\/p>\n

I checked this and this all I needed in CentOS 7:<\/p>\n

mysqld_safe –basedir=\/usr –skip-grant-tables &<\/p><\/blockquote>\n

These are the steps used to reset the root password in MySQL running on a linux system. In my case, it was CentOS 5.6.<\/p>\n

Login as root.<\/p>\n

Check to see what user ID MySQL is running under. In CentOS\/RedHat it is mysql.<\/p>\n

# su – mysql<\/p>\n

Stop MySQL if it is currently running.<\/p>\n

# kill `cat \/var\/run\/mysqld\/mysqld.pid`<\/p>\n

or, as root:<\/p>\n

# service mysqld stop<\/p>\n

Create a temporary sql script containing the following:<\/p>\n

# vi tmp.sql
\nUPDATE mysql.user SET Password=PASSWORD(‘newpassword<\/em>‘) WHERE User=’root’;
\nFLUSH PRIVILEGES;<\/p>\n

Start up MySQL in safe mode using the initialization script you just created:<\/p>\n

# mysqld_safe –init-file=tmp.sql &<\/p>\n

Test the new password:<\/p>\n

# mysql -u root -p newpassword<\/em>
\nmysql><\/p>\n

As root: &<\/p>\n

# service mysqld stop
\n# service mysqld start<\/p>\n

Process used in Ubuntu 12.04.
\nHere is the process in Ubunutu:<\/p>\n

# service mysql stop
\n# mysqld –skip-grant-tables &
\n# mysql -u root mysql
\nmysql> UPDATE user SET Password=PASSWORD(‘newpassword’) WHERE User=’root’;
\nmysql> FLUSH PRIVILEGES;
\nmysql> quit
\n# service mysql start<\/p>\n","protected":false},"excerpt":{"rendered":"

This was bit more challenging in CentOS 7: I couldn’t get MySQL\/MariaDB to start up in safe mode. I kept getting the following no matter what options I tried: 170324 15:23:36 [ERROR] Can’t find messagefile ‘\/share\/mysql\/errmsg.sys’ 170324 15:23:36 [ERROR] Aborting I know this is probably overkill, but I finally decided I would just pass mysqld_safe, [&hellip<\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[3],"tags":[48,248,249,136,369],"class_list":["post-698","post","type-post","status-publish","format-standard","hentry","category-documentation","tag-linux","tag-mysql","tag-password","tag-reset","tag-safe"],"share_on_mastodon":{"url":"","error":""},"_links":{"self":[{"href":"https:\/\/jim-zimmerman.com\/index.php?rest_route=\/wp\/v2\/posts\/698","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/jim-zimmerman.com\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/jim-zimmerman.com\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/jim-zimmerman.com\/index.php?rest_route=\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/jim-zimmerman.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=698"}],"version-history":[{"count":5,"href":"https:\/\/jim-zimmerman.com\/index.php?rest_route=\/wp\/v2\/posts\/698\/revisions"}],"predecessor-version":[{"id":1606,"href":"https:\/\/jim-zimmerman.com\/index.php?rest_route=\/wp\/v2\/posts\/698\/revisions\/1606"}],"wp:attachment":[{"href":"https:\/\/jim-zimmerman.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=698"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/jim-zimmerman.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=698"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/jim-zimmerman.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=698"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}