How to Reset a MySQL Password in 5 Easy Steps<\/p>\n
1. Stop the mysqld daemon process.
\n 2. Start the mysqld daemon process with the –skip-grant-tables option.
\n 3. Start the mysql client with the -u root option.
\n 4. Execute the UPDATE mysql.user SET Password=PASSWORD(‘password’) WHERE User=’root’;
\n 5. Execute the FLUSH PRIVILEGES; command.
\n<\/p>\n
[root@localhost init.d]# .\/mysqld stop
\nStopping MySQL: [ OK ]<\/p>\n
[root@localhost init.d]# .\/mysqld start –skip-grant-tables
\n[root@localhost init.d]# mysql -u root -p
\nEnter password:
\nWelcome to the MySQL monitor. Commands end with ; or \\g.
\nYour MySQL connection id is 4 to server version: 4.1.20<\/p>\n
Type ‘help;’ or ‘\\h’ for help. Type ‘\\c’ to clear the buffer.
\nmysql> connect cacti
\nReading table information for completion of table and column names
\nYou can turn off this feature to get a quicker startup with -A<\/p>\n
Connection id: 25
\nCurrent database: cacti<\/p>\n
mysql> update user_auth set password=md5(‘admin’) where username=’admin’;
\nQuery OK, 1 row affected (0.00 sec)
\nRows matched: 1 Changed: 1 Warnings: 0<\/p>\n","protected":false},"excerpt":{"rendered":"
How to Reset a MySQL Password in 5 Easy Steps 1. Stop the mysqld daemon process. 2. Start the mysqld daemon process with the –skip-grant-tables option. 3. Start the mysql client with the -u root option. 4. Execute the UPDATE … Read More »<\/a><\/p>\n","protected":false},"author":4,"featured_media":0,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[1],"tags":[],"class_list":["post-307","post","type-post","status-publish","format-standard","hentry","category-uncategorized"],"_links":{"self":[{"href":"http:\/\/www.wildow.com\/blog\/index.php?rest_route=\/wp\/v2\/posts\/307","targetHints":{"allow":["GET"]}}],"collection":[{"href":"http:\/\/www.wildow.com\/blog\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/www.wildow.com\/blog\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/www.wildow.com\/blog\/index.php?rest_route=\/wp\/v2\/users\/4"}],"replies":[{"embeddable":true,"href":"http:\/\/www.wildow.com\/blog\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=307"}],"version-history":[{"count":0,"href":"http:\/\/www.wildow.com\/blog\/index.php?rest_route=\/wp\/v2\/posts\/307\/revisions"}],"wp:attachment":[{"href":"http:\/\/www.wildow.com\/blog\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=307"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/www.wildow.com\/blog\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=307"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/www.wildow.com\/blog\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=307"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}