{"id":692,"date":"2014-12-29T12:12:32","date_gmt":"2014-12-29T19:12:32","guid":{"rendered":"http:\/\/homepages.uc.edu\/~yaozo\/wordpress\/?p=692"},"modified":"2014-12-29T12:12:32","modified_gmt":"2014-12-29T19:12:32","slug":"how-to-edit-the-mysql-my-cnf-file","status":"publish","type":"post","link":"https:\/\/zhuoyao.net\/index.php\/2014\/12\/29\/how-to-edit-the-mysql-my-cnf-file\/","title":{"rendered":"How to edit the MySQL my.cnf file"},"content":{"rendered":"

VPS and Dedicated server customers with root access<\/a> can change their MySQL settings in the my.cnf<\/strong> file. To do this, you simply log in the server and edit the my.cnf file using Nano. This article will explain the steps to view and edit your my.cnf file.<\/p>\n

How to view MySQL settings in the my.cnf file<\/h2>\n
    \n
  1. Login to your server via SSH<\/strong><\/a><\/li>\n
  2. To view the MySQL my.cnf settings type the following<\/strong>:\n
    cat \/etc\/my.cnf<\/pre>\n
    <\/div>\n
    \"edit-my-cnf-1-cat\"<\/a>The contents of the my.cnf file will display similar to the snapshot to the right.<\/li>\n<\/ol>\n
    Editing the MySQL my.cnf file<\/h2>\n
      \n
    1. Login to your server via SSH<\/strong><\/a><\/li>\n
    2. \"image-moodle\"<\/a>To edit the MySQL settings with nano type the following<\/strong>:\n
      nano \/etc\/my.cnf<\/pre>\n
      Note!<\/strong> There are several editors you can use in shell. Nano, Vim, or Emacs. This article will focus only on Nano.<\/p>\n<\/li>\n
    3. \"Nano<\/a>Find the line to edit. <\/strong>For example, if you want to edit the max_connections, find the following line.\n
      max_connections=100<\/pre>\n
      \"Changing<\/a>To increase the max_connections to 110 change it to the following.<\/p>\n
      max_connections=110<\/pre>\n<\/li>\n
    4. Enter Ctrl + O<\/strong> to “WriteOut<\/em>” or save the settings.<\/li>\n
    5. Then Ctrl + X to exit<\/strong>.<\/li>\n
    6. Restart MySQL <\/strong>by typing the following.\n
      service mysql restart<\/pre>\n
      Now the max_connections is increased to 110 instead of 100.<\/li>\n<\/ol>\n
      Viewing the MySQL variables through shell.<\/h2>\n
        \n
      1. Login to your server via SSH<\/strong><\/a><\/li>\n
      2. \"Viewing<\/a>Type the following command.\n
        mysqladmin variables<\/pre>\n
        The variables will display similar to the snapshot to the right.<\/li>\n<\/ol>\n
        Viewing MySQL variables in PhpMyAdmin<\/h2>\n
          \n
        1. Log into your phpMyAdmin<\/a><\/strong><\/li>\n
        2. \"Click<\/a>Click the Variables tab<\/strong> at the top right.
          \n          \"PhpMyAdmin<\/a>PhpMyAdmin will list all the variables and there settings on your server..<\/li>\n<\/ol>\n
           <\/p>\n","protected":false},"excerpt":{"rendered":"
          VPS and Dedicated server customers with root access can change their MySQL settings in the my.cnf file. To do this, you simply log in the… <\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[15],"tags":[],"class_list":["post-692","post","type-post","status-publish","format-standard","hentry","category-mysql"],"_links":{"self":[{"href":"https:\/\/zhuoyao.net\/index.php\/wp-json\/wp\/v2\/posts\/692","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/zhuoyao.net\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/zhuoyao.net\/index.php\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/zhuoyao.net\/index.php\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/zhuoyao.net\/index.php\/wp-json\/wp\/v2\/comments?post=692"}],"version-history":[{"count":0,"href":"https:\/\/zhuoyao.net\/index.php\/wp-json\/wp\/v2\/posts\/692\/revisions"}],"wp:attachment":[{"href":"https:\/\/zhuoyao.net\/index.php\/wp-json\/wp\/v2\/media?parent=692"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/zhuoyao.net\/index.php\/wp-json\/wp\/v2\/categories?post=692"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/zhuoyao.net\/index.php\/wp-json\/wp\/v2\/tags?post=692"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}