{"id":40088,"date":"2026-03-12T11:18:56","date_gmt":"2026-03-12T04:18:56","guid":{"rendered":"https:\/\/interdata.vn\/blog\/?p=40088"},"modified":"2026-03-19T15:09:37","modified_gmt":"2026-03-19T08:09:37","slug":"add-ip-remote-mysql-tren-hosting-cpanel","status":"publish","type":"post","link":"https:\/\/interdata.vn\/blog\/add-ip-remote-mysql-tren-hosting-cpanel\/","title":{"rendered":"H\u01b0\u1edbng d\u1eabn c\u00e1ch add IP Remote MySQL tr\u00ean Hosting cPanel nhanh"},"content":{"rendered":"<div id=\"ez-toc-container\" class=\"ez-toc-v2_0_85 counter-hierarchy ez-toc-counter ez-toc-white ez-toc-container-direction\">\n<div class=\"ez-toc-title-container\">\n<p class=\"ez-toc-title\" style=\"cursor:inherit\">N\u1ed8I DUNG<\/p>\n<span class=\"ez-toc-title-toggle\"><a href=\"#\" class=\"ez-toc-pull-right ez-toc-btn ez-toc-btn-xs ez-toc-btn-default ez-toc-toggle\" aria-label=\"Toggle Table of Content\"><span class=\"ez-toc-js-icon-con\"><span class=\"\"><span class=\"eztoc-hide\" style=\"display:none;\">Toggle<\/span><span class=\"ez-toc-icon-toggle-span\"><svg style=\"fill: #999;color:#999\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\" class=\"list-377408\" width=\"20px\" height=\"20px\" viewBox=\"0 0 24 24\" fill=\"none\"><path d=\"M6 6H4v2h2V6zm14 0H8v2h12V6zM4 11h2v2H4v-2zm16 0H8v2h12v-2zM4 16h2v2H4v-2zm16 0H8v2h12v-2z\" fill=\"currentColor\"><\/path><\/svg><svg style=\"fill: #999;color:#999\" class=\"arrow-unsorted-368013\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\" width=\"10px\" height=\"10px\" viewBox=\"0 0 24 24\" version=\"1.2\" baseProfile=\"tiny\"><path d=\"M18.2 9.3l-6.2-6.3-6.2 6.3c-.2.2-.3.4-.3.7s.1.5.3.7c.2.2.4.3.7.3h11c.3 0 .5-.1.7-.3.2-.2.3-.5.3-.7s-.1-.5-.3-.7zM5.8 14.7l6.2 6.3 6.2-6.3c.2-.2.3-.5.3-.7s-.1-.5-.3-.7c-.2-.2-.4-.3-.7-.3h-11c-.3 0-.5.1-.7.3-.2.2-.3.5-.3.7s.1.5.3.7z\"\/><\/svg><\/span><\/span><\/span><\/a><\/span><\/div>\n<nav><ul class='ez-toc-list ez-toc-list-level-1 eztoc-toggle-hide-by-default' ><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-1\" href=\"https:\/\/interdata.vn\/blog\/add-ip-remote-mysql-tren-hosting-cpanel\/#1-Remote-MySQL-la-gi-Tai-sao-can-su-dung\" >1. Remote MySQL l\u00e0 g\u00ec? T\u1ea1i sao c\u1ea7n s\u1eed d\u1ee5ng?<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-2\" href=\"https:\/\/interdata.vn\/blog\/add-ip-remote-mysql-tren-hosting-cpanel\/#2-Cac-buoc-cau-hinh-Remote-MySQL-trong-cPanel\" >2. C\u00e1c b\u01b0\u1edbc c\u1ea5u h\u00ecnh Remote MySQL trong cPanel<\/a><ul class='ez-toc-list-level-3' ><li class='ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-3\" href=\"https:\/\/interdata.vn\/blog\/add-ip-remote-mysql-tren-hosting-cpanel\/#Buoc-1-Xac-dinh-dia-chi-IP-cua-ban\" >B\u01b0\u1edbc 1: X\u00e1c \u0111\u1ecbnh \u0111\u1ecba ch\u1ec9 IP c\u1ee7a b\u1ea1n<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-4\" href=\"https:\/\/interdata.vn\/blog\/add-ip-remote-mysql-tren-hosting-cpanel\/#Buoc-2-Truy-cap-tinh-nang-Remote-Database-Access-trong-cPanel\" >B\u01b0\u1edbc 2: Truy c\u1eadp t\u00ednh n\u0103ng Remote Database Access trong cPanel<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-5\" href=\"https:\/\/interdata.vn\/blog\/add-ip-remote-mysql-tren-hosting-cpanel\/#Buoc-3-Them-dia-chi-IP-Add-Access-Host\" >B\u01b0\u1edbc 3: Th\u00eam \u0111\u1ecba ch\u1ec9 IP (Add Access Host)<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-6\" href=\"https:\/\/interdata.vn\/blog\/add-ip-remote-mysql-tren-hosting-cpanel\/#Buoc-4-Kiem-tra-ket-noi\" >B\u01b0\u1edbc 4: Ki\u1ec3m tra k\u1ebft n\u1ed1i<\/a><\/li><\/ul><\/li><\/ul><\/nav><\/div>\n<p>B\u1ea1n mu\u1ed1n k\u1ebft n\u1ed1i c\u01a1 s\u1edf d\u1eef li\u1ec7u t\u1eeb m\u1ed9t server kh\u00e1c ho\u1eb7c ph\u1ea7n m\u1ec1m qu\u1ea3n l\u00fd b\u00ean ngo\u00e0i v\u00e0o Hosting c\u1ee7a m\u00ecnh? T\u00ednh n\u0103ng Remote MySQL trong cPanel ch\u00ednh l\u00e0 gi\u1ea3i ph\u00e1p. B\u00e0i vi\u1ebft n\u00e0y s\u1ebd h\u01b0\u1edbng d\u1eabn b\u1ea1n c\u00e1ch<strong> add IP Remote MySQL chi ti\u1ebft<\/strong>, gi\u00fap vi\u1ec7c k\u1ebft n\u1ed1i di\u1ec5n ra su\u00f4n s\u1ebb m\u00e0 v\u1eabn \u0111\u1ea3m b\u1ea3o t\u00ednh b\u1ea3o m\u1eadt.<\/p>\n<h2><span class=\"ez-toc-section\" id=\"1-Remote-MySQL-la-gi-Tai-sao-can-su-dung\"><\/span>1. Remote MySQL l\u00e0 g\u00ec? T\u1ea1i sao c\u1ea7n s\u1eed d\u1ee5ng?<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>Th\u00f4ng th\u01b0\u1eddng, c\u01a1 s\u1edf d\u1eef li\u1ec7u (MySQL) tr\u00ean hosting ch\u1ec9 cho ph\u00e9p k\u1ebft n\u1ed1i t\u1eeb ch\u00ednh server \u0111\u00f3 (localhost). <strong>Remote MySQL<\/strong> l\u00e0 t\u00ednh n\u0103ng cho ph\u00e9p c\u00e1c \u0111\u1ecba ch\u1ec9 IP t\u1eeb b\u00ean ngo\u00e0i (nh\u01b0 m\u00e1y t\u00ednh c\u1ee7a b\u1ea1n, m\u1ed9t VPS kh\u00e1c, ho\u1eb7c \u1ee9ng d\u1ee5ng b\u00ean th\u1ee9 3) truy c\u1eadp v\u00e0o database tr\u00ean hosting c\u1ee7a b\u1ea1n.<\/p>\n<p><strong>Khi n\u00e0o b\u1ea1n c\u1ea7n s\u1eed d\u1ee5ng Remote MySQL?<\/strong><\/p>\n<ul>\n<li>Khi b\u1ea1n d\u00f9ng ph\u1ea7n m\u1ec1m nh\u01b0 MySQL Workbench, Navicat \u0111\u1ec3 qu\u1ea3n l\u00fd database t\u1eeb m\u00e1y t\u00ednh c\u00e1 nh\u00e2n.<\/li>\n<li>Khi b\u1ea1n ch\u1ea1y m\u1ed9t website tr\u00ean server kh\u00e1c nh\u01b0ng mu\u1ed1n d\u00f9ng chung database.<\/li>\n<li>Khi c\u1ea7n \u0111\u1ed3ng b\u1ed9 d\u1eef li\u1ec7u gi\u1eefa c\u00e1c h\u1ec7 th\u1ed1ng kh\u00e1c nhau.<\/li>\n<\/ul>\n<h2><span class=\"ez-toc-section\" id=\"2-Cac-buoc-cau-hinh-Remote-MySQL-trong-cPanel\"><\/span>2. C\u00e1c b\u01b0\u1edbc c\u1ea5u h\u00ecnh Remote MySQL trong cPanel<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>\u0110\u1ec3 cho ph\u00e9p k\u1ebft n\u1ed1i t\u1eeb m\u1ed9t IP c\u1ee5 th\u1ec3, b\u1ea1n th\u1ef1c hi\u1ec7n theo c\u00e1c b\u01b0\u1edbc sau:<\/p>\n<h3><span class=\"ez-toc-section\" id=\"Buoc-1-Xac-dinh-dia-chi-IP-cua-ban\"><\/span>B\u01b0\u1edbc 1: X\u00e1c \u0111\u1ecbnh \u0111\u1ecba ch\u1ec9 IP c\u1ee7a b\u1ea1n<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>Tr\u01b0\u1edbc khi add, b\u1ea1n c\u1ea7n bi\u1ebft IP c\u00f4ng c\u1ed9ng (Public IP) c\u1ee7a m\u00ecnh. H\u00e3y truy c\u1eadp trang <a href=\"https:\/\/www.whatismyip.com\/\" rel=\"nofollow noopener\" target=\"_blank\">WhatIsMyIP.com<\/a> \u0111\u1ec3 l\u1ea5y \u0111\u1ecba ch\u1ec9 IP hi\u1ec7n t\u1ea1i.<\/p>\n<h3><span class=\"ez-toc-section\" id=\"Buoc-2-Truy-cap-tinh-nang-Remote-Database-Access-trong-cPanel\"><\/span>B\u01b0\u1edbc 2: Truy c\u1eadp t\u00ednh n\u0103ng Remote Database Access trong cPanel<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<ul>\n<li>\u0110\u0103ng nh\u1eadp v\u00e0o <strong>cPanel<\/strong>.<\/li>\n<li>T\u1ea1i m\u1ee5c <strong>Databases<\/strong>, t\u00ecm v\u00e0 ch\u1ecdn bi\u1ec3u t\u01b0\u1ee3ng <strong>Remote Database Access<\/strong>.<\/li>\n<\/ul>\n<h3><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-40089\" src=\"https:\/\/interdata.vn\/blog\/wp-content\/uploads\/2026\/03\/Chon-tinh-nang-Remote-Database-Access-trong-cPanel.png\" alt=\"t\u00ednh n\u0103ng Remote Database Access trong cPanel\" width=\"769\" height=\"199\" title=\"\" srcset=\"https:\/\/interdata.vn\/blog\/wp-content\/uploads\/2026\/03\/Chon-tinh-nang-Remote-Database-Access-trong-cPanel.png 769w, https:\/\/interdata.vn\/blog\/wp-content\/uploads\/2026\/03\/Chon-tinh-nang-Remote-Database-Access-trong-cPanel-300x78.png 300w\" sizes=\"auto, (max-width: 769px) 100vw, 769px\" \/><\/h3>\n<h3><span class=\"ez-toc-section\" id=\"Buoc-3-Them-dia-chi-IP-Add-Access-Host\"><\/span>B\u01b0\u1edbc 3: Th\u00eam \u0111\u1ecba ch\u1ec9 IP (Add Access Host)<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<ul>\n<li>Trong \u00f4 <strong>Host (% wildcard is allowed)<\/strong>, b\u1ea1n nh\u1eadp \u0111\u1ecba ch\u1ec9 IP v\u1eeba t\u00ecm \u0111\u01b0\u1ee3c \u1edf B\u01b0\u1edbc 1.\n<ul>\n<li>V\u00ed d\u1ee5: 123.45.67.89<\/li>\n<\/ul>\n<\/li>\n<li>Trong \u00f4 <strong>Comment<\/strong>, b\u1ea1n c\u00f3 th\u1ec3 \u0111\u1eb7t t\u00ean ghi ch\u00fa (VD: &#8220;M\u00e1y t\u00ednh v\u0103n ph\u00f2ng&#8221;, &#8220;VPS Backup&#8221;) \u0111\u1ec3 d\u1ec5 qu\u1ea3n l\u00fd sau n\u00e0y.<\/li>\n<li>Nh\u1ea5n n\u00fat <strong>Add Host<\/strong>.<\/li>\n<\/ul>\n<h3><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-40091\" src=\"https:\/\/interdata.vn\/blog\/wp-content\/uploads\/2026\/03\/Them-dia-chi-IP-1.png\" alt=\"Th\u00eam \u0111\u1ecba ch\u1ec9 IP\" width=\"729\" height=\"421\" title=\"\" srcset=\"https:\/\/interdata.vn\/blog\/wp-content\/uploads\/2026\/03\/Them-dia-chi-IP-1.png 729w, https:\/\/interdata.vn\/blog\/wp-content\/uploads\/2026\/03\/Them-dia-chi-IP-1-300x173.png 300w\" sizes=\"auto, (max-width: 729px) 100vw, 729px\" \/><\/h3>\n<h3><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-40092\" src=\"https:\/\/interdata.vn\/blog\/wp-content\/uploads\/2026\/03\/dia-chi-IP-da-duoc-them-thanh-cong.png\" alt=\"\u0111\u1ecba ch\u1ec9 IP \u0111\u00e3 \u0111\u01b0\u1ee3c th\u00eam th\u00e0nh c\u00f4ng\" width=\"764\" height=\"193\" title=\"\" srcset=\"https:\/\/interdata.vn\/blog\/wp-content\/uploads\/2026\/03\/dia-chi-IP-da-duoc-them-thanh-cong.png 764w, https:\/\/interdata.vn\/blog\/wp-content\/uploads\/2026\/03\/dia-chi-IP-da-duoc-them-thanh-cong-300x76.png 300w\" sizes=\"auto, (max-width: 764px) 100vw, 764px\" \/><\/h3>\n<p><strong>L\u01b0u \u00fd khi cho ph\u00e9p IP truy c\u1eadp Remote MySQL<\/strong>:<\/p>\n<p>N\u1ebfu mu\u1ed1n cho ph\u00e9p m\u1ecdi \u0111\u1ecba ch\u1ec9 IP \u0111\u1ec1u c\u00f3 th\u1ec3 truy c\u1eadp v\u00e0o database, b\u1ea1n c\u00f3 th\u1ec3 nh\u1eadp k\u00fd t\u1ef1 % v\u00e0o \u00f4 Host. Tuy nhi\u00ean, c\u00e1ch n\u00e0y kh\u00f4ng \u0111\u01b0\u1ee3c khuy\u1ebfn kh\u00edch v\u00ec c\u00f3 th\u1ec3 ti\u1ec1m \u1ea9n r\u1ee7i ro v\u1ec1 b\u1ea3o m\u1eadt. \u0110\u1ec3 \u0111\u1ea3m b\u1ea3o d\u1eef li\u1ec7u an to\u00e0n h\u01a1n, b\u1ea1n n\u00ean ch\u1ec9 cho ph\u00e9p nh\u1eefng \u0111\u1ecba ch\u1ec9 IP c\u1ee5 th\u1ec3 \u0111\u01b0\u1ee3c quy\u1ec1n truy c\u1eadp.<\/p>\n<h3><span class=\"ez-toc-section\" id=\"Buoc-4-Kiem-tra-ket-noi\"><\/span>B\u01b0\u1edbc 4: Ki\u1ec3m tra k\u1ebft n\u1ed1i<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>Sau khi nh\u1ea5n <strong>Add Host<\/strong>, cPanel s\u1ebd hi\u1ec3n th\u1ecb th\u00f4ng b\u00e1o x\u00e1c nh\u1eadn r\u1eb1ng <strong>\u0111\u1ecba ch\u1ec9 IP \u0111\u00e3 \u0111\u01b0\u1ee3c th\u00eam th\u00e0nh c\u00f4ng<\/strong>. Trong danh s\u00e1ch <strong>Access Hosts<\/strong>, b\u1ea1n s\u1ebd th\u1ea5y <strong>\u0111\u1ecba ch\u1ec9 IP v\u1eeba th\u00eam xu\u1ea5t hi\u1ec7n trong danh s\u00e1ch<\/strong>. N\u1ebfu c\u1ea7n <strong>x\u00f3a ho\u1eb7c ch\u1ec9nh s\u1eeda \u0111\u1ecba ch\u1ec9 IP<\/strong>, b\u1ea1n c\u00f3 th\u1ec3 th\u1ef1c hi\u1ec7n tr\u1ef1c ti\u1ebfp t\u1ea1i \u0111\u00e2y.<\/p>\n<p>L\u00fac n\u00e0y, b\u1ea1n \u0111\u00e3 c\u00f3 th\u1ec3 <strong>k\u1ebft n\u1ed1i \u0111\u1ebfn MySQL t\u1eeb xa th\u00f4ng qua \u0111\u1ecba ch\u1ec9 IP \u0111\u00e3 \u0111\u01b0\u1ee3c th\u00eam<\/strong>.<\/p>\n<p>M\u1eb7c d\u00f9 k\u1ebft n\u1ed1i t\u1eeb xa r\u1ea5t ti\u1ec7n l\u1ee3i, nh\u01b0ng b\u1ea1n c\u0169ng c\u1ea7n ch\u00fa \u00fd \u0111\u1ebfn c\u1ea5u h\u00ecnh t\u1ed5ng th\u1ec3 c\u1ee7a hosting. H\u00e3y xem qua <strong><a href=\"https:\/\/interdata.vn\/blog\/quan-ly-database-tren-cpanel\/\">h\u01b0\u1edbng d\u1eabn qu\u1ea3n l\u00fd database cpanel<\/a><\/strong> \u0111\u1ec3 \u0111\u1ea3m b\u1ea3o t\u00ednh \u0111\u1ed3ng nh\u1ea5t v\u00e0 an m\u1eadt cho d\u1eef li\u1ec7u.<\/p>\n<p>Vi\u1ec7c <strong>add IP Remote MySQL tr\u00ean cPanel<\/strong> th\u1ef1c ch\u1ea5t r\u1ea5t \u0111\u01a1n gi\u1ea3n v\u00e0 ch\u1ec9 m\u1ea5t ch\u01b0a \u0111\u1ea7y 2 ph\u00fat. Tuy nhi\u00ean, y\u1ebfu t\u1ed1 b\u1ea3o m\u1eadt l\u00e0 \u01b0u ti\u00ean h\u00e0ng \u0111\u1ea7u. Hy v\u1ecdng b\u00e0i h\u01b0\u1edbng d\u1eabn n\u00e0y gi\u00fap b\u1ea1n th\u1ef1c hi\u1ec7n th\u00e0nh c\u00f4ng. N\u1ebfu b\u1ea1n c\u1ea7n th\u00eam h\u1ed7 tr\u1ee3 v\u1ec1 qu\u1ea3n tr\u1ecb hosting, h\u00e3y tham kh\u1ea3o c\u00e1c b\u00e0i vi\u1ebft kh\u00e1c trong chuy\u00ean m\u1ee5c c\u1ee7a InterData!<\/p>\n","protected":false},"excerpt":{"rendered":"<p>B\u1ea1n mu\u1ed1n k\u1ebft n\u1ed1i c\u01a1 s\u1edf d\u1eef li\u1ec7u t\u1eeb m\u1ed9t server kh\u00e1c ho\u1eb7c ph\u1ea7n m\u1ec1m qu\u1ea3n l\u00fd b\u00ean ngo\u00e0i v\u00e0o Hosting c\u1ee7a m\u00ecnh? T\u00ednh n\u0103ng Remote MySQL trong cPanel ch\u00ednh l\u00e0 gi\u1ea3i ph\u00e1p. B\u00e0i vi\u1ebft n\u00e0y s\u1ebd h\u01b0\u1edbng d\u1eabn b\u1ea1n c\u00e1ch add IP Remote MySQL chi ti\u1ebft, gi\u00fap vi\u1ec7c k\u1ebft n\u1ed1i di\u1ec5n ra su\u00f4n s\u1ebb<\/p>\n","protected":false},"author":11,"featured_media":40115,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[84,1],"tags":[],"class_list":["post-40088","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-cong-cu-phan-mem","category-hosting"],"_links":{"self":[{"href":"https:\/\/interdata.vn\/blog\/wp-json\/wp\/v2\/posts\/40088","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/interdata.vn\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/interdata.vn\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/interdata.vn\/blog\/wp-json\/wp\/v2\/users\/11"}],"replies":[{"embeddable":true,"href":"https:\/\/interdata.vn\/blog\/wp-json\/wp\/v2\/comments?post=40088"}],"version-history":[{"count":5,"href":"https:\/\/interdata.vn\/blog\/wp-json\/wp\/v2\/posts\/40088\/revisions"}],"predecessor-version":[{"id":40478,"href":"https:\/\/interdata.vn\/blog\/wp-json\/wp\/v2\/posts\/40088\/revisions\/40478"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/interdata.vn\/blog\/wp-json\/wp\/v2\/media\/40115"}],"wp:attachment":[{"href":"https:\/\/interdata.vn\/blog\/wp-json\/wp\/v2\/media?parent=40088"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/interdata.vn\/blog\/wp-json\/wp\/v2\/categories?post=40088"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/interdata.vn\/blog\/wp-json\/wp\/v2\/tags?post=40088"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}