{"id":108,"date":"2015-04-27T11:08:41","date_gmt":"2015-04-27T11:08:41","guid":{"rendered":"http:\/\/betakb.veeble.org\/?p=108"},"modified":"2025-04-24T11:31:11","modified_gmt":"2025-04-24T06:01:11","slug":"reset-root-password-for-mysql","status":"publish","type":"post","link":"https:\/\/www.veeble.com\/kb\/reset-root-password-for-mysql\/","title":{"rendered":"Reset root password for MySQL"},"content":{"rendered":"

You can view the MySQL root password in the file \/root\/.my.cnf.<\/p>\n

# cat \/root\/.my.cnf \n[client]\npass=\"sdd568c~M\"\nuser=root\n<\/pre>\n
Want to reset the root password for MySQL? Follow the below steps.<\/p>\n
1. Stop mysql<\/p>\n
2. Create a text file(for eg: \/home\/mysql-init) and place the following statements in it. Replace the password with the password that you want to use.<\/p>\n
UPDATE mysql.user SET Password=PASSWORD('MyNewPass') WHERE User='root'\nFLUSH PRIVILEGES;\n<\/pre>\n
3. Execute the following command<\/p>\n
mysqld_safe --init-file=\/home\/mysql-init &\n<\/pre>\n
4. Remove \/home\/mysql-init, kill mysql and start mysql.<\/p>\n
Other methods may be found here<\/a>.<\/p>\n
Note : You may try other methods as recommended by the control panel [if installed] first.<\/p>\n\n\n
<\/div>\n\n\n\n
Optimized WooCommerce Performance<\/h3>
Maximize sales with high-performance hosting. Fast loading times for better customer experience.<\/p><\/div>
Get Fast Hosting<\/path><\/svg><\/a><\/div><\/div>\n","protected":false},"excerpt":{"rendered":"
You can view the MySQL root password in the file \/root\/.my.cnf. # cat \/root\/.my.cnf [client] pass=”sdd568c~M” user=root Want to reset the root password for […]<\/p>\n","protected":false},"author":12,"featured_media":8712,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_uag_custom_page_level_css":"","site-sidebar-layout":"default","site-content-layout":"","ast-site-content-layout":"default","site-content-style":"default","site-sidebar-style":"default","ast-global-header-display":"","ast-banner-title-visibility":"","ast-main-header-display":"","ast-hfb-above-header-display":"","ast-hfb-below-header-display":"","ast-hfb-mobile-header-display":"","site-post-title":"","ast-breadcrumbs-content":"","ast-featured-img":"","footer-sml-layout":"","theme-transparent-header-meta":"","adv-header-id-meta":"","stick-header-meta":"","header-above-stick-meta":"","header-main-stick-meta":"","header-below-stick-meta":"","astra-migrate-meta-layouts":"set","ast-page-background-enabled":"default","ast-page-background-meta":{"desktop":{"background-color":"var(--ast-global-color-4)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"tablet":{"background-color":"","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"mobile":{"background-color":"","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""}},"ast-content-background-meta":{"desktop":{"background-color":"var(--ast-global-color-5)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"tablet":{"background-color":"var(--ast-global-color-5)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"mobile":{"background-color":"var(--ast-global-color-5)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""}},"footnotes":""},"categories":[11],"tags":[],"class_list":["post-108","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-mysql"],"uagb_featured_image_src":{"full":["https:\/\/www.veeble.com\/kb\/wp-content\/uploads\/2015\/04\/Reset-root-password-for-MySQL.jpg",1366,768,false],"thumbnail":["https:\/\/www.veeble.com\/kb\/wp-content\/uploads\/2015\/04\/Reset-root-password-for-MySQL-150x150.jpg",150,150,true],"medium":["https:\/\/www.veeble.com\/kb\/wp-content\/uploads\/2015\/04\/Reset-root-password-for-MySQL-300x169.jpg",300,169,true],"medium_large":["https:\/\/www.veeble.com\/kb\/wp-content\/uploads\/2015\/04\/Reset-root-password-for-MySQL-768x432.jpg",768,432,true],"large":["https:\/\/www.veeble.com\/kb\/wp-content\/uploads\/2015\/04\/Reset-root-password-for-MySQL-1024x576.jpg",1024,576,true],"1536x1536":["https:\/\/www.veeble.com\/kb\/wp-content\/uploads\/2015\/04\/Reset-root-password-for-MySQL.jpg",1366,768,false],"2048x2048":["https:\/\/www.veeble.com\/kb\/wp-content\/uploads\/2015\/04\/Reset-root-password-for-MySQL.jpg",1366,768,false]},"uagb_author_info":{"display_name":"Digin Dominic","author_link":"https:\/\/www.veeble.com\/kb\/author\/digin-dominic\/"},"uagb_comment_info":0,"uagb_excerpt":"You can view the MySQL root password in the file \/root\/.my.cnf. # cat \/root\/.my.cnf [client] pass=\"sdd568c~M\" user=root Want to reset the root password for […]","_links":{"self":[{"href":"https:\/\/www.veeble.com\/kb\/wp-json\/wp\/v2\/posts\/108","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.veeble.com\/kb\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.veeble.com\/kb\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.veeble.com\/kb\/wp-json\/wp\/v2\/users\/12"}],"replies":[{"embeddable":true,"href":"https:\/\/www.veeble.com\/kb\/wp-json\/wp\/v2\/comments?post=108"}],"version-history":[{"count":3,"href":"https:\/\/www.veeble.com\/kb\/wp-json\/wp\/v2\/posts\/108\/revisions"}],"predecessor-version":[{"id":8472,"href":"https:\/\/www.veeble.com\/kb\/wp-json\/wp\/v2\/posts\/108\/revisions\/8472"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.veeble.com\/kb\/wp-json\/wp\/v2\/media\/8712"}],"wp:attachment":[{"href":"https:\/\/www.veeble.com\/kb\/wp-json\/wp\/v2\/media?parent=108"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.veeble.com\/kb\/wp-json\/wp\/v2\/categories?post=108"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.veeble.com\/kb\/wp-json\/wp\/v2\/tags?post=108"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}