{"id":1008,"date":"2021-07-23T12:43:17","date_gmt":"2021-07-23T12:43:17","guid":{"rendered":"https:\/\/ssdsunucum.com\/blog\/mysql-root-password\/"},"modified":"2021-07-23T12:43:17","modified_gmt":"2021-07-23T12:43:17","slug":"mysql-root-password","status":"publish","type":"post","link":"https:\/\/ssdsunucum.com\/blog\/mysql-root-password\/","title":{"rendered":"MySQL Root Password"},"content":{"rendered":"<\/p>\n
\n
\n
\n

Valid for versions 82 through the latest version<\/em><\/p>\n<\/div>\n

\n

Version:<\/h4>\n

82<\/h4>\n<\/div><\/div>\n
\n

Overview<\/h2>\n

This interface allows you to set the MySQL\u00ae root password.<\/p>\n

\n
Warning:<\/div>\n
\n
    \n
  • \n

    Ensure that you set a complex password. If an attacker were to compromise this password, they would have access to any of your server\u2019s databases.<\/p>\n<\/li>\n

  • \n

    By default, cPanel & WHM\u2019s implementation of MySQL stores the MySQL root account password in the \/root\/.my.cnf<\/code> configuration file. Do not<\/strong> edit this file manually.<\/p>\n<\/li>\n<\/ul><\/div>\n<\/div>\n

    \n
    Note:<\/div>\n
    \n You do not<\/strong> need to remember this password unless you plan to log in to MySQL as the root<\/code> user.\n <\/div>\n<\/div>\n

    Create password<\/h2>\n

    To set the MySQL root<\/code> password, perform the following steps:<\/p>\n

      \n
    1. \n

      Enter and confirm the new password in the appropriate text boxes. <\/p>\n

      \n
      Note:<\/div>\n
      \n
        \n
      • The system evaluates the password that you enter on a scale of 100 points. 0<\/code> indicates a weak password, while 100<\/code> indicates a very secure password.<\/li>\n
      • Some web hosts require a minimum password strength. A green password Strength<\/em> meter indicates that the password is equal to or greater than the required password strength.<\/li>\n
      • Click Password Generator<\/em> to generate a strong password. For more information, read our Password & Security<\/em> documentation.<\/li>\n<\/ul><\/div>\n<\/div>\n
        \n
        Warning:<\/div>\n
        \n Do not<\/strong> use asterisks ( *<\/code> ), periods ( .<\/code> ), or any other special characters in your MySQL root password. If you do, phpMyAdmin will not function. If you use the Password Generator<\/em> feature, select the Numbers<\/em> button under advanced<\/em>.\n <\/div>\n<\/div>\n<\/li>\n
      • \n

        Click Change Password<\/em>.<\/p>\n<\/li>\n<\/ol>\n

        Remote MySQL<\/h2>\n

        If you use a remote MySQL server, you must<\/strong> choose whether you change the local or the remote server\u2019s root password. By default, the system selects the remote MySQL server. <\/p>\n

        \n
        Note:<\/div>\n
        \n

        When the remote MySQL server is also a cPanel & WHM server, you must<\/strong> perform additional steps:<\/p>\n

          \n
        • \n

          If you change the remote MySQL root password on the hosting server, you must<\/strong> update the remote MySQL server\u2019s \/root\/.my.cnf<\/code> configuration file.<\/p>\n<\/li>\n

        • \n

          If you change the remote MySQL root password on the remote MySQL server, you must<\/strong> update the MySQL profile on the hosting server, and then reactivate the profile.<\/p>\n<\/li>\n<\/ul><\/div>\n<\/div>\n

          \n
          More:<\/div>\n
          \n

          For more information, read our Troubleshoot MySQL\u00ae Profiles documentation.<\/p>\n<\/p><\/div>\n<\/div><\/div>\n","protected":false},"excerpt":{"rendered":"

          Valid for versions 82 through the latest version Version: 82 Overview This interface allows you to set the MySQL\u00ae root password. Warning: Ensure that you set a complex password. If an attacker were to compromise this password, they would have access to any of your server\u2019s databases. By default, cPanel & WHM\u2019s implementation of MySQL …<\/p>\n","protected":false},"author":1,"featured_media":1009,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":[],"categories":[1],"tags":[],"amp_enabled":true,"_links":{"self":[{"href":"https:\/\/ssdsunucum.com\/blog\/wp-json\/wp\/v2\/posts\/1008"}],"collection":[{"href":"https:\/\/ssdsunucum.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/ssdsunucum.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/ssdsunucum.com\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/ssdsunucum.com\/blog\/wp-json\/wp\/v2\/comments?post=1008"}],"version-history":[{"count":0,"href":"https:\/\/ssdsunucum.com\/blog\/wp-json\/wp\/v2\/posts\/1008\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/ssdsunucum.com\/blog\/wp-json\/wp\/v2\/media\/1009"}],"wp:attachment":[{"href":"https:\/\/ssdsunucum.com\/blog\/wp-json\/wp\/v2\/media?parent=1008"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/ssdsunucum.com\/blog\/wp-json\/wp\/v2\/categories?post=1008"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/ssdsunucum.com\/blog\/wp-json\/wp\/v2\/tags?post=1008"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}