{"id":4626,"date":"2016-06-23T07:53:45","date_gmt":"2016-06-23T07:53:45","guid":{"rendered":"https:\/\/cpanelplesk.com\/wp62\/?p=4626"},"modified":"2021-02-04T11:00:40","modified_gmt":"2021-02-04T11:00:40","slug":"find-vesta-cp-mysql-root-password","status":"publish","type":"post","link":"https:\/\/cpanelplesk.com\/wp62\/find-vesta-cp-mysql-root-password\/","title":{"rendered":"How to find out Vesta CP MySQL root password"},"content":{"rendered":"

As you already knew it that Vesta CP \u00a0not directly show you Mysql root password right after the installation. So this is how you can find out default VestaCP MySQL root password and the correct safe way to change it .<\/p>\n

What\u2019s VestaCP MySQL root password?<\/h3>\n

By default, The password is stored at:<\/p>\n

\n
\/usr\/local\/vesta\/conf\/mysql.conf<\/pre>\n<\/div>\n
So to find out what\u2019s the password you can simply open up that file using your favorite text editor<\/p>\n
\n
nano \/usr\/local\/vesta\/conf\/mysql.conf<\/pre>\n<\/div>\n
From here you can note down the password in notepad.<\/p>\n
Changing MySQL root password in VestaCP<\/h3>\n
Basically you can simply use usual way to change MySQL root password but that\u2019s not the case with Vesta CP. There are another files you have to alter so Vesta CP can still run properly even after password changing.<\/p>\n
To change the password use this command:<\/p>\n
\n
mysqladmin -u root -pOLDPASSWORD password 'NEWPASSWORD'<\/pre>\n<\/div>\n
Replace OLD PASSWORD with the MySQL root password you get from mysql.conf<\/strong> file above. Also replace NEWPASSWORD with the new password you like, just make sure to noted down.<\/p>\n
Once done, try login back to MySQL server as root using the new password you\u2019ve just defined:<\/p>\n
\n
mysql -u root \u2013pnewpassword<\/pre>\n<\/div>\n
Now open up mysql.conf file once again and replace your old password with your new password:<\/p>\n
\n
nano \/usr\/local\/vesta\/conf\/mysql.conf<\/pre>\n<\/div>\n
Save changes and exit the editor.
\nNext, we have to change old mysql password stored in my.cnf:<\/p>\n
\n
nano \/root\/.my.cnf<\/pre>\n<\/div>\n
Replace that with the password you defined in step 1.<\/p>\n
That\u2019s all there is to do and it is that simple to find\u00a0MySQL root password in Vesta CP\u00a0.<\/p>\n
Hopefully that helps and do comment below sharing your thoughts and experiences .<\/p>\n","protected":false},"excerpt":{"rendered":"
As you already knew it that Vesta CP \u00a0not directly show you Mysql root password right after the installation. So this is how you can find out default VestaCP MySQL root password and the correct safe way to change it . […]<\/p>\n
Continue Reading…<\/a><\/p>\n","protected":false},"author":2,"featured_media":4628,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[14],"tags":[],"class_list":["post-4626","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-linux"],"yoast_head":"\nHow to find out Vesta CP MySQL root password - cPanel Plesk<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/cpanelplesk.com\/wp62\/find-vesta-cp-mysql-root-password\/\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:title\" content=\"How to find out Vesta CP MySQL root password - cPanel Plesk\" \/>\n<meta name=\"twitter:description\" content=\"As you already knew it that Vesta CP \u00a0not directly show you Mysql root password right after the installation. So this is how you can find out default VestaCP MySQL root password and the correct safe way to change it . [...]Continue Reading...\" \/>\n<meta name=\"twitter:image\" content=\"https:\/\/cpanelplesk.com\/wp62\/wp-content\/uploads\/2016\/06\/vesta-cp.jpg\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Seemab Saleem\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"1 minute\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/cpanelplesk.com\/wp62\/find-vesta-cp-mysql-root-password\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/cpanelplesk.com\/wp62\/find-vesta-cp-mysql-root-password\/\"},\"author\":{\"name\":\"Seemab Saleem\",\"@id\":\"https:\/\/cpanelplesk.com\/wp62\/#\/schema\/person\/73d573cc7eaaf6625cf0dbd72191a648\"},\"headline\":\"How to find out Vesta CP MySQL root password\",\"datePublished\":\"2016-06-23T07:53:45+00:00\",\"dateModified\":\"2021-02-04T11:00:40+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/cpanelplesk.com\/wp62\/find-vesta-cp-mysql-root-password\/\"},\"wordCount\":269,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/cpanelplesk.com\/wp62\/#\/schema\/person\/c78ae1cf9451a09592fb9697d69c0c13\"},\"image\":{\"@id\":\"https:\/\/cpanelplesk.com\/wp62\/find-vesta-cp-mysql-root-password\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/cpanelplesk.com\/wp62\/wp-content\/uploads\/2016\/06\/vesta-cp.jpg\",\"articleSection\":[\"Linux\"],\"inLanguage\":\"en-US\"},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/cpanelplesk.com\/wp62\/find-vesta-cp-mysql-root-password\/\",\"url\":\"https:\/\/cpanelplesk.com\/wp62\/find-vesta-cp-mysql-root-password\/\",\"name\":\"How to find out Vesta CP MySQL root password - cPanel Plesk\",\"isPartOf\":{\"@id\":\"https:\/\/cpanelplesk.com\/wp62\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/cpanelplesk.com\/wp62\/find-vesta-cp-mysql-root-password\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/cpanelplesk.com\/wp62\/find-vesta-cp-mysql-root-password\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/cpanelplesk.com\/wp62\/wp-content\/uploads\/2016\/06\/vesta-cp.jpg\",\"datePublished\":\"2016-06-23T07:53:45+00:00\",\"dateModified\":\"2021-02-04T11:00:40+00:00\",\"breadcrumb\":{\"@id\":\"https:\/\/cpanelplesk.com\/wp62\/find-vesta-cp-mysql-root-password\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/cpanelplesk.com\/wp62\/find-vesta-cp-mysql-root-password\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/cpanelplesk.com\/wp62\/find-vesta-cp-mysql-root-password\/#primaryimage\",\"url\":\"https:\/\/cpanelplesk.com\/wp62\/wp-content\/uploads\/2016\/06\/vesta-cp.jpg\",\"contentUrl\":\"https:\/\/cpanelplesk.com\/wp62\/wp-content\/uploads\/2016\/06\/vesta-cp.jpg\",\"width\":290,\"height\":290},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/cpanelplesk.com\/wp62\/find-vesta-cp-mysql-root-password\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/cpanelplesk.com\/wp62\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"How to find out Vesta CP MySQL root password\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/cpanelplesk.com\/wp62\/#website\",\"url\":\"https:\/\/cpanelplesk.com\/wp62\/\",\"name\":\"cPanel Plesk\",\"description\":\"Blog on famous hosting control panels\",\"publisher\":{\"@id\":\"https:\/\/cpanelplesk.com\/wp62\/#\/schema\/person\/c78ae1cf9451a09592fb9697d69c0c13\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/cpanelplesk.com\/wp62\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":[\"Person\",\"Organization\"],\"@id\":\"https:\/\/cpanelplesk.com\/wp62\/#\/schema\/person\/c78ae1cf9451a09592fb9697d69c0c13\",\"name\":\"Farooq Omer\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/cpanelplesk.com\/wp62\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/cpanelplesk.com\/wp62\/wp-content\/uploads\/2020\/11\/cpanelplesk.png\",\"contentUrl\":\"https:\/\/cpanelplesk.com\/wp62\/wp-content\/uploads\/2020\/11\/cpanelplesk.png\",\"width\":300,\"height\":44,\"caption\":\"Farooq Omer\"},\"logo\":{\"@id\":\"https:\/\/cpanelplesk.com\/wp62\/#\/schema\/person\/image\/\"}},{\"@type\":\"Person\",\"@id\":\"https:\/\/cpanelplesk.com\/wp62\/#\/schema\/person\/73d573cc7eaaf6625cf0dbd72191a648\",\"name\":\"Seemab Saleem\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/cpanelplesk.com\/wp62\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/6a87ff2e53b03e6839250e5278a6bd46?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/6a87ff2e53b03e6839250e5278a6bd46?s=96&d=mm&r=g\",\"caption\":\"Seemab Saleem\"},\"description\":\"Linux Server Administrator, Web Hosting engineer. I'm dealing with Linux servers since 2014. I started this blog to share the work i love with the world . let me know if you need any assistance. Thanks!!\",\"sameAs\":[\"https:\/\/cpanelplesk.com\/wp62\"],\"url\":\"https:\/\/cpanelplesk.com\/wp62\/author\/cmb\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"How to find out Vesta CP MySQL root password - cPanel Plesk","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/cpanelplesk.com\/wp62\/find-vesta-cp-mysql-root-password\/","twitter_card":"summary_large_image","twitter_title":"How to find out Vesta CP MySQL root password - cPanel Plesk","twitter_description":"As you already knew it that Vesta CP \u00a0not directly show you Mysql root password right after the installation. So this is how you can find out default VestaCP MySQL root password and the correct safe way to change it . [...]Continue Reading...","twitter_image":"https:\/\/cpanelplesk.com\/wp62\/wp-content\/uploads\/2016\/06\/vesta-cp.jpg","twitter_misc":{"Written by":"Seemab Saleem","Est. reading time":"1 minute"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/cpanelplesk.com\/wp62\/find-vesta-cp-mysql-root-password\/#article","isPartOf":{"@id":"https:\/\/cpanelplesk.com\/wp62\/find-vesta-cp-mysql-root-password\/"},"author":{"name":"Seemab Saleem","@id":"https:\/\/cpanelplesk.com\/wp62\/#\/schema\/person\/73d573cc7eaaf6625cf0dbd72191a648"},"headline":"How to find out Vesta CP MySQL root password","datePublished":"2016-06-23T07:53:45+00:00","dateModified":"2021-02-04T11:00:40+00:00","mainEntityOfPage":{"@id":"https:\/\/cpanelplesk.com\/wp62\/find-vesta-cp-mysql-root-password\/"},"wordCount":269,"commentCount":0,"publisher":{"@id":"https:\/\/cpanelplesk.com\/wp62\/#\/schema\/person\/c78ae1cf9451a09592fb9697d69c0c13"},"image":{"@id":"https:\/\/cpanelplesk.com\/wp62\/find-vesta-cp-mysql-root-password\/#primaryimage"},"thumbnailUrl":"https:\/\/cpanelplesk.com\/wp62\/wp-content\/uploads\/2016\/06\/vesta-cp.jpg","articleSection":["Linux"],"inLanguage":"en-US"},{"@type":"WebPage","@id":"https:\/\/cpanelplesk.com\/wp62\/find-vesta-cp-mysql-root-password\/","url":"https:\/\/cpanelplesk.com\/wp62\/find-vesta-cp-mysql-root-password\/","name":"How to find out Vesta CP MySQL root password - cPanel Plesk","isPartOf":{"@id":"https:\/\/cpanelplesk.com\/wp62\/#website"},"primaryImageOfPage":{"@id":"https:\/\/cpanelplesk.com\/wp62\/find-vesta-cp-mysql-root-password\/#primaryimage"},"image":{"@id":"https:\/\/cpanelplesk.com\/wp62\/find-vesta-cp-mysql-root-password\/#primaryimage"},"thumbnailUrl":"https:\/\/cpanelplesk.com\/wp62\/wp-content\/uploads\/2016\/06\/vesta-cp.jpg","datePublished":"2016-06-23T07:53:45+00:00","dateModified":"2021-02-04T11:00:40+00:00","breadcrumb":{"@id":"https:\/\/cpanelplesk.com\/wp62\/find-vesta-cp-mysql-root-password\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/cpanelplesk.com\/wp62\/find-vesta-cp-mysql-root-password\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/cpanelplesk.com\/wp62\/find-vesta-cp-mysql-root-password\/#primaryimage","url":"https:\/\/cpanelplesk.com\/wp62\/wp-content\/uploads\/2016\/06\/vesta-cp.jpg","contentUrl":"https:\/\/cpanelplesk.com\/wp62\/wp-content\/uploads\/2016\/06\/vesta-cp.jpg","width":290,"height":290},{"@type":"BreadcrumbList","@id":"https:\/\/cpanelplesk.com\/wp62\/find-vesta-cp-mysql-root-password\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/cpanelplesk.com\/wp62\/"},{"@type":"ListItem","position":2,"name":"How to find out Vesta CP MySQL root password"}]},{"@type":"WebSite","@id":"https:\/\/cpanelplesk.com\/wp62\/#website","url":"https:\/\/cpanelplesk.com\/wp62\/","name":"cPanel Plesk","description":"Blog on famous hosting control panels","publisher":{"@id":"https:\/\/cpanelplesk.com\/wp62\/#\/schema\/person\/c78ae1cf9451a09592fb9697d69c0c13"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/cpanelplesk.com\/wp62\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":["Person","Organization"],"@id":"https:\/\/cpanelplesk.com\/wp62\/#\/schema\/person\/c78ae1cf9451a09592fb9697d69c0c13","name":"Farooq Omer","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/cpanelplesk.com\/wp62\/#\/schema\/person\/image\/","url":"https:\/\/cpanelplesk.com\/wp62\/wp-content\/uploads\/2020\/11\/cpanelplesk.png","contentUrl":"https:\/\/cpanelplesk.com\/wp62\/wp-content\/uploads\/2020\/11\/cpanelplesk.png","width":300,"height":44,"caption":"Farooq Omer"},"logo":{"@id":"https:\/\/cpanelplesk.com\/wp62\/#\/schema\/person\/image\/"}},{"@type":"Person","@id":"https:\/\/cpanelplesk.com\/wp62\/#\/schema\/person\/73d573cc7eaaf6625cf0dbd72191a648","name":"Seemab Saleem","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/cpanelplesk.com\/wp62\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/6a87ff2e53b03e6839250e5278a6bd46?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/6a87ff2e53b03e6839250e5278a6bd46?s=96&d=mm&r=g","caption":"Seemab Saleem"},"description":"Linux Server Administrator, Web Hosting engineer. I'm dealing with Linux servers since 2014. I started this blog to share the work i love with the world . let me know if you need any assistance. Thanks!!","sameAs":["https:\/\/cpanelplesk.com\/wp62"],"url":"https:\/\/cpanelplesk.com\/wp62\/author\/cmb\/"}]}},"_links":{"self":[{"href":"https:\/\/cpanelplesk.com\/wp62\/wp-json\/wp\/v2\/posts\/4626","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/cpanelplesk.com\/wp62\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/cpanelplesk.com\/wp62\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/cpanelplesk.com\/wp62\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/cpanelplesk.com\/wp62\/wp-json\/wp\/v2\/comments?post=4626"}],"version-history":[{"count":0,"href":"https:\/\/cpanelplesk.com\/wp62\/wp-json\/wp\/v2\/posts\/4626\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/cpanelplesk.com\/wp62\/wp-json\/wp\/v2\/media\/4628"}],"wp:attachment":[{"href":"https:\/\/cpanelplesk.com\/wp62\/wp-json\/wp\/v2\/media?parent=4626"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/cpanelplesk.com\/wp62\/wp-json\/wp\/v2\/categories?post=4626"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/cpanelplesk.com\/wp62\/wp-json\/wp\/v2\/tags?post=4626"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}