{"id":502,"date":"2020-12-28T11:33:00","date_gmt":"2020-12-28T16:33:00","guid":{"rendered":"https:\/\/www.inmotionhosting.com\/support\/2012\/12\/28\/edit-mysql-my-cnf\/"},"modified":"2021-08-16T15:27:27","modified_gmt":"2021-08-16T19:27:27","slug":"edit-mysql-my-cnf","status":"publish","type":"post","link":"https:\/\/www.inmotionhosting.com\/support\/server\/databases\/edit-mysql-my-cnf\/","title":{"rendered":"How to Edit the MySQL my.cnf File"},"content":{"rendered":"<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"538\" src=\"https:\/\/www.inmotionhosting.com\/support\/wp-content\/uploads\/2020\/12\/Support-Center-Heros-1024x538.png\" alt=\"How to Edit the MySQL my.cnf File\" class=\"wp-image-65934\" srcset=\"https:\/\/www.inmotionhosting.com\/support\/wp-content\/uploads\/2020\/12\/Support-Center-Heros-1024x538.png 1024w, https:\/\/www.inmotionhosting.com\/support\/wp-content\/uploads\/2020\/12\/Support-Center-Heros-300x158.png 300w, https:\/\/www.inmotionhosting.com\/support\/wp-content\/uploads\/2020\/12\/Support-Center-Heros-768x403.png 768w, https:\/\/www.inmotionhosting.com\/support\/wp-content\/uploads\/2020\/12\/Support-Center-Heros.png 1200w\" sizes=\"auto, (min-width: 1360px) 876px, (min-width: 960px) calc(61.58vw + 51px), calc(100vw - 80px)\" \/><\/figure>\n\n\n\n<p>In this guide, we\u2019ll show you how to make changes to your database settings in the MySQL\u00a0<strong>my.cnf<\/strong>\u00a0file. For example, you may need to increase the number of <em>max_connections<\/em> or the <em>query_cache_size<\/em> value for your server.<\/p>\n\n\n\n<p>To do this, you simply log in the server via SSH and\u00a0edit\u00a0the\u00a0<strong>my.cnf<\/strong>\u00a0file using an editor such as Nano. This article will explain the steps to view and edit your my.cnf file. We\u2019ll also show you how to view your MySQL variables through SSH then how to access them in phpMyAdmin, where they can be edited.<\/p>\n\n\n\n<p class=\"alert alert-danger\">You will need\u00a0<a rel=\"noreferrer noopener\" href=\"https:\/\/www.inmotionhosting.com\/support\/amp\/obtain-root-access\/\" target=\"_blank\">root access<\/a>\u00a0to our VPS or Dedicated server to follow this guide.<\/p>\n\n\n\n<ul class=\"wp-block-list\"><li><a href=\"#view-mysql-settings\">How to View Mysql Settings in the my.cnf File<\/a><\/li><li><a href=\"#edit-mysql\">Editing the Mysql my.cnf File<\/a><\/li><li><a href=\"#view-mysql-variables-ssh\">Viewing the Mysql Variables Through Shell<\/a><\/li><li><a href=\"#view-mysql-variables\">Viewing MySQL Variables in phpMyAdmin<\/a><\/li><\/ul>\n\n\n<div class=\"jumbotron\" style=\"text-align:center;\">\r\n<p style=\"font-size: 20px;\"><strong>Scalable VPS Infrastructure, Fully Managed<\/strong><\/p>\r\n<p>When shared hosting can't handle your traffic, VPS delivers dedicated resources that scale with demand. Our team manages the technical complexity while you manage your business.<\/p>\r\n<p><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/design.inmotionhosting.com\/assets\/icons\/standard\/check-blue.svg\" alt=\"check mark\" width=\"24\" height=\"24\" \/>NVMe Storage &nbsp;&nbsp; <img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/design.inmotionhosting.com\/assets\/icons\/standard\/check-blue.svg\" alt=\"check mark\" width=\"24\" height=\"24\" \/>High-Availability &nbsp;&nbsp; <img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/design.inmotionhosting.com\/assets\/icons\/standard\/check-blue.svg\" alt=\"check mark\" width=\"24\" height=\"24\" \/>Ironclad Security &nbsp;&nbsp; <img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/design.inmotionhosting.com\/assets\/icons\/standard\/check-blue.svg\" alt=\"check mark\" width=\"24\" height=\"24\" \/>Premium Support<\/p>\r\n<p><a class=\"btn btn-primary btn-lg\" href=\"https:\/\/www.inmotionhosting.com\/vps-hosting?mktgp=t&irgwc=1&affiliates=5001860&utm_campaign=Jumbotron&utm_source=supportcenter&utm_medium=cta&utm_term=vps-cta2\">VPS Hosting<\/a><\/p>\r\n<\/div>\n\n\n\n<figure class=\"wp-block-embed is-type-video is-provider-youtube wp-block-embed-youtube wp-embed-aspect-16-9 wp-has-aspect-ratio\"><div class=\"wp-block-embed__wrapper\">\n<div class=\"jetpack-video-wrapper\"><div class=\"yt-YHA6g3iMy_k\">\n\t<a class=\"play-video-YHA6g3iMy_k\" style=\"position: relative; display: flex; flex-wrap: wrap; align-items: center; cursor: pointer;\">\n\t\t<img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/i.ytimg.com\/vi_webp\/YHA6g3iMy_k\/maxresdefault.webp\" width=\"1280\" height=\"720\" alt=\"How to Edit the MySQL my.cnf File\" style=\"width: 100%; height: auto;\">\n\t\t<span class=\"fa fa-imh-play-circle imh-ds-icon play-circle\" style=\"position: absolute; display:block; font-size:150px; color: #c52228; opacity:0;\"><\/span>\n\t<\/a>\n<\/div><\/div>\n<\/div><figcaption>Don\u2019t have time to read the article. Watch our video tutorial here.<\/figcaption><\/figure>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"view-mysql-settings\">How to View Mysql Settings in the my.cnf File<\/h2>\n\n\n\n<ol class=\"article_list wp-block-list\"><li><a aria-label=\" (opens in a new tab)\" rel=\"noreferrer noopener\" href=\"https:\/\/www.inmotionhosting.com\/support\/server\/ssh\/how-to-login-ssh\/\" target=\"_blank\"><strong>Login to your server via SSH<\/strong><\/a><\/li><li>To view the MySQL my.cnf settings\u00a0<strong>type the following<\/strong>:<br><pre>cat \/etc\/my.cnf<\/pre><br><img loading=\"lazy\" decoding=\"async\" width=\"750\" height=\"541\" class=\"wp-image-65905\" style=\"width: 750px;\" src=\"https:\/\/www.inmotionhosting.com\/support\/wp-content\/uploads\/2012\/12\/view-mysql-settings.png\" alt=\"Viewing your MySQL Settings in SSH\" srcset=\"https:\/\/www.inmotionhosting.com\/support\/wp-content\/uploads\/2012\/12\/view-mysql-settings.png 593w, https:\/\/www.inmotionhosting.com\/support\/wp-content\/uploads\/2012\/12\/view-mysql-settings-300x217.png 300w\" sizes=\"auto, (min-width: 1360px) 876px, (min-width: 960px) calc(61.58vw + 51px), calc(100vw - 80px)\" \/><br>The contents of the my.cnf file will display similar to the snapshot above.<\/li><\/ol>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"edit-mysql\">Editing the Mysql my.cnf File<\/h2>\n\n\n\n<ol class=\"article_list wp-block-list\"><li><strong><a href=\"https:\/\/www.inmotionhosting.com\/support\/server\/ssh\/how-to-login-ssh\/\" target=\"_blank\" aria-label=\" (opens in a new tab)\" rel=\"noreferrer noopener\">Login to your server via SSH<\/a><\/strong>.<\/li><li>To edit the MySQL settings with nano\u00a0<strong>type the following<\/strong>:<br><pre>nano \/etc\/my.cnf<\/pre><br><div class=\"alert alert-info\">There are several editors you can use in shell. Nano, Vim, or Emacs. This article will focus only on Nano.<\/div><br><img loading=\"lazy\" decoding=\"async\" width=\"750\" height=\"563\" class=\"wp-image-65914\" style=\"width: 750px;\" src=\"https:\/\/www.inmotionhosting.com\/support\/wp-content\/uploads\/2012\/12\/edit-mysql-file.png\" alt=\"Editing your my.cnf via SSH\" srcset=\"https:\/\/www.inmotionhosting.com\/support\/wp-content\/uploads\/2012\/12\/edit-mysql-file.png 606w, https:\/\/www.inmotionhosting.com\/support\/wp-content\/uploads\/2012\/12\/edit-mysql-file-300x225.png 300w\" sizes=\"auto, (min-width: 1360px) 876px, (min-width: 960px) calc(61.58vw + 51px), calc(100vw - 80px)\" \/><\/li><li><strong>Find the line to edit.\u00a0<\/strong>For example, if you want to edit the max_connections, find the following line.<br><code>max_connections=100<\/code><br><img loading=\"lazy\" decoding=\"async\" width=\"750\" height=\"676\" class=\"wp-image-65915\" style=\"width: 750px;\" src=\"https:\/\/www.inmotionhosting.com\/support\/wp-content\/uploads\/2012\/12\/nano-view-max-connections.png\" alt=\"Nano view of my.cnf max connections\" srcset=\"https:\/\/www.inmotionhosting.com\/support\/wp-content\/uploads\/2012\/12\/nano-view-max-connections.png 384w, https:\/\/www.inmotionhosting.com\/support\/wp-content\/uploads\/2012\/12\/nano-view-max-connections-300x270.png 300w\" sizes=\"auto, (min-width: 1360px) 876px, (min-width: 960px) calc(61.58vw + 51px), calc(100vw - 80px)\" \/><\/li><li>To increase the max_connections to 110 change it to the following.<br><code>max_connections=110<\/code><\/li><li><strong>Enter Ctrl + O<\/strong>\u00a0to \u201c<em>WriteOut<\/em>\u201d or save the settings.<\/li><li>Then\u00a0<strong>Ctrl + X to exit<\/strong>.<\/li><li><strong>Restart MySQL\u00a0<\/strong>by typing the following.<br><pre>service mysql restart<\/pre><br>Now the max_connections is increased to 110 instead of 100.<\/li><\/ol>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"view-mysql-variables-ssh\">Viewing the Mysql Variables Through Shell<\/h2>\n\n\n\n<figure class=\"wp-block-embed is-type-video is-provider-youtube wp-block-embed-youtube wp-embed-aspect-16-9 wp-has-aspect-ratio\"><div class=\"wp-block-embed__wrapper\">\n<div class=\"jetpack-video-wrapper\"><div class=\"yt-5ti2DQHhquM\">\n\t<a class=\"play-video-5ti2DQHhquM\" style=\"position: relative; display: flex; flex-wrap: wrap; align-items: center; cursor: pointer;\">\n\t\t<img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/i.ytimg.com\/vi_webp\/5ti2DQHhquM\/maxresdefault.webp\" width=\"1280\" height=\"720\" alt=\"How to View MySQL Variables with SSH &amp; phpMyAdmin\" style=\"width: 100%; height: auto;\">\n\t\t<span class=\"fa fa-imh-play-circle imh-ds-icon play-circle\" style=\"position: absolute; display:block; font-size:150px; color: #c52228; opacity:0;\"><\/span>\n\t<\/a>\n<\/div><\/div>\n<\/div><\/figure>\n\n\n\n<ol class=\"article_list wp-block-list\"><li><strong><a aria-label=\" (opens in a new tab)\" href=\"https:\/\/www.inmotionhosting.com\/support\/server\/ssh\/how-to-login-ssh\/\" target=\"_blank\" rel=\"noreferrer noopener\">Login to your server via SSH<\/a><\/strong>.<\/li><li>Type the following command.<br><pre>mysqladmin variables<\/pre><br><img loading=\"lazy\" decoding=\"async\" width=\"750\" height=\"696\" class=\"wp-image-65918\" style=\"width: 750px;\" src=\"https:\/\/www.inmotionhosting.com\/support\/wp-content\/uploads\/2012\/12\/mysql-variables.png\" alt=\"View of MySQL Variables\" srcset=\"https:\/\/www.inmotionhosting.com\/support\/wp-content\/uploads\/2012\/12\/mysql-variables.png 601w, https:\/\/www.inmotionhosting.com\/support\/wp-content\/uploads\/2012\/12\/mysql-variables-300x279.png 300w\" sizes=\"auto, (min-width: 1360px) 876px, (min-width: 960px) calc(61.58vw + 51px), calc(100vw - 80px)\" \/><br>The variables will display similar to the snapshot above.<\/li><\/ol>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"view-mysql-variables\">Viewing MySQL Variables in phpMyAdmin<\/h2>\n\n\n\n<ol class=\"article_list wp-block-list\"><li><strong>Log into your\u00a0<a aria-label=\" (opens in a new tab)\" rel=\"noreferrer noopener\" href=\"https:\/\/www.inmotionhosting.com\/support\/edu\/cpanel\/manage-mysql-database-in-phpmyadmin\/\" target=\"_blank\">phpMyAdmin<\/a><\/strong>.<\/li><li>Click the <strong>Variables <\/strong>tab\u00a0at the top right. Then PhpMyAdmin will list all the variables and their settings on your server.<br><img loading=\"lazy\" decoding=\"async\" width=\"750\" height=\"588\" class=\"wp-image-65922\" style=\"width: 750px;\" src=\"https:\/\/www.inmotionhosting.com\/support\/wp-content\/uploads\/2012\/12\/mysql-variables-in-phpmyadmin.png\" alt=\"View of MySQL Variables in PhpMyAdmin\" srcset=\"https:\/\/www.inmotionhosting.com\/support\/wp-content\/uploads\/2012\/12\/mysql-variables-in-phpmyadmin.png 796w, https:\/\/www.inmotionhosting.com\/support\/wp-content\/uploads\/2012\/12\/mysql-variables-in-phpmyadmin-300x235.png 300w, https:\/\/www.inmotionhosting.com\/support\/wp-content\/uploads\/2012\/12\/mysql-variables-in-phpmyadmin-768x602.png 768w\" sizes=\"auto, (min-width: 1360px) 876px, (min-width: 960px) calc(61.58vw + 51px), calc(100vw - 80px)\" \/><\/li><li>If you want to edit the values, you should edit the my.cnf file as described above.<\/li><\/ol>\n\n\n\n<p>Now you know how to edit your database settings in the MySQL my.cnf file and view database variables. For more guides check out our full section on <a aria-label=\"Working with Databases (opens in a new tab)\" href=\"https:\/\/www.inmotionhosting.com\/support\/server\/databases\/\" target=\"_blank\" rel=\"noreferrer noopener\">Working with Databases<\/a>.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>In this guide, we\u2019ll show you how to make changes to your database settings in the MySQL\u00a0my.cnf\u00a0file. For example, you may need to increase the number of max_connections or the query_cache_size value for your server. To do this, you simply log in the server via SSH and\u00a0edit\u00a0the\u00a0my.cnf\u00a0file using an editor such as Nano. This article<a class=\"moretag\" href=\"https:\/\/www.inmotionhosting.com\/support\/server\/databases\/edit-mysql-my-cnf\/\"> Read More ><\/a><\/p>\n","protected":false},"author":3,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"_jetpack_memberships_contains_paid_content":false,"footnotes":""},"categories":[4305],"tags":[],"class_list":["post-502","post","type-post","status-publish","format-standard","hentry","category-databases"],"acf":[],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v27.1.1 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>How to Edit the MySQL my.cnf File | InMotion Hosting<\/title>\n<meta name=\"description\" content=\"Users with root access can edit their my.cnf through shell. This will explain how.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.inmotionhosting.com\/support\/server\/databases\/edit-mysql-my-cnf\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"How to Edit the MySQL my.cnf File | InMotion Hosting\" \/>\n<meta property=\"og:description\" content=\"Users with root access can edit their my.cnf through shell. This will explain how.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.inmotionhosting.com\/support\/server\/databases\/edit-mysql-my-cnf\/\" \/>\n<meta property=\"og:site_name\" content=\"InMotion Hosting Support Center\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/inmotionhosting\/\" \/>\n<meta property=\"article:published_time\" content=\"2020-12-28T16:33:00+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2021-08-16T19:27:27+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.inmotionhosting.com\/support\/wp-content\/uploads\/2020\/12\/Support-Center-Heros.png\" \/>\n\t<meta property=\"og:image:width\" content=\"1200\" \/>\n\t<meta property=\"og:image:height\" content=\"630\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/png\" \/>\n<meta name=\"author\" content=\"InMotion Hosting Contributor\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:creator\" content=\"@https:\/\/twitter.com\/InMotionHosting\" \/>\n<meta name=\"twitter:site\" content=\"@InMotionHosting\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"InMotion Hosting Contributor\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"2 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/www.inmotionhosting.com\/support\/server\/databases\/edit-mysql-my-cnf\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/www.inmotionhosting.com\/support\/server\/databases\/edit-mysql-my-cnf\/\"},\"author\":{\"name\":\"InMotion Hosting Contributor\",\"@id\":\"https:\/\/www.inmotionhosting.com\/support\/#\/schema\/person\/5fbfcaed32a2672fb83ab312f5b7237b\"},\"headline\":\"How to Edit the MySQL my.cnf File\",\"datePublished\":\"2020-12-28T16:33:00+00:00\",\"dateModified\":\"2021-08-16T19:27:27+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/www.inmotionhosting.com\/support\/server\/databases\/edit-mysql-my-cnf\/\"},\"wordCount\":440,\"commentCount\":11,\"publisher\":{\"@id\":\"https:\/\/www.inmotionhosting.com\/support\/#organization\"},\"image\":{\"@id\":\"https:\/\/www.inmotionhosting.com\/support\/server\/databases\/edit-mysql-my-cnf\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.inmotionhosting.com\/support\/wp-content\/uploads\/2020\/12\/Support-Center-Heros-1024x538.png\",\"articleSection\":[\"Working with Databases\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/www.inmotionhosting.com\/support\/server\/databases\/edit-mysql-my-cnf\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.inmotionhosting.com\/support\/server\/databases\/edit-mysql-my-cnf\/\",\"url\":\"https:\/\/www.inmotionhosting.com\/support\/server\/databases\/edit-mysql-my-cnf\/\",\"name\":\"How to Edit the MySQL my.cnf File | InMotion Hosting\",\"isPartOf\":{\"@id\":\"https:\/\/www.inmotionhosting.com\/support\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/www.inmotionhosting.com\/support\/server\/databases\/edit-mysql-my-cnf\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/www.inmotionhosting.com\/support\/server\/databases\/edit-mysql-my-cnf\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.inmotionhosting.com\/support\/wp-content\/uploads\/2020\/12\/Support-Center-Heros-1024x538.png\",\"datePublished\":\"2020-12-28T16:33:00+00:00\",\"dateModified\":\"2021-08-16T19:27:27+00:00\",\"description\":\"Users with root access can edit their my.cnf through shell. This will explain how.\",\"breadcrumb\":{\"@id\":\"https:\/\/www.inmotionhosting.com\/support\/server\/databases\/edit-mysql-my-cnf\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.inmotionhosting.com\/support\/server\/databases\/edit-mysql-my-cnf\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.inmotionhosting.com\/support\/server\/databases\/edit-mysql-my-cnf\/#primaryimage\",\"url\":\"https:\/\/www.inmotionhosting.com\/support\/wp-content\/uploads\/2020\/12\/Support-Center-Heros.png\",\"contentUrl\":\"https:\/\/www.inmotionhosting.com\/support\/wp-content\/uploads\/2020\/12\/Support-Center-Heros.png\",\"width\":1200,\"height\":630,\"caption\":\"How to Edit the MySQL my.cnf File\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.inmotionhosting.com\/support\/server\/databases\/edit-mysql-my-cnf\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.inmotionhosting.com\/support\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"How to Edit the MySQL my.cnf File\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.inmotionhosting.com\/support\/#website\",\"url\":\"https:\/\/www.inmotionhosting.com\/support\/\",\"name\":\"InMotion Hosting Support Center\",\"description\":\"Web Hosting Support &amp; Tutorials\",\"publisher\":{\"@id\":\"https:\/\/www.inmotionhosting.com\/support\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/www.inmotionhosting.com\/support\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/www.inmotionhosting.com\/support\/#organization\",\"name\":\"InMotion Hosting\",\"url\":\"https:\/\/www.inmotionhosting.com\/support\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.inmotionhosting.com\/support\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/www.inmotionhosting.com\/support\/wp-content\/uploads\/2023\/02\/inmotion-hosting-logo-yoast.jpg\",\"contentUrl\":\"https:\/\/www.inmotionhosting.com\/support\/wp-content\/uploads\/2023\/02\/inmotion-hosting-logo-yoast.jpg\",\"width\":696,\"height\":696,\"caption\":\"InMotion Hosting\"},\"image\":{\"@id\":\"https:\/\/www.inmotionhosting.com\/support\/#\/schema\/logo\/image\/\"},\"sameAs\":[\"https:\/\/www.facebook.com\/inmotionhosting\/\",\"https:\/\/x.com\/InMotionHosting\"]},{\"@type\":\"Person\",\"@id\":\"https:\/\/www.inmotionhosting.com\/support\/#\/schema\/person\/5fbfcaed32a2672fb83ab312f5b7237b\",\"name\":\"InMotion Hosting Contributor\",\"description\":\"InMotion Hosting contributors are highly knowledgeable individuals who create relevant content on new trends and troubleshooting techniques to help you achieve your online goals!\",\"sameAs\":[\"https:\/\/www.linkedin.com\/company\/inmotion-hosting\/\",\"https:\/\/x.com\/https:\/\/twitter.com\/InMotionHosting\"],\"url\":\"https:\/\/www.inmotionhosting.com\/support\/author\/john-paul\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"How to Edit the MySQL my.cnf File | InMotion Hosting","description":"Users with root access can edit their my.cnf through shell. This will explain how.","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:\/\/www.inmotionhosting.com\/support\/server\/databases\/edit-mysql-my-cnf\/","og_locale":"en_US","og_type":"article","og_title":"How to Edit the MySQL my.cnf File | InMotion Hosting","og_description":"Users with root access can edit their my.cnf through shell. This will explain how.","og_url":"https:\/\/www.inmotionhosting.com\/support\/server\/databases\/edit-mysql-my-cnf\/","og_site_name":"InMotion Hosting Support Center","article_publisher":"https:\/\/www.facebook.com\/inmotionhosting\/","article_published_time":"2020-12-28T16:33:00+00:00","article_modified_time":"2021-08-16T19:27:27+00:00","og_image":[{"width":1200,"height":630,"url":"https:\/\/www.inmotionhosting.com\/support\/wp-content\/uploads\/2020\/12\/Support-Center-Heros.png","type":"image\/png"}],"author":"InMotion Hosting Contributor","twitter_card":"summary_large_image","twitter_creator":"@https:\/\/twitter.com\/InMotionHosting","twitter_site":"@InMotionHosting","twitter_misc":{"Written by":"InMotion Hosting Contributor","Est. reading time":"2 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.inmotionhosting.com\/support\/server\/databases\/edit-mysql-my-cnf\/#article","isPartOf":{"@id":"https:\/\/www.inmotionhosting.com\/support\/server\/databases\/edit-mysql-my-cnf\/"},"author":{"name":"InMotion Hosting Contributor","@id":"https:\/\/www.inmotionhosting.com\/support\/#\/schema\/person\/5fbfcaed32a2672fb83ab312f5b7237b"},"headline":"How to Edit the MySQL my.cnf File","datePublished":"2020-12-28T16:33:00+00:00","dateModified":"2021-08-16T19:27:27+00:00","mainEntityOfPage":{"@id":"https:\/\/www.inmotionhosting.com\/support\/server\/databases\/edit-mysql-my-cnf\/"},"wordCount":440,"commentCount":11,"publisher":{"@id":"https:\/\/www.inmotionhosting.com\/support\/#organization"},"image":{"@id":"https:\/\/www.inmotionhosting.com\/support\/server\/databases\/edit-mysql-my-cnf\/#primaryimage"},"thumbnailUrl":"https:\/\/www.inmotionhosting.com\/support\/wp-content\/uploads\/2020\/12\/Support-Center-Heros-1024x538.png","articleSection":["Working with Databases"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/www.inmotionhosting.com\/support\/server\/databases\/edit-mysql-my-cnf\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.inmotionhosting.com\/support\/server\/databases\/edit-mysql-my-cnf\/","url":"https:\/\/www.inmotionhosting.com\/support\/server\/databases\/edit-mysql-my-cnf\/","name":"How to Edit the MySQL my.cnf File | InMotion Hosting","isPartOf":{"@id":"https:\/\/www.inmotionhosting.com\/support\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.inmotionhosting.com\/support\/server\/databases\/edit-mysql-my-cnf\/#primaryimage"},"image":{"@id":"https:\/\/www.inmotionhosting.com\/support\/server\/databases\/edit-mysql-my-cnf\/#primaryimage"},"thumbnailUrl":"https:\/\/www.inmotionhosting.com\/support\/wp-content\/uploads\/2020\/12\/Support-Center-Heros-1024x538.png","datePublished":"2020-12-28T16:33:00+00:00","dateModified":"2021-08-16T19:27:27+00:00","description":"Users with root access can edit their my.cnf through shell. This will explain how.","breadcrumb":{"@id":"https:\/\/www.inmotionhosting.com\/support\/server\/databases\/edit-mysql-my-cnf\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.inmotionhosting.com\/support\/server\/databases\/edit-mysql-my-cnf\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.inmotionhosting.com\/support\/server\/databases\/edit-mysql-my-cnf\/#primaryimage","url":"https:\/\/www.inmotionhosting.com\/support\/wp-content\/uploads\/2020\/12\/Support-Center-Heros.png","contentUrl":"https:\/\/www.inmotionhosting.com\/support\/wp-content\/uploads\/2020\/12\/Support-Center-Heros.png","width":1200,"height":630,"caption":"How to Edit the MySQL my.cnf File"},{"@type":"BreadcrumbList","@id":"https:\/\/www.inmotionhosting.com\/support\/server\/databases\/edit-mysql-my-cnf\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.inmotionhosting.com\/support\/"},{"@type":"ListItem","position":2,"name":"How to Edit the MySQL my.cnf File"}]},{"@type":"WebSite","@id":"https:\/\/www.inmotionhosting.com\/support\/#website","url":"https:\/\/www.inmotionhosting.com\/support\/","name":"InMotion Hosting Support Center","description":"Web Hosting Support &amp; Tutorials","publisher":{"@id":"https:\/\/www.inmotionhosting.com\/support\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.inmotionhosting.com\/support\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/www.inmotionhosting.com\/support\/#organization","name":"InMotion Hosting","url":"https:\/\/www.inmotionhosting.com\/support\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.inmotionhosting.com\/support\/#\/schema\/logo\/image\/","url":"https:\/\/www.inmotionhosting.com\/support\/wp-content\/uploads\/2023\/02\/inmotion-hosting-logo-yoast.jpg","contentUrl":"https:\/\/www.inmotionhosting.com\/support\/wp-content\/uploads\/2023\/02\/inmotion-hosting-logo-yoast.jpg","width":696,"height":696,"caption":"InMotion Hosting"},"image":{"@id":"https:\/\/www.inmotionhosting.com\/support\/#\/schema\/logo\/image\/"},"sameAs":["https:\/\/www.facebook.com\/inmotionhosting\/","https:\/\/x.com\/InMotionHosting"]},{"@type":"Person","@id":"https:\/\/www.inmotionhosting.com\/support\/#\/schema\/person\/5fbfcaed32a2672fb83ab312f5b7237b","name":"InMotion Hosting Contributor","description":"InMotion Hosting contributors are highly knowledgeable individuals who create relevant content on new trends and troubleshooting techniques to help you achieve your online goals!","sameAs":["https:\/\/www.linkedin.com\/company\/inmotion-hosting\/","https:\/\/x.com\/https:\/\/twitter.com\/InMotionHosting"],"url":"https:\/\/www.inmotionhosting.com\/support\/author\/john-paul\/"}]}},"jetpack_featured_media_url":"","jetpack_sharing_enabled":true,"primary_category":{"id":4305,"name":"Working with Databases","slug":"databases","link":"https:\/\/www.inmotionhosting.com\/support\/server\/databases\/"},"_links":{"self":[{"href":"https:\/\/www.inmotionhosting.com\/support\/wp-json\/wp\/v2\/posts\/502","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.inmotionhosting.com\/support\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.inmotionhosting.com\/support\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.inmotionhosting.com\/support\/wp-json\/wp\/v2\/users\/3"}],"replies":[{"embeddable":true,"href":"https:\/\/www.inmotionhosting.com\/support\/wp-json\/wp\/v2\/comments?post=502"}],"version-history":[{"count":22,"href":"https:\/\/www.inmotionhosting.com\/support\/wp-json\/wp\/v2\/posts\/502\/revisions"}],"predecessor-version":[{"id":82690,"href":"https:\/\/www.inmotionhosting.com\/support\/wp-json\/wp\/v2\/posts\/502\/revisions\/82690"}],"wp:attachment":[{"href":"https:\/\/www.inmotionhosting.com\/support\/wp-json\/wp\/v2\/media?parent=502"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.inmotionhosting.com\/support\/wp-json\/wp\/v2\/categories?post=502"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.inmotionhosting.com\/support\/wp-json\/wp\/v2\/tags?post=502"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}