{"id":1094,"date":"2019-06-10T13:28:23","date_gmt":"2019-06-10T06:28:23","guid":{"rendered":"https:\/\/tino.vn\/?post_type=ht_kb&#038;p=1094"},"modified":"2020-03-11T15:04:19","modified_gmt":"2020-03-11T08:04:19","slug":"huong-dan-su-dung-chuc-nang-remote-mysql-tren-hosting-cpanel","status":"publish","type":"ht_kb","link":"https:\/\/tino.vn\/blog\/docs\/huong-dan-su-dung-chuc-nang-remote-mysql-tren-hosting-cpanel\/","title":{"rendered":"[cPanel] &#8211; H\u01b0\u1edbng d\u1eabn s\u1eed d\u1ee5ng ch\u1ee9c n\u0103ng Remote MySQL\u00ae tr\u00ean Hosting cPanel"},"content":{"rendered":"<p><iframe loading=\"lazy\" src=\"\/\/www.youtube.com\/embed\/dNUeUyvaqSE\" width=\"560\" height=\"315\" frameborder=\"0\" allowfullscreen=\"allowfullscreen\"><\/iframe><\/p>\n<p>Ch\u00e0o b\u1ea1n, trong b\u00e0i n\u00e0y TinoHost s\u1ebd h\u01b0\u1edbng d\u1eabn c\u00e1c b\u1ea1n s\u1eed d\u1ee5ng ch\u1ee9c n\u0103ng Remote MySQL\u00ae tr\u00ean Hosting cPanel \u0111\u1ec3 thi\u1ebft l\u1eadp k\u1ebft n\u1ed1i MySQL t\u1eeb xa (Remote MySQL).<\/p>\n<h4 id=\"Thi\u1ebft_l\u1eadp_Remote_MySQL_v\u00e0_k\u1ebft_n\u1ed1i_b\u1eb1ng_th\u01b0_vi\u1ec7n_PHP\">Thi\u1ebft l\u1eadp Remote MySQL v\u00e0 k\u1ebft n\u1ed1i b\u1eb1ng th\u01b0 vi\u1ec7n PHP<\/h4>\n<h5 id=\"B\u01b0\u1edbc_1:_Thi\u1ebft_t\u1eadp_Remote_MySQL\u00ae_(MySQL_t\u1eeb_xa)_tr\u00ean_Hosting\">B\u01b0\u1edbc 1: Thi\u1ebft t\u1eadp Remote MySQL\u00ae (MySQL t\u1eeb xa) tr\u00ean Hosting<\/h5>\n<p>&#8211; \u0110\u0103ng v\u00e0o Hosting cPanel , ch\u1ecdn m\u1ee5c <strong>Remote MySQL\u00ae<\/strong>\u00a0<a href=\"https:\/\/tino.vn\/blog\/huong-dan\/huong-dan-su-dung-chuc-nang-remote-mysql-tren-hosting-cpanel\/2019-06-10_8-58-58\/\" rel=\"attachment wp-att-1095\"><img decoding=\"async\" class=\"alignnone size-full wp-image-1095\" src=\"https:\/\/tino.vn\/blog\/wp-content\/uploads\/2019\/06\/2019-06-10_8-58-58.png\" alt=\"\" width=\"1280\" height=\"819\" title=\"\" srcset=\"https:\/\/tino.vn\/blog\/wp-content\/uploads\/2019\/06\/2019-06-10_8-58-58.png 1280w, https:\/\/tino.vn\/blog\/wp-content\/uploads\/2019\/06\/2019-06-10_8-58-58-300x192.png 300w, https:\/\/tino.vn\/blog\/wp-content\/uploads\/2019\/06\/2019-06-10_8-58-58-768x491.png 768w, https:\/\/tino.vn\/blog\/wp-content\/uploads\/2019\/06\/2019-06-10_8-58-58-1024x655.png 1024w\" sizes=\"(max-width: 1280px) 100vw, 1280px\" \/><\/a><\/p>\n<p>&#8211; Th\u00eam Add Access Host: Th\u00eam v\u00e0o \u0111\u1ecba ch\u1ec9 IP c\u1ee7a Host \u0111\u01b0\u1ee3c ph\u00e9p k\u1ebft n\u1ed1i t\u1edbi. M\u1ee5c n\u00e0y c\u00f3 th\u1ec3 l\u00e0 Hostname (d\u1ea1ng: <strong>vps.domain.com<\/strong>) ho\u1eb7c IP (d\u1ea1ng: <strong>103.130.218.6<\/strong>)<\/p>\n<p>V\u00ed d\u1ee5: M\u00ecnh \u0111i\u1ec1n v\u00e0o IP <strong>103.130.218.6<\/strong> \u0111\u00e2y l\u00e0 VPS m\u00e0 m\u00ecnh s\u1ebd k\u1ebft n\u1ed1i t\u1edbi m\u00e1y ch\u1ee7 Hosting<\/p>\n<p><a href=\"https:\/\/tino.vn\/blog\/huong-dan\/huong-dan-su-dung-chuc-nang-remote-mysql-tren-hosting-cpanel\/2019-06-10_10-04-57\/\" rel=\"attachment wp-att-1097\"><img decoding=\"async\" class=\"alignnone size-full wp-image-1097\" src=\"https:\/\/tino.vn\/blog\/wp-content\/uploads\/2019\/06\/2019-06-10_10-04-57.png\" alt=\"\" width=\"1280\" height=\"785\" title=\"\" srcset=\"https:\/\/tino.vn\/blog\/wp-content\/uploads\/2019\/06\/2019-06-10_10-04-57.png 1280w, https:\/\/tino.vn\/blog\/wp-content\/uploads\/2019\/06\/2019-06-10_10-04-57-300x184.png 300w, https:\/\/tino.vn\/blog\/wp-content\/uploads\/2019\/06\/2019-06-10_10-04-57-1024x628.png 1024w, https:\/\/tino.vn\/blog\/wp-content\/uploads\/2019\/06\/2019-06-10_10-04-57-768x471.png 768w\" sizes=\"(max-width: 1280px) 100vw, 1280px\" \/><\/a><\/p>\n<p>&#8211; B\u1ea5m ch\u1ecdn Add Host , th\u00e0nh c\u00f4ng s\u1ebd xu\u1ea5t hi\u1ec7n th\u00f4ng b\u00e1o nh\u01b0 h\u00ecnh \u1edf d\u01b0\u1edbi.<\/p>\n<p><a href=\"https:\/\/tino.vn\/blog\/huong-dan\/huong-dan-su-dung-chuc-nang-remote-mysql-tren-hosting-cpanel\/2019-06-10_10-05-02\/\" rel=\"attachment wp-att-1096\"><img decoding=\"async\" class=\"alignnone size-full wp-image-1096\" src=\"https:\/\/tino.vn\/blog\/wp-content\/uploads\/2019\/06\/2019-06-10_10-05-02.png\" alt=\"\" width=\"1280\" height=\"304\" title=\"\" srcset=\"https:\/\/tino.vn\/blog\/wp-content\/uploads\/2019\/06\/2019-06-10_10-05-02.png 1280w, https:\/\/tino.vn\/blog\/wp-content\/uploads\/2019\/06\/2019-06-10_10-05-02-300x71.png 300w, https:\/\/tino.vn\/blog\/wp-content\/uploads\/2019\/06\/2019-06-10_10-05-02-1024x243.png 1024w, https:\/\/tino.vn\/blog\/wp-content\/uploads\/2019\/06\/2019-06-10_10-05-02-768x182.png 768w\" sizes=\"(max-width: 1280px) 100vw, 1280px\" \/><\/a><\/p>\n<h5 id=\"B\u01b0\u1edbc_2:_K\u1ebft_n\u1ed1i_MySQL_t\u1eeb_xa_qua_th\u01b0_vi\u1ec7n_PHP\">B\u01b0\u1edbc 2: K\u1ebft n\u1ed1i MySQL t\u1eeb xa qua th\u01b0 vi\u1ec7n PHP<\/h5>\n<p>&#8211; Tr\u00ean VPS IP <strong>103.130.218.6<\/strong> m\u00ecnh c\u00f3 1 website l\u00e0 <a href=\"https:\/\/tiennguyen.cf\/\" rel=\"nofollow noopener\" target=\"_blank\">https:\/\/tiennguyen.cf\/<\/a> , m\u00ecnh t\u1ea1o 1 file t\u00ean l\u00e0 <strong>remote-mysql.php<\/strong> n\u1eb1m t\u1ea1i th\u01b0 m\u1ee5c g\u1ed1c c\u1ee7a website v\u1edbi n\u1ed9i dung nh\u01b0 sau.<\/p>\n<pre>&lt;?php\r\n$host= gethostname(); \/\/L\u1ea5y T\u00ean hostname t\u1ea1i server ch\u1ee9a website.\r\n$ip = gethostbyname($host); \/\/L\u1ea5y IP c\u1ee7a Server\r\n\r\n$servername = \"103.130.216.100\"; \/\/Thay \"localhost\" b\u1eb1ng IP m\u00e1y ch\u1ee7 Hosting\r\n$username = \"tiennguyen_test\"; \/\/Thay \"username\" b\u1eb1ng t\u00ean database\r\n$password = \"tiennguyen@123\"; \/\/Thay \"password\" b\u1eb1ng m\u1eadt kh\u1ea9u database\r\n\r\n\/\/ Create connection\r\n$conn = mysqli_connect($servername, $username, $password);\r\n\r\n\/\/ Check connection\r\nif (!$conn) \r\n{die(\"K\u1ebft n\u1ed1i th\u1ea5t b\u1ea1i: \" . mysqli_connect_error());\r\n}\r\necho \"K\u1ebft n\u1ed1i t\u1eeb xa th\u00e0nh c\u00f4ng t\u1edbi m\u00e1y ch\u1ee7 MySQL t\u1eeb xa&lt;br&gt;\";\r\necho \"IP VPS: $ip&lt;br&gt;\";\r\necho \"IP m\u00e1y ch\u1ee7 Hosting: $servername\";\r\n?&gt;<\/pre>\n<p>&#8211; Th\u00f4ng tin k\u1ebft n\u1ed1i Database tr\u00ean Hosting b\u1ea1n \u0111\u00e3 c\u00f3 tr\u01b0\u1edbc \u0111\u00f3, b\u1ea1n c\u00f3 th\u1ec3 tham kh\u1ea3o b\u00e0i vi\u1ebft sau \u0111\u1ec3 t\u1ea1o m\u1edbi n\u1ebfu ch\u01b0a c\u00f3: <a href=\"https:\/\/tino.vn\/blog\/docs\/huong-dan-tao-database-tren-cpanel\/\">https:\/\/tino.vn\/blog\/docs\/huong-dan-tao-database-tren-cpanel\/<\/a><\/p>\n<p>&#8211; N\u1ed9i dung file \u1edf tr\u00ean ch\u1ec9 l\u00e0 k\u1ebft n\u1ed1i t\u1edbi t\u00e0i kho\u1ea3n mysql tr\u00ean Hosting th\u00f4i ch\u1ee9 kh\u00f4ng query b\u1ea5t k\u1ef3 c\u00e2u l\u1ec7nh n\u00e0o t\u1edbi database \u0111\u01b0\u1ee3c g\u1eafn quy\u1ec1n v\u1edbi t\u00e0i kho\u1ea3n mysql \u0111\u00f3<\/p>\n<p>&#8211; Truy c\u1eadp v\u00e0o \u0111\u01b0\u1eddng d\u1eabn <a href=\"https:\/\/tiennguyen.cf\/remote-mysql.php\" rel=\"nofollow noopener\" target=\"_blank\">https:\/\/tiennguyen.cf\/remote-mysql.php<\/a> \u0111\u1ec3 ki\u1ec3m tra. N\u1ebfu truy c\u1eadp k\u1ebft n\u1ed1i \u0111\u01b0\u1ee3c m\u00e1y ch\u1ee7 MySQL t\u1eeb xa th\u00ec s\u1ebd hi\u1ec3n th\u1ecb nh\u01b0 h\u00ecnh d\u01b0\u1edbi \u0111\u00e2y.<\/p>\n<p><a href=\"https:\/\/tino.vn\/blog\/huong-dan\/huong-dan-su-dung-chuc-nang-remote-mysql-tren-hosting-cpanel\/2019-06-10_12-07-23\/\" rel=\"attachment wp-att-1098\"><img decoding=\"async\" class=\"alignnone size-full wp-image-1098\" src=\"https:\/\/tino.vn\/blog\/wp-content\/uploads\/2019\/06\/2019-06-10_12-07-23.png\" alt=\"\" width=\"1280\" height=\"494\" title=\"\" srcset=\"https:\/\/tino.vn\/blog\/wp-content\/uploads\/2019\/06\/2019-06-10_12-07-23.png 1280w, https:\/\/tino.vn\/blog\/wp-content\/uploads\/2019\/06\/2019-06-10_12-07-23-300x116.png 300w, https:\/\/tino.vn\/blog\/wp-content\/uploads\/2019\/06\/2019-06-10_12-07-23-1024x395.png 1024w, https:\/\/tino.vn\/blog\/wp-content\/uploads\/2019\/06\/2019-06-10_12-07-23-768x296.png 768w\" sizes=\"(max-width: 1280px) 100vw, 1280px\" \/><\/a><\/p>\n<h4 id=\"Thi\u1ebft_l\u1eadp_Remote_MySQL_v\u00e0_k\u1ebft_n\u1ed1i_th\u00f4ng_qua_ph\u1ea7n_m\u1ec1m_MySQL_Workbench\">Thi\u1ebft l\u1eadp Remote MySQL v\u00e0 k\u1ebft n\u1ed1i th\u00f4ng qua ph\u1ea7n m\u1ec1m MySQL Workbench<\/h4>\n<p>Ph\u1ea7n n\u00e0y s\u1ebd h\u01b0\u1edbng d\u1eabn b\u1ea1n k\u1ebft n\u1ed1i qua ph\u1ea7n m\u1ec1m k\u1ebft n\u1ed1i MySQL Server. \u1ede \u0111\u00e2y m\u00ecnh s\u1eed d\u1ee5ng ph\u1ea7n m\u1ec1m kh\u00e1 n\u1ed5i ti\u1ebfng l\u00e0 <strong>MySQL Workbench<\/strong> c\u1ee7a Oracle thi\u1ebft k\u1ebf<\/p>\n<h5 id=\"B\u01b0\u1edbc_1:_T\u1ea3i_ph\u1ea7n_m\u1ec1m_MySQL_Workbench\">B\u01b0\u1edbc 1: T\u1ea3i ph\u1ea7n m\u1ec1m <strong>MySQL Workbench<\/strong><\/h5>\n<p>&#8211; B\u1ea1n truy c\u1eadp v\u00e0o trang sau: <a href=\"https:\/\/dev.mysql.com\/downloads\/workbench\/\" rel=\"nofollow noopener\" target=\"_blank\">https:\/\/dev.mysql.com\/downloads\/workbench\/<\/a>, m\u00ecnh t\u1ea3i b\u1ea3n d\u00e0nh cho H\u0110H Windows v\u00ec \u0111ang d\u00f9ng Windows 10.<\/p>\n<p><a href=\"https:\/\/tino.vn\/blog\/huong-dan\/huong-dan-su-dung-chuc-nang-remote-mysql-tren-hosting-cpanel\/2019-06-10_12-12-04\/\" rel=\"attachment wp-att-1099\"><img decoding=\"async\" class=\"alignnone size-full wp-image-1099\" src=\"https:\/\/tino.vn\/blog\/wp-content\/uploads\/2019\/06\/2019-06-10_12-12-04.png\" alt=\"\" width=\"1280\" height=\"819\" title=\"\" srcset=\"https:\/\/tino.vn\/blog\/wp-content\/uploads\/2019\/06\/2019-06-10_12-12-04.png 1280w, https:\/\/tino.vn\/blog\/wp-content\/uploads\/2019\/06\/2019-06-10_12-12-04-300x192.png 300w, https:\/\/tino.vn\/blog\/wp-content\/uploads\/2019\/06\/2019-06-10_12-12-04-1024x655.png 1024w, https:\/\/tino.vn\/blog\/wp-content\/uploads\/2019\/06\/2019-06-10_12-12-04-768x491.png 768w\" sizes=\"(max-width: 1280px) 100vw, 1280px\" \/><\/a><\/p>\n<p>&#8211; B\u1ea1n th\u1ef1c hi\u1ec7n c\u00e0i \u0111\u1eb7t ph\u1ea7n m\u1ec1m b\u00ecnh th\u01b0\u1eddng nh\u01b0 c\u00e1c ph\u1ea7n m\u1ec1m kh\u00e1c.<\/p>\n<h5 id=\"B\u01b0\u1edbc_2:_Thi\u1ebft_t\u1eadp_Remote_MySQL\u00ae_(MySQL_t\u1eeb_xa)_tr\u00ean_Hosting\">B\u01b0\u1edbc 2: Thi\u1ebft t\u1eadp Remote MySQL\u00ae (MySQL t\u1eeb xa) tr\u00ean Hosting<\/h5>\n<p>&#8211; T\u01b0\u01a1ng t\u1ef1 nh\u01b0 vi\u1ec7c k\u1ebft n\u1ed1i qua th\u01b0 vi\u1ec7n MySQL qua th\u01b0 vi\u1ec7n PHP, b\u1ea1n v\u1eabn ph\u1ea3i c\u1ea7n thao t\u00e1c t\u01b0\u01a1ng t\u1ef1, nh\u01b0ng l\u1ea7n n\u00e0y s\u1ebd kh\u00e1c 1 ch\u00fat.<\/p>\n<p>&#8211; M\u1ee5c <strong>Add Access Host<\/strong> m\u00ecnh \u0111i\u1ec1n v\u00e0o IP c\u1ee7a m\u00e1y \u0111\u01b0\u1ee3c ph\u00e9p m\u1edf k\u1ebft n\u1ed1i t\u1edbi. M\u00ecnh s\u1eed d\u1ee5ng m\u00e1y t\u00ednh c\u00e1 nh\u00e2n \u0111\u1ec3 k\u1ebft n\u1ed1i, \u0111\u1ec3 l\u1ea5y IP v4 public c\u1ee7a m\u00e1y m\u00ecnh v\u00e0o trang <a href=\"https:\/\/ipecho.net\/\" rel=\"nofollow noopener\" target=\"_blank\">https:\/\/ipecho.net\/<\/a> <a href=\"https:\/\/tino.vn\/blog\/huong-dan\/huong-dan-su-dung-chuc-nang-remote-mysql-tren-hosting-cpanel\/2019-06-10_13-33-08\/\" rel=\"attachment wp-att-1112\"><img decoding=\"async\" class=\"alignnone size-full wp-image-1112\" src=\"https:\/\/tino.vn\/blog\/wp-content\/uploads\/2019\/06\/2019-06-10_13-33-08.png\" alt=\"\" width=\"1280\" height=\"1200\" title=\"\" srcset=\"https:\/\/tino.vn\/blog\/wp-content\/uploads\/2019\/06\/2019-06-10_13-33-08.png 1280w, https:\/\/tino.vn\/blog\/wp-content\/uploads\/2019\/06\/2019-06-10_13-33-08-300x281.png 300w, https:\/\/tino.vn\/blog\/wp-content\/uploads\/2019\/06\/2019-06-10_13-33-08-1024x960.png 1024w, https:\/\/tino.vn\/blog\/wp-content\/uploads\/2019\/06\/2019-06-10_13-33-08-768x720.png 768w\" sizes=\"(max-width: 1280px) 100vw, 1280px\" \/><\/a><\/p>\n<h5 id=\"B\u01b0\u1edbc_3:_Thi\u1ebft_l\u1eadp_k\u1ebft_n\u1ed1i_MySQL\">B\u01b0\u1edbc 3: Thi\u1ebft l\u1eadp k\u1ebft n\u1ed1i MySQL<\/h5>\n<p>&#8211; B\u1ea1n m\u1edf ph\u1ea7n m\u1ec1m MySQL Workbench \u0111\u00e3 \u0111\u01b0\u1ee3c c\u00e0i \u0111\u1eb7t \u1edf b\u01b0\u1edbc tr\u01b0\u1edbc \u0111\u00f3.<\/p>\n<p>&#8211; Ch\u1ecdn d\u1ea5u (+) nh\u01b0 h\u00ecnh d\u01b0\u1edbi \u0111\u1ec3 m\u1edf k\u1ebft n\u1ed1i MySQL m\u1edbi:<\/p>\n<p><a href=\"https:\/\/tino.vn\/blog\/huong-dan\/huong-dan-su-dung-chuc-nang-remote-mysql-tren-hosting-cpanel\/2019-06-10_12-14-13\/\" rel=\"attachment wp-att-1101\"><img decoding=\"async\" class=\"alignnone size-full wp-image-1101\" src=\"https:\/\/tino.vn\/blog\/wp-content\/uploads\/2019\/06\/2019-06-10_12-14-13.png\" alt=\"\" width=\"1284\" height=\"823\" title=\"\" srcset=\"https:\/\/tino.vn\/blog\/wp-content\/uploads\/2019\/06\/2019-06-10_12-14-13.png 1284w, https:\/\/tino.vn\/blog\/wp-content\/uploads\/2019\/06\/2019-06-10_12-14-13-300x192.png 300w, https:\/\/tino.vn\/blog\/wp-content\/uploads\/2019\/06\/2019-06-10_12-14-13-1024x656.png 1024w, https:\/\/tino.vn\/blog\/wp-content\/uploads\/2019\/06\/2019-06-10_12-14-13-768x492.png 768w\" sizes=\"(max-width: 1284px) 100vw, 1284px\" \/><\/a><\/p>\n<p>&#8211; Nh\u1eadp c\u00e1c th\u00f4ng tin l\u1ea7n l\u01b0\u1ee3t theo h\u00ecnh d\u01b0\u1edbi<\/p>\n<p><a href=\"https:\/\/tino.vn\/blog\/huong-dan\/huong-dan-su-dung-chuc-nang-remote-mysql-tren-hosting-cpanel\/2019-06-10_12-15-33-2\/\" rel=\"attachment wp-att-1105\"><img decoding=\"async\" class=\"alignnone size-full wp-image-1105\" src=\"https:\/\/tino.vn\/blog\/wp-content\/uploads\/2019\/06\/2019-06-10_12-15-33-1.png\" alt=\"\" width=\"786\" height=\"493\" title=\"\" srcset=\"https:\/\/tino.vn\/blog\/wp-content\/uploads\/2019\/06\/2019-06-10_12-15-33-1.png 786w, https:\/\/tino.vn\/blog\/wp-content\/uploads\/2019\/06\/2019-06-10_12-15-33-1-300x188.png 300w, https:\/\/tino.vn\/blog\/wp-content\/uploads\/2019\/06\/2019-06-10_12-15-33-1-768x482.png 768w\" sizes=\"(max-width: 786px) 100vw, 786px\" \/><\/a><\/p>\n<p>Gi\u1ea3i th\u00edch c\u00e1c m\u1ee5c nh\u01b0 sau:<\/p>\n<p>0: B\u1ea1n nh\u1eadp t\u00ean c\u1ee7a k\u1ebft n\u1ed1i<\/p>\n<p>1:\u00a0 Nh\u1eadp Hostname: \u0110\u00e2y c\u00f3 th\u1ec3 l\u00e0 IP ho\u1eb7c hostname , m\u00ecnh k\u1ebft n\u1ed1i t\u1edbi Hosting c\u00f3 IP <strong><span id=\"txtIPAddress\" class=\"general-info-value\">103.130.216.100<\/span><\/strong><span id=\"txtIPAddress\" class=\"general-info-value\"> c\u00f3 hostname l\u00e0 <strong>h216100.tino.org<\/strong><\/span> , v\u00ec v\u1eady c\u00f3 th\u1ec3 \u0111i\u1ec1n v\u00e0o 1 trong 2.<\/p>\n<p>2: Username: T\u00ean user MySQL<\/p>\n<p>3: B\u1ea5m v\u00e0o \u0111\u1ec3 \u0111\u1ec3 l\u01b0u l\u1ea1i m\u1eadt kh\u1ea9u cho t\u00e0i kho\u1ea3n MySQL<\/p>\n<p>4: Nh\u1eadp v\u00e0o m\u1eadt kh\u1ea9u<\/p>\n<p>5: Ki\u1ec3m tra th\u1eed k\u1ebft n\u1ed1i<\/p>\n<p>&#8211; Th\u00f4ng b\u00e1o\u00a0 &#8220;<strong>Connection Warning<\/strong>&#8221; c\u00f3 th\u1ec3 xu\u1ea5t hi\u1ec7n n\u00e0y do m\u00e1y ch\u1ee7 MySQL tr\u00ean Hosting l\u00e0 <strong>MariaDB Server<\/strong>. MySQL Workbench l\u1ea1i thi\u1ebft k\u1ebf cho MySQL Server. MariaDB Server \u0111\u01b0\u1ee3c ph\u00e1t tri\u1ec3n t\u1eeb MySQL Server ra n\u00ean b\u1ea1n c\u00f3 th\u1ec3 y\u00ean t\u00e2m l\u00e0 c\u00f3 t\u01b0\u01a1ng th\u00edch nh\u00e9 (\u00edt nh\u1ea5t l\u00e0 v\u1edbi ch\u1ee9c n\u0103ng Import, Export database)<\/p>\n<p>&#8211; B\u1ea1n ti\u1ebfp t\u1ee5c ch\u1ecdn &#8220;<strong>Continute Anyway<\/strong>&#8220;, sau \u0111\u00f3 s\u1ebd s\u1ebd xu\u1ea5t hi\u1ec7n th\u00f4ng b\u00e1o t\u1ea1o th\u00e0nh c\u00f4ng k\u1ebft n\u1ed1i MySQL &#8220;<strong>Successfully made the MySQL connection<\/strong>&#8221; , b\u1ea1n ch\u1ecdn <strong>OK<\/strong> \u0111\u1ec3 ho\u00e0n t\u1ea5t<\/p>\n<p><a href=\"https:\/\/tino.vn\/blog\/huong-dan\/huong-dan-su-dung-chuc-nang-remote-mysql-tren-hosting-cpanel\/2019-06-10_12-15-07\/\" rel=\"attachment wp-att-1103\"><img decoding=\"async\" class=\"alignnone size-full wp-image-1103\" src=\"https:\/\/tino.vn\/blog\/wp-content\/uploads\/2019\/06\/2019-06-10_12-15-07.png\" alt=\"\" width=\"724\" height=\"361\" title=\"\" srcset=\"https:\/\/tino.vn\/blog\/wp-content\/uploads\/2019\/06\/2019-06-10_12-15-07.png 724w, https:\/\/tino.vn\/blog\/wp-content\/uploads\/2019\/06\/2019-06-10_12-15-07-300x150.png 300w\" sizes=\"(max-width: 724px) 100vw, 724px\" \/><\/a><\/p>\n<p>&#8211; Khi t\u1ea1o k\u1ebft n\u1ed1i xong s\u1ebd xu\u1ea5t hi\u1ec7n \u1edf trong danh s\u00e1ch k\u1ebft n\u1ed1i MySQL tr\u00ean MySQL Workbench, b\u1ea1n nh\u00e1y \u0111\u00fap v\u00e0o k\u1ebft n\u1ed1i \u0111\u1ec3 m\u1edf l\u00ean v\u00e0 s\u1eed d\u1ee5ng.<a href=\"https:\/\/tino.vn\/blog\/huong-dan\/huong-dan-su-dung-chuc-nang-remote-mysql-tren-hosting-cpanel\/2019-06-10_13-19-23\/\" rel=\"attachment wp-att-1106\"><img decoding=\"async\" class=\"alignnone size-full wp-image-1106\" src=\"https:\/\/tino.vn\/blog\/wp-content\/uploads\/2019\/06\/2019-06-10_13-19-23.png\" alt=\"\" width=\"1281\" height=\"823\" title=\"\" srcset=\"https:\/\/tino.vn\/blog\/wp-content\/uploads\/2019\/06\/2019-06-10_13-19-23.png 1281w, https:\/\/tino.vn\/blog\/wp-content\/uploads\/2019\/06\/2019-06-10_13-19-23-300x193.png 300w, https:\/\/tino.vn\/blog\/wp-content\/uploads\/2019\/06\/2019-06-10_13-19-23-1024x658.png 1024w, https:\/\/tino.vn\/blog\/wp-content\/uploads\/2019\/06\/2019-06-10_13-19-23-768x493.png 768w\" sizes=\"(max-width: 1281px) 100vw, 1281px\" \/><\/a><\/p>\n<p><a href=\"https:\/\/tino.vn\/blog\/huong-dan\/huong-dan-su-dung-chuc-nang-remote-mysql-tren-hosting-cpanel\/2019-06-10_13-20-43\/\" rel=\"attachment wp-att-1108\"><img decoding=\"async\" class=\"alignnone size-full wp-image-1108\" src=\"https:\/\/tino.vn\/blog\/wp-content\/uploads\/2019\/06\/2019-06-10_13-20-43.png\" alt=\"\" width=\"1281\" height=\"823\" title=\"\" srcset=\"https:\/\/tino.vn\/blog\/wp-content\/uploads\/2019\/06\/2019-06-10_13-20-43.png 1281w, https:\/\/tino.vn\/blog\/wp-content\/uploads\/2019\/06\/2019-06-10_13-20-43-300x193.png 300w, https:\/\/tino.vn\/blog\/wp-content\/uploads\/2019\/06\/2019-06-10_13-20-43-1024x658.png 1024w, https:\/\/tino.vn\/blog\/wp-content\/uploads\/2019\/06\/2019-06-10_13-20-43-768x493.png 768w\" sizes=\"(max-width: 1281px) 100vw, 1281px\" \/><\/a><\/p>\n<p>&#8211; V\u1ec1 vi\u1ec7c s\u1eed d\u1ee5ng MySQL Workbench b\u1ea1n tham kh\u1ea3o t\u1ea1i \u0111\u00e2y: <a href=\"https:\/\/dev.mysql.com\/doc\/workbench\/en\/\" rel=\"nofollow noopener\" target=\"_blank\">https:\/\/dev.mysql.com\/doc\/workbench\/en\/<\/a><\/p>\n<div id=\"simple-translate\">\n<div>\n<div class=\"simple-translate-button \" style=\"background-image: url('moz-extension:\/\/72906470-e4c9-4c9a-879d-cc785e6e726c\/icons\/512.png'); height: 22px; width: 22px; top: 10px; left: 10px;\"><\/div>\n<div class=\"simple-translate-panel \" style=\"width: 300px; height: 200px; top: 0px; left: 0px; font-size: 13px; background-color: #ffffff;\">\n<div class=\"simple-translate-result-wrapper\" style=\"overflow: hidden;\">\n<p class=\"simple-translate-candidate\" style=\"color: #737373;\">\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n","protected":false},"excerpt":{"rendered":"<p>Ch\u00e0o b\u1ea1n, trong b\u00e0i n\u00e0y TinoHost s\u1ebd h\u01b0\u1edbng d\u1eabn c\u00e1c b\u1ea1n s\u1eed d\u1ee5ng ch\u1ee9c n\u0103ng Remote MySQL\u00ae tr\u00ean Hosting cPanel \u0111\u1ec3 thi\u1ebft l\u1eadp k\u1ebft n\u1ed1i MySQL t\u1eeb xa (Remote MySQL). Thi\u1ebft l\u1eadp Remote MySQL v\u00e0 k\u1ebft n\u1ed1i b\u1eb1ng th\u01b0 vi\u1ec7n PHP B\u01b0\u1edbc 1: Thi\u1ebft t\u1eadp Remote MySQL\u00ae (MySQL t\u1eeb xa) tr\u00ean Hosting &#8211; \u0110\u0103ng v\u00e0o [&hellip;]<\/p>\n","protected":false},"author":4,"featured_media":1095,"menu_order":0,"comment_status":"closed","ping_status":"closed","template":"","format":"standard","meta":{"footnotes":""},"tags":[],"ht_kb_category":[5151],"class_list":["post-1094","ht_kb","type-ht_kb","status-publish","format-standard","has-post-thumbnail","hentry","ht_kb_category-cpanel"],"_links":{"self":[{"href":"https:\/\/tino.vn\/blog\/wp-json\/wp\/v2\/ht_kb\/1094","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/tino.vn\/blog\/wp-json\/wp\/v2\/ht_kb"}],"about":[{"href":"https:\/\/tino.vn\/blog\/wp-json\/wp\/v2\/types\/ht_kb"}],"author":[{"embeddable":true,"href":"https:\/\/tino.vn\/blog\/wp-json\/wp\/v2\/users\/4"}],"replies":[{"embeddable":true,"href":"https:\/\/tino.vn\/blog\/wp-json\/wp\/v2\/comments?post=1094"}],"version-history":[{"count":0,"href":"https:\/\/tino.vn\/blog\/wp-json\/wp\/v2\/ht_kb\/1094\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/tino.vn\/blog\/wp-json\/wp\/v2\/media\/1095"}],"wp:attachment":[{"href":"https:\/\/tino.vn\/blog\/wp-json\/wp\/v2\/media?parent=1094"}],"wp:term":[{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/tino.vn\/blog\/wp-json\/wp\/v2\/tags?post=1094"},{"taxonomy":"ht_kb_category","embeddable":true,"href":"https:\/\/tino.vn\/blog\/wp-json\/wp\/v2\/ht_kb_category?post=1094"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}