{"id":445,"date":"2022-06-27T11:08:23","date_gmt":"2022-06-27T11:08:23","guid":{"rendered":"https:\/\/blog.hostinger.io\/id\/support\/2022\/06\/27\/4274567-bagaimana-cara-mengatasi-error-max_connections_per_hour-di-mysql-di-hostinger\/"},"modified":"2025-08-26T20:01:23","modified_gmt":"2025-08-26T20:01:23","slug":"4274567-bagaimana-cara-mengatasi-error-max_connections_per_hour-di-mysql-di-hostinger","status":"publish","type":"post","link":"https:\/\/www.hostinger.com\/id\/support\/4274567-bagaimana-cara-mengatasi-error-max_connections_per_hour-di-mysql-di-hostinger\/","title":{"rendered":"Bagaimana Cara Mengatasi Error Max_Connections_Per_Hour di MySQL di Hostinger"},"content":{"rendered":"

Lakukan opsi berikut jika website yang Anda hosting di Hostinger menampilkan error ini max_connections_per_hour<\/b> limit: <\/p>

\n<\/p>

Connection failed: User 'u1000000_database' has exceeded the 'max_connections_per_hour' resource (current value: 500)<\/code><\/pre>
\n<\/p>
Opsi 1 – Gunakan Localhost<\/h1>
Pastikan nama host database disetel ke localhost di file konfigurasi<\/a><\/b> website Anda, seperti wp-config.php<\/b>.<\/p>
\n
Tidak disarankan<\/b> untuk mengatur nama host database Anda ke IP hosting Anda.<\/p>\n<\/div>
Misalnya, jika detail konfigurasi database Anda saat ini diatur seperti ini:<\/p>
\/** Nama database untuk WordPress *\/
define( 'DB_NAME', 'u1000000_database' );
\/** nama host MySQL *\/
define( 'DB_HOST', '185.185.185.185' );<\/code><\/pre>
\n<\/p>
Pastikan untuk mengganti nilai baris terakhir DB_HOST<\/b> ke localhost<\/b> sebagai berikut:<\/p>
\/** Nama database untuk WordPress *\/ 
define( 'DB_NAME', 'u1000000_database' ); 
\/** nama host MySQL *\/ 
define( 'DB_HOST', 'localhost' );<\/code><\/pre>
\n<\/p>
Opsi 2 – Hentikan proses<\/h1>
Beberapa kode yang tidak dioptimalkan di situs web Anda dapat menyebabkan Anda mencapai batas max_user_connections<\/b>. Untuk mengatasinya, Anda dapat mengakhiri koneksi tersebut secara manual dengan mengikuti langkah-langkah berikut:<\/p>
    \n
  1. \n
    Buka database melalui phpMyAdmin<\/a><\/b><\/p>\n<\/li>\n
  2. \n
    Klik SQL<\/b> pada menu atas, ketik SHOW PROCESSLIST<\/b> dan klik GO:<\/b>
    ​<\/p>\n
    <\/div>\n
    \n<\/p><\/li>\n
  3. \n
    Setelah selesai, Anda dapat melihat daftar proses saat ini. Untuk menghentikan proses yang berjalan, klik Stop the process:<\/b>
    ​<\/p>\n
    <\/div>\n
    \n<\/p><\/li>\n<\/ol>
    Harap perhatikan bahwa menghentikan proses hanya akan membantu untuk sementara. Untuk solusi yang lebih permanen, Anda perlu mengoptimalkan kueri basis data atau upgrade paket Anda<\/a><\/b> 🚀<\/p>\n","protected":false},"excerpt":{"rendered":"
    Memperbaiki error max_connections_per_hour<\/p>\n","protected":false},"author":581,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"include_on_kodee":true,"footnotes":""},"categories":[216],"tags":[],"class_list":["post-445","post","type-post","status-publish","format-standard","hentry","category-memperbaiki-error"],"hreflangs":[{"locale":"en-US","link":"https:\/\/www.hostinger.com\/support\/4274567-how-to-fix-the-max_connections_per_hour-mysql-error-at-hostinger\/","default":1},{"locale":"es-ES","link":"https:\/\/www.hostinger.com\/es\/support\/4274567-como-corregir-el-error-de-mysql-max_connections_per_hour-en-hostinger\/","default":0},{"locale":"fr-FR","link":"https:\/\/www.hostinger.com\/fr\/support\/4274567-comment-reparer-l-erreur-mysql-max_connections_per_hour-at-hostinger\/","default":0},{"locale":"id-ID","link":"https:\/\/www.hostinger.com\/id\/support\/4274567-bagaimana-cara-mengatasi-error-max_connections_per_hour-di-mysql-di-hostinger\/","default":0},{"locale":"uk-UA","link":"https:\/\/www.hostinger.com\/ua\/support\/4274567----mysql-max_connections_per_hour--hostinger\/","default":0}],"include_on_kodee":true,"_links":{"self":[{"href":"https:\/\/www.hostinger.com\/id\/support\/wp-json\/wp\/v2\/posts\/445","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.hostinger.com\/id\/support\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.hostinger.com\/id\/support\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.hostinger.com\/id\/support\/wp-json\/wp\/v2\/users\/581"}],"replies":[{"embeddable":true,"href":"https:\/\/www.hostinger.com\/id\/support\/wp-json\/wp\/v2\/comments?post=445"}],"version-history":[{"count":1,"href":"https:\/\/www.hostinger.com\/id\/support\/wp-json\/wp\/v2\/posts\/445\/revisions"}],"predecessor-version":[{"id":1565,"href":"https:\/\/www.hostinger.com\/id\/support\/wp-json\/wp\/v2\/posts\/445\/revisions\/1565"}],"wp:attachment":[{"href":"https:\/\/www.hostinger.com\/id\/support\/wp-json\/wp\/v2\/media?parent=445"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.hostinger.com\/id\/support\/wp-json\/wp\/v2\/categories?post=445"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.hostinger.com\/id\/support\/wp-json\/wp\/v2\/tags?post=445"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}