{"id":40457,"date":"2026-03-19T14:52:46","date_gmt":"2026-03-19T07:52:46","guid":{"rendered":"https:\/\/interdata.vn\/blog\/?p=40457"},"modified":"2026-05-18T13:40:39","modified_gmt":"2026-05-18T06:40:39","slug":"quan-ly-database-tren-cpanel","status":"publish","type":"post","link":"https:\/\/interdata.vn\/blog\/quan-ly-database-tren-cpanel\/","title":{"rendered":"Qu\u1ea3n l\u00fd database tr\u00ean cPanel: t\u1ea1o MySQL DB, t\u1ea1o user, c\u1ea5p quy\u1ec1n,&#8230; \u0111\u1ea7y \u0111\u1ee7"},"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\/quan-ly-database-tren-cpanel\/#MySQL-database-tren-cPanel-hoat-dong-nhu-the-nao\" >MySQL database tr\u00ean cPanel ho\u1ea1t \u0111\u1ed9ng nh\u01b0 th\u1ebf n\u00e0o?<\/a><ul class='ez-toc-list-level-3' ><li class='ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-2\" href=\"https:\/\/interdata.vn\/blog\/quan-ly-database-tren-cpanel\/#Database-va-database-user-%E2%80%94-tai-sao-lai-tach-biet\" >Database v\u00e0 database user \u2014 t\u1ea1i sao l\u1ea1i t\u00e1ch bi\u1ec7t?<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-3\" href=\"https:\/\/interdata.vn\/blog\/quan-ly-database-tren-cpanel\/#MariaDB-hay-MySQL-%E2%80%94-cPanel-dang-dung-gi\" >MariaDB hay MySQL \u2014 cPanel \u0111ang d\u00f9ng g\u00ec?<\/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\/quan-ly-database-tren-cpanel\/#Gioi-han-database-tren-hosting-chia-se\" >Gi\u1edbi h\u1ea1n database tr\u00ean hosting chia s\u1ebb<\/a><\/li><\/ul><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-5\" href=\"https:\/\/interdata.vn\/blog\/quan-ly-database-tren-cpanel\/#Tai-sao-can-quan-ly-dung-cach\" >T\u1ea1i sao c\u1ea7n qu\u1ea3n l\u00fd \u0111\u00fang c\u00e1ch?<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-6\" href=\"https:\/\/interdata.vn\/blog\/quan-ly-database-tren-cpanel\/#Cach-tao-MySQL-database-tren-cPanel\" >C\u00e1ch t\u1ea1o MySQL database tr\u00ean cPanel<\/a><ul class='ez-toc-list-level-3' ><li class='ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-7\" href=\"https:\/\/interdata.vn\/blog\/quan-ly-database-tren-cpanel\/#Dung-MySQL-Database-Wizard\" >D\u00f9ng MySQL Database Wizard<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-8\" href=\"https:\/\/interdata.vn\/blog\/quan-ly-database-tren-cpanel\/#Tao-database-thu-cong-qua-MySQL-Databases\" >T\u1ea1o database th\u1ee7 c\u00f4ng qua MySQL Databases<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-9\" href=\"https:\/\/interdata.vn\/blog\/quan-ly-database-tren-cpanel\/#Dat-ten-database-dung-cach\" >\u0110\u1eb7t t\u00ean database \u0111\u00fang c\u00e1ch<\/a><\/li><\/ul><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-10\" href=\"https:\/\/interdata.vn\/blog\/quan-ly-database-tren-cpanel\/#Tao-va-quan-ly-database-user-tren-cPanel\" >T\u1ea1o v\u00e0 qu\u1ea3n l\u00fd database user tr\u00ean cPanel<\/a><ul class='ez-toc-list-level-3' ><li class='ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-11\" href=\"https:\/\/interdata.vn\/blog\/quan-ly-database-tren-cpanel\/#Tao-database-user-moi\" >T\u1ea1o database user m\u1edbi<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-12\" href=\"https:\/\/interdata.vn\/blog\/quan-ly-database-tren-cpanel\/#Doi-password-database-user\" >\u0110\u1ed5i password database user<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-13\" href=\"https:\/\/interdata.vn\/blog\/quan-ly-database-tren-cpanel\/#Xoa-database-user-%E2%80%94-can-biet-gi-truoc-khi-xoa\" >X\u00f3a database user \u2014 c\u1ea7n bi\u1ebft g\u00ec tr\u01b0\u1edbc khi x\u00f3a<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-14\" href=\"https:\/\/interdata.vn\/blog\/quan-ly-database-tren-cpanel\/#Hosting-gia-re-%E2%80%94-co-san-cPanel-MySQL\" >Hosting gi\u00e1 r\u1ebb \u2014 c\u00f3 s\u1eb5n cPanel, MySQL<\/a><\/li><\/ul><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-15\" href=\"https:\/\/interdata.vn\/blog\/quan-ly-database-tren-cpanel\/#Cap-quyen-database-user-trong-cPanel\" >C\u1ea5p quy\u1ec1n database user 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-16\" href=\"https:\/\/interdata.vn\/blog\/quan-ly-database-tren-cpanel\/#Cac-muc-quyen-MySQL-va-khi-nao-dung-tung-muc\" >C\u00e1c m\u1ee9c quy\u1ec1n MySQL v\u00e0 khi n\u00e0o d\u00f9ng t\u1eebng m\u1ee9c<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-17\" href=\"https:\/\/interdata.vn\/blog\/quan-ly-database-tren-cpanel\/#Thay-doi-quyen-sau-khi-da-cap\" >Thay \u0111\u1ed5i quy\u1ec1n sau khi \u0111\u00e3 c\u1ea5p<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-18\" href=\"https:\/\/interdata.vn\/blog\/quan-ly-database-tren-cpanel\/#Kiem-tra-user-dang-co-quyen-gi\" >Ki\u1ec3m tra user \u0111ang c\u00f3 quy\u1ec1n g\u00ec<\/a><\/li><\/ul><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-19\" href=\"https:\/\/interdata.vn\/blog\/quan-ly-database-tren-cpanel\/#Su-dung-phpMyAdmin-tren-cPanel-%E2%80%94-tu-co-ban-den-thao-tac-thuc-te\" >S\u1eed d\u1ee5ng phpMyAdmin tr\u00ean cPanel \u2014 t\u1eeb c\u01a1 b\u1ea3n \u0111\u1ebfn thao t\u00e1c th\u1ef1c t\u1ebf<\/a><ul class='ez-toc-list-level-3' ><li class='ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-20\" href=\"https:\/\/interdata.vn\/blog\/quan-ly-database-tren-cpanel\/#Giao-dien-phpMyAdmin-%E2%80%94-doc-hieu-trong-2-phut\" >Giao di\u1ec7n phpMyAdmin \u2014 \u0111\u1ecdc hi\u1ec3u trong 2 ph\u00fat<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-21\" href=\"https:\/\/interdata.vn\/blog\/quan-ly-database-tren-cpanel\/#Import-database-tu-file-SQL\" >Import database t\u1eeb file SQL<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-22\" href=\"https:\/\/interdata.vn\/blog\/quan-ly-database-tren-cpanel\/#Export-database-%E2%80%94-backup-du-lieu-thu-cong\" >Export database \u2014 backup d\u1eef li\u1ec7u th\u1ee7 c\u00f4ng<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-23\" href=\"https:\/\/interdata.vn\/blog\/quan-ly-database-tren-cpanel\/#Chay-cau-lenh-SQL-truc-tiep\" >Ch\u1ea1y c\u00e2u l\u1ec7nh SQL tr\u1ef1c ti\u1ebfp<\/a><\/li><\/ul><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-24\" href=\"https:\/\/interdata.vn\/blog\/quan-ly-database-tren-cpanel\/#Ket-noi-ung-dung-web-voi-MySQL-database-tren-cPanel\" >K\u1ebft n\u1ed1i \u1ee9ng d\u1ee5ng web v\u1edbi MySQL database tr\u00ean cPanel<\/a><ul class='ez-toc-list-level-3' ><li class='ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-25\" href=\"https:\/\/interdata.vn\/blog\/quan-ly-database-tren-cpanel\/#4-thong-tin-ket-noi-bat-buoc\" >4 th\u00f4ng tin k\u1ebft n\u1ed1i b\u1eaft bu\u1ed9c<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-26\" href=\"https:\/\/interdata.vn\/blog\/quan-ly-database-tren-cpanel\/#Dien-thong-tin-vao-WordPress\" >\u0110i\u1ec1n th\u00f4ng tin v\u00e0o WordPress<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-27\" href=\"https:\/\/interdata.vn\/blog\/quan-ly-database-tren-cpanel\/#Ket-noi-tu-xa-Remote-MySQL\" >K\u1ebft n\u1ed1i t\u1eeb xa (Remote MySQL)<\/a><\/li><\/ul><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-28\" href=\"https:\/\/interdata.vn\/blog\/quan-ly-database-tren-cpanel\/#Loi-thuong-gap-khi-quan-ly-database-tren-cPanel-va-cach-xu-ly\" >L\u1ed7i th\u01b0\u1eddng g\u1eb7p khi qu\u1ea3n l\u00fd database tr\u00ean cPanel v\u00e0 c\u00e1ch x\u1eed l\u00fd<\/a><ul class='ez-toc-list-level-3' ><li class='ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-29\" href=\"https:\/\/interdata.vn\/blog\/quan-ly-database-tren-cpanel\/#%E2%80%9CAccess-denied-for-user%E2%80%9D-%E2%80%94-nguyen-nhan-va-cach-sua\" >&#8220;Access denied for user&#8221; \u2014 nguy\u00ean nh\u00e2n v\u00e0 c\u00e1ch s\u1eeda<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-30\" href=\"https:\/\/interdata.vn\/blog\/quan-ly-database-tren-cpanel\/#phpMyAdmin-bao-%E2%80%9CNo-database-selected%E2%80%9D\" >phpMyAdmin b\u00e1o &#8220;No database selected&#8221;<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-31\" href=\"https:\/\/interdata.vn\/blog\/quan-ly-database-tren-cpanel\/#Import-file-SQL-bi-loi-timeout\" >Import file SQL b\u1ecb l\u1ed7i timeout<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-32\" href=\"https:\/\/interdata.vn\/blog\/quan-ly-database-tren-cpanel\/#Khong-tim-thay-MySQL-Databases-trong-cPanel\" >Kh\u00f4ng t\u00ecm th\u1ea5y MySQL Databases trong cPanel<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-33\" href=\"https:\/\/interdata.vn\/blog\/quan-ly-database-tren-cpanel\/#VPS-InterData-%E2%80%94-toan-quyen-MySQL-NVMe-U2-gia-tu-hop-ly\" >VPS InterData \u2014 to\u00e0n quy\u1ec1n MySQL, NVMe U.2, gi\u00e1 t\u1eeb h\u1ee3p l\u00fd<\/a><\/li><\/ul><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-34\" href=\"https:\/\/interdata.vn\/blog\/quan-ly-database-tren-cpanel\/#Cau-hoi-thuong-gap-ve-quan-ly-database-tren-cPanel\" >C\u00e2u h\u1ecfi th\u01b0\u1eddng g\u1eb7p v\u1ec1 qu\u1ea3n l\u00fd database tr\u00ean cPanel<\/a><ul class='ez-toc-list-level-3' ><li class='ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-35\" href=\"https:\/\/interdata.vn\/blog\/quan-ly-database-tren-cpanel\/#Database-tren-cPanel-la-gi\" >Database tr\u00ean cPanel l\u00e0 g\u00ec?<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-36\" href=\"https:\/\/interdata.vn\/blog\/quan-ly-database-tren-cpanel\/#Tai-sao-tao-database-xong-roi-ma-ung-dung-van-bao-loi-ket-noi\" >T\u1ea1i sao t\u1ea1o database xong r\u1ed3i m\u00e0 \u1ee9ng d\u1ee5ng v\u1eabn b\u00e1o l\u1ed7i k\u1ebft n\u1ed1i?<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-37\" href=\"https:\/\/interdata.vn\/blog\/quan-ly-database-tren-cpanel\/#Ten-database-va-user-toi-nhap-trong-cPanel-co-khac-voi-ten-thuc-te-khong\" >T\u00ean database v\u00e0 user t\u00f4i nh\u1eadp trong cPanel c\u00f3 kh\u00e1c v\u1edbi t\u00ean th\u1ef1c t\u1ebf kh\u00f4ng?<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-38\" href=\"https:\/\/interdata.vn\/blog\/quan-ly-database-tren-cpanel\/#phpMyAdmin-trong-cPanel-dung-de-lam-gi\" >phpMyAdmin trong cPanel d\u00f9ng \u0111\u1ec3 l\u00e0m g\u00ec?<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-39\" href=\"https:\/\/interdata.vn\/blog\/quan-ly-database-tren-cpanel\/#Xoa-database-user-co-xoa-du-lieu-trong-database-khong\" >X\u00f3a database user c\u00f3 x\u00f3a d\u1eef li\u1ec7u trong database kh\u00f4ng?<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-40\" href=\"https:\/\/interdata.vn\/blog\/quan-ly-database-tren-cpanel\/#Co-the-dung-mot-database-user-cho-nhieu-database-khong\" >C\u00f3 th\u1ec3 d\u00f9ng m\u1ed9t database user cho nhi\u1ec1u database kh\u00f4ng?<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-41\" href=\"https:\/\/interdata.vn\/blog\/quan-ly-database-tren-cpanel\/#Import-file-SQL-lon-vao-phpMyAdmin-bi-loi-timeout-phai-lam-gi\" >Import file SQL l\u1edbn v\u00e0o phpMyAdmin b\u1ecb l\u1ed7i timeout ph\u1ea3i l\u00e0m g\u00ec?<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-42\" href=\"https:\/\/interdata.vn\/blog\/quan-ly-database-tren-cpanel\/#Remote-MySQL-la-gi-va-khi-nao-can-dung\" >Remote MySQL l\u00e0 g\u00ec v\u00e0 khi n\u00e0o c\u1ea7n d\u00f9ng?<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-43\" href=\"https:\/\/interdata.vn\/blog\/quan-ly-database-tren-cpanel\/#ALL-PRIVILEGES-nghia-la-gi-%E2%80%94-co-nen-cap-cho-moi-user-khong\" >ALL PRIVILEGES ngh\u0129a l\u00e0 g\u00ec \u2014 c\u00f3 n\u00ean c\u1ea5p cho m\u1ecdi user kh\u00f4ng?<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-44\" href=\"https:\/\/interdata.vn\/blog\/quan-ly-database-tren-cpanel\/#Co-the-doi-ten-database-da-tao-trong-cPanel-khong\" >C\u00f3 th\u1ec3 \u0111\u1ed5i t\u00ean database \u0111\u00e3 t\u1ea1o trong cPanel kh\u00f4ng?<\/a><\/li><\/ul><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-45\" href=\"https:\/\/interdata.vn\/blog\/quan-ly-database-tren-cpanel\/#Tong-ket-%E2%80%94-quy-trinh-chuan-va-nhung-diem-khong-bo-qua\" >T\u1ed5ng k\u1ebft \u2014 quy tr\u00ecnh chu\u1ea9n v\u00e0 nh\u1eefng \u0111i\u1ec3m kh\u00f4ng b\u1ecf qua<\/a><\/li><\/ul><\/nav><\/div>\n<div class=\"summary\">\n<p><strong>T\u00f3m t\u1eaft nhanh:<\/strong> Qu\u1ea3n l\u00fd database tr\u00ean cPanel bao g\u1ed3m 4 t\u00e1c v\u1ee5 c\u1ed1t l\u00f5i: t\u1ea1o MySQL database, t\u1ea1o database user, c\u1ea5p quy\u1ec1n truy c\u1eadp cho user v\u00e0o database, v\u00e0 thao t\u00e1c d\u1eef li\u1ec7u qua phpMyAdmin. cPanel t\u00e1ch bi\u1ec7t ho\u00e0n to\u00e0n database v\u00e0 user \u2014 t\u1ea1o xong c\u1ea3 hai v\u1eabn ch\u01b0a k\u1ebft n\u1ed1i \u0111\u01b0\u1ee3c cho \u0111\u1ebfn khi b\u1ea1n th\u1ef1c hi\u1ec7n b\u01b0\u1edbc c\u1ea5p quy\u1ec1n. Ng\u01b0\u1eddi qu\u1ea3n tr\u1ecb hosting, l\u1eadp tr\u00ecnh vi\u00ean PHP, v\u00e0 b\u1ea5t c\u1ee9 ai c\u1ea7n c\u00e0i WordPress, Joomla, hay b\u1ea5t k\u1ef3 \u1ee9ng d\u1ee5ng web n\u00e0o \u0111\u1ec1u ph\u1ea3i n\u1eafm quy tr\u00ecnh n\u00e0y.<\/p>\n<ul>\n<li>cPanel d\u00f9ng MySQL Databases wizard ho\u1eb7c trang MySQL Databases th\u1ee7 c\u00f4ng \u2014 wizard ph\u00f9 h\u1ee3p ng\u01b0\u1eddi m\u1edbi, trang th\u1ee7 c\u00f4ng linh ho\u1ea1t h\u01a1n khi qu\u1ea3n l\u00fd nhi\u1ec1u DB c\u00f9ng l\u00fac.<\/li>\n<li>M\u1ed9t database user c\u00f3 th\u1ec3 \u0111\u01b0\u1ee3c c\u1ea5p quy\u1ec1n cho nhi\u1ec1u database kh\u00e1c nhau, v\u00e0 m\u1ed9t database c\u00f3 th\u1ec3 c\u00f3 nhi\u1ec1u user v\u1edbi m\u1ee9c quy\u1ec1n kh\u00e1c nhau.<\/li>\n<li>phpMyAdmin tr\u00ean cPanel l\u00e0 giao di\u1ec7n \u0111\u1ed3 h\u1ecda \u0111\u1ec3 ch\u1ea1y SQL, import\/export d\u1eef li\u1ec7u, ch\u1ec9nh s\u1eeda b\u1ea3ng \u2014 kh\u00f4ng c\u1ea7n bi\u1ebft d\u00f2ng l\u1ec7nh.<\/li>\n<li>K\u1ebft n\u1ed1i \u1ee9ng d\u1ee5ng (WordPress, Laravel&#8230;) lu\u00f4n d\u00f9ng t\u00ean database v\u00e0 t\u00ean user \u0111\u00e3 t\u1ea1o trong cPanel, <em>kh\u00f4ng ph\u1ea3i<\/em> username \u0111\u0103ng nh\u1eadp cPanel.<\/li>\n<li>X\u00f3a database user kh\u1ecfi cPanel kh\u00f4ng x\u00f3a d\u1eef li\u1ec7u b\u00ean trong database \u2014 nh\u01b0ng x\u00f3a database th\u00ec m\u1ea5t d\u1eef li\u1ec7u v\u0129nh vi\u1ec5n n\u1ebfu kh\u00f4ng c\u00f3 backup.<\/li>\n<\/ul>\n<\/div>\n<p>B\u1ea1n v\u1eeba mua hosting, c\u00e0i xong <a href=\"https:\/\/interdata.vn\/blog\/wordpress-la-gi\/\">WordPress<\/a> v\u00e0 g\u1eb7p m\u00e0n h\u00ecnh tr\u1eafng v\u1edbi th\u00f4ng b\u00e1o &#8220;Error establishing a database connection.&#8221; Ho\u1eb7c \u0111ang c\u00e0i Joomla v\u00e0 b\u1ecb k\u1eb9t \u1edf b\u01b0\u1edbc nh\u1eadp th\u00f4ng tin database m\u00e0 kh\u00f4ng bi\u1ebft \u0111i\u1ec1n g\u00ec. T\u00ecnh hu\u1ed1ng n\u00e0y x\u1ea3y ra r\u1ea5t ph\u1ed5 bi\u1ebfn \u2014 kh\u00f4ng ph\u1ea3i v\u00ec cPanel ph\u1ee9c t\u1ea1p, m\u00e0 v\u00ec ph\u1ea7n l\u1edbn h\u01b0\u1edbng d\u1eabn c\u00e0i \u0111\u1eb7t \u1ee9ng d\u1ee5ng \u0111\u1ec1u b\u1ecf qua b\u01b0\u1edbc gi\u1ea3i th\u00edch logic ho\u1ea1t \u0111\u1ed9ng ph\u00eda sau.<\/p>\n<p>cPanel t\u1ed5 ch\u1ee9c h\u1ec7 th\u1ed1ng database theo m\u00f4 h\u00ecnh t\u00e1ch bi\u1ec7t: database l\u00e0 n\u01a1i l\u01b0u d\u1eef li\u1ec7u, database user l\u00e0 t\u00e0i kho\u1ea3n c\u00f3 quy\u1ec1n truy c\u1eadp. Hai th\u1ee9 n\u00e0y ho\u00e0n to\u00e0n \u0111\u1ed9c l\u1eadp cho \u0111\u1ebfn khi b\u1ea1n ch\u1ee7 \u0111\u1ed9ng k\u1ebft n\u1ed1i ch\u00fang. \u0110\u00e2y l\u00e0 \u0111i\u1ec3m m\u00e0 ng\u01b0\u1eddi m\u1edbi th\u01b0\u1eddng b\u1ecf qua, d\u1eabn \u0111\u1ebfn vi\u1ec7c t\u1ea1o xong database nh\u01b0ng \u1ee9ng d\u1ee5ng v\u1eabn kh\u00f4ng k\u1ebft n\u1ed1i \u0111\u01b0\u1ee3c.<\/p>\n<p>B\u00e0i vi\u1ebft n\u00e0y \u0111i theo \u0111\u00fang quy tr\u00ecnh th\u1ef1c t\u1ebf v\u1ec1 <strong>qu\u1ea3n l\u00fd database tr\u00ean cPanel t\u1eeb t\u1ea1o database, t\u1ea1o user, c\u1ea5p quy\u1ec1n, \u0111\u1ebfn thao t\u00e1c d\u1eef li\u1ec7u tr\u1ef1c ti\u1ebfp qua phpMyAdmin<\/strong> \u2014 k\u00e8m nh\u1eefng \u0111i\u1ec3m c\u1ea7n ch\u00fa \u00fd m\u00e0 ph\u1ea7n l\u1edbn t\u00e0i li\u1ec7u ch\u00ednh th\u1ee9c kh\u00f4ng \u0111\u1ec1 c\u1eadp.<\/p>\n<p><!-- H2 #1 \u2014 T\u1ed5ng quan --><\/p>\n<h2><span class=\"ez-toc-section\" id=\"MySQL-database-tren-cPanel-hoat-dong-nhu-the-nao\"><\/span>MySQL database tr\u00ean cPanel ho\u1ea1t \u0111\u1ed9ng nh\u01b0 th\u1ebf n\u00e0o?<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p><strong>MySQL database tr\u00ean cPanel<\/strong> l\u00e0 c\u01a1 s\u1edf d\u1eef li\u1ec7u quan h\u1ec7 ch\u1ea1y tr\u00ean MySQL Server (ho\u1eb7c MariaDB \u2014 m\u1ed9t nh\u00e1nh t\u01b0\u01a1ng th\u00edch) \u0111\u01b0\u1ee3c hosting provider qu\u1ea3n l\u00fd ph\u00eda server, trong khi cPanel cung c\u1ea5p giao di\u1ec7n \u0111\u1ec3 ng\u01b0\u1eddi d\u00f9ng t\u1ea1o v\u00e0 qu\u1ea3n l\u00fd database m\u00e0 kh\u00f4ng c\u1ea7n truy c\u1eadp tr\u1ef1c ti\u1ebfp v\u00e0o server.<\/p>\n<p>M\u1ed7i t\u00e0i kho\u1ea3n hosting c\u00f3 m\u1ed9t MySQL Server chung (ho\u1eb7c ri\u00eang, t\u00f9y g\u00f3i). cPanel ph\u00e2n quy\u1ec1n b\u1eb1ng c\u00e1ch g\u1eafn ti\u1ec1n t\u1ed1 username cPanel v\u00e0o t\u00ean database v\u00e0 user. V\u00ed d\u1ee5: t\u00e0i kho\u1ea3n cPanel t\u00ean <code>mysite<\/code> t\u1ea1o database t\u00ean <code>shop<\/code> \u2192 t\u00ean th\u1ef1c t\u1ebf trong MySQL s\u1ebd l\u00e0 <code>mysite_shop<\/code>. \u0110i\u1ec1u n\u00e0y ng\u0103n c\u00e1c t\u00e0i kho\u1ea3n hosting kh\u00e1c tr\u00ean c\u00f9ng server truy c\u1eadp v\u00e0o database c\u1ee7a nhau.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-40463\" src=\"https:\/\/interdata.vn\/blog\/wp-content\/uploads\/2026\/03\/MySQL-database-tren-cPanel.jpg\" alt=\"MySQL database tr\u00ean cPanel\" width=\"800\" height=\"500\" title=\"\" srcset=\"https:\/\/interdata.vn\/blog\/wp-content\/uploads\/2026\/03\/MySQL-database-tren-cPanel.jpg 800w, https:\/\/interdata.vn\/blog\/wp-content\/uploads\/2026\/03\/MySQL-database-tren-cPanel-300x188.jpg 300w, https:\/\/interdata.vn\/blog\/wp-content\/uploads\/2026\/03\/MySQL-database-tren-cPanel-768x480.jpg 768w\" sizes=\"auto, (max-width: 800px) 100vw, 800px\" \/><\/p>\n<h3><span class=\"ez-toc-section\" id=\"Database-va-database-user-%E2%80%94-tai-sao-lai-tach-biet\"><\/span>Database v\u00e0 database user \u2014 t\u1ea1i sao l\u1ea1i t\u00e1ch bi\u1ec7t?<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>Database l\u01b0u d\u1eef li\u1ec7u; database user l\u00e0 t\u00e0i kho\u1ea3n x\u00e1c th\u1ef1c \u0111\u1ec3 k\u1ebft n\u1ed1i \u0111\u1ebfn database \u0111\u00f3. T\u00e1ch bi\u1ec7t hai th\u1ee9 n\u00e0y cho ph\u00e9p b\u1ea1n linh ho\u1ea1t h\u01a1n trong qu\u1ea3n tr\u1ecb \u2014 v\u00ed d\u1ee5, c\u1ea5p cho m\u1ed9t user quy\u1ec1n ch\u1ec9 \u0111\u1ecdc (SELECT) \u0111\u1ec3 ph\u1ee5c v\u1ee5 b\u00e1o c\u00e1o, trong khi user kh\u00e1c c\u00f3 \u0111\u1ea7y \u0111\u1ee7 quy\u1ec1n \u0111\u1ec3 \u1ee9ng d\u1ee5ng ghi d\u1eef li\u1ec7u.<\/p>\n<p>K\u1ecbch b\u1ea3n th\u1ef1c t\u1ebf: m\u1ed9t website th\u01b0\u01a1ng m\u1ea1i \u0111i\u1ec7n t\u1eed c\u00f3 th\u1ec3 c\u1ea7n 3 user cho c\u00f9ng 1 database \u2014 user cho \u1ee9ng d\u1ee5ng ch\u00ednh (full quy\u1ec1n), user cho c\u00f4ng c\u1ee5 backup (ch\u1ec9 SELECT), v\u00e0 user cho \u0111\u1ed9i marketing truy c\u1eadp b\u00e1o c\u00e1o (SELECT m\u1ed9t s\u1ed1 b\u1ea3ng nh\u1ea5t \u0111\u1ecbnh). Ki\u1ebfn tr\u00fac n\u00e0y kh\u00f4ng l\u00e0m \u0111\u01b0\u1ee3c n\u1ebfu database v\u00e0 user g\u1eafn li\u1ec1n v\u1edbi nhau.<\/p>\n<h3><span class=\"ez-toc-section\" id=\"MariaDB-hay-MySQL-%E2%80%94-cPanel-dang-dung-gi\"><\/span>MariaDB hay MySQL \u2014 cPanel \u0111ang d\u00f9ng g\u00ec?<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>Ph\u1ea7n l\u1edbn hosting provider hi\u1ec7n nay ch\u1ea1y MariaDB thay v\u00ec MySQL g\u1ed1c, nh\u01b0ng cPanel v\u1eabn hi\u1ec3n th\u1ecb giao di\u1ec7n v\u1edbi t\u00ean &#8220;MySQL Databases&#8221; v\u00ec MariaDB t\u01b0\u01a1ng th\u00edch ho\u00e0n to\u00e0n v\u1edbi MySQL \u1edf c\u1ea5p giao th\u1ee9c v\u00e0 c\u00e2u l\u1ec7nh SQL. \u1ee8ng d\u1ee5ng PHP vi\u1ebft cho MySQL ch\u1ea1y \u0111\u01b0\u1ee3c tr\u00ean MariaDB m\u00e0 kh\u00f4ng c\u1ea7n s\u1eeda code.<\/p>\n<p>S\u1ef1 kh\u00e1c bi\u1ec7t ch\u1ec9 \u0111\u00e1ng ch\u00fa \u00fd \u1edf t\u1ea7ng qu\u1ea3n tr\u1ecb n\u00e2ng cao (JSON functions, m\u1ed9t s\u1ed1 optimization hint). V\u1edbi ng\u01b0\u1eddi d\u00f9ng hosting th\u00f4ng th\u01b0\u1eddng, MariaDB hay MySQL kh\u00f4ng t\u1ea1o ra s\u1ef1 kh\u00e1c bi\u1ec7t n\u00e0o trong c\u00e1ch d\u00f9ng cPanel.<\/p>\n<h3><span class=\"ez-toc-section\" id=\"Gioi-han-database-tren-hosting-chia-se\"><\/span>Gi\u1edbi h\u1ea1n database tr\u00ean hosting chia s\u1ebb<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>Shared hosting th\u01b0\u1eddng gi\u1edbi h\u1ea1n s\u1ed1 l\u01b0\u1ee3ng database t\u1ed1i \u0111a theo g\u00f3i \u2014 con s\u1ed1 dao \u0111\u1ed9ng t\u1eeb 5 \u0111\u1ebfn &#8220;kh\u00f4ng gi\u1edbi h\u1ea1n&#8221; t\u00f9y nh\u00e0 cung c\u1ea5p. Quan tr\u1ecdng h\u01a1n l\u00e0 gi\u1edbi h\u1ea1n dung l\u01b0\u1ee3ng: MySQL database tr\u00ean shared hosting th\u01b0\u1eddng b\u1ecb cap \u1edf m\u1ee9c 50MB \u0111\u1ebfn 1GB m\u1ed7i database, ho\u1eb7c t\u1ed5ng dung l\u01b0\u1ee3ng t\u1ea5t c\u1ea3 database trong t\u00e0i kho\u1ea3n. Khi database g\u1ea7n \u0111\u1ea7y, \u1ee9ng d\u1ee5ng s\u1ebd g\u1eb7p l\u1ed7i ghi d\u1eef li\u1ec7u tr\u01b0\u1edbc khi b\u1ea1n nh\u1eadn \u0111\u01b0\u1ee3c c\u1ea3nh b\u00e1o \u2014 \u0111\u00e2y l\u00e0 l\u00fd do n\u00ean theo d\u00f5i dung l\u01b0\u1ee3ng \u0111\u1ecbnh k\u1ef3 qua cPanel.<\/p>\n<p>N\u1ebfu \u1ee9ng d\u1ee5ng c\u1ee7a b\u1ea1n c\u00f3 l\u01b0\u1ee3ng d\u1eef li\u1ec7u l\u1edbn ho\u1eb7c c\u1ea7n truy c\u1eadp \u0111\u1ed3ng th\u1eddi cao, <strong><a href=\"https:\/\/interdata.vn\/platinum\/\">thu\u00ea VPS Platinum v\u1edbi full quy\u1ec1n qu\u1ea3n tr\u1ecb MySQL Server<\/a><\/strong> l\u00e0 l\u1ef1a ch\u1ecdn ph\u00f9 h\u1ee3p h\u01a1n shared hosting.<\/p>\n<h2><span class=\"ez-toc-section\" id=\"Tai-sao-can-quan-ly-dung-cach\"><\/span>T\u1ea1i sao c\u1ea7n qu\u1ea3n l\u00fd \u0111\u00fang c\u00e1ch?<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>Vi\u1ec7c s\u1eed d\u1ee5ng c\u01a1 s\u1edf d\u1eef li\u1ec7u tr\u00ean Hosting cPanel \u0111\u00fang c\u00e1ch l\u00e0 r\u1ea5t quan tr\u1ecdng v\u1edbi m\u1ed9t s\u1ed1 l\u00fd do ch\u00ednh sau \u0111\u00e2y:<\/p>\n<ul>\n<li><strong>L\u01b0u tr\u1eef th\u00f4ng tin:<\/strong> C\u01a1 s\u1edf d\u1eef li\u1ec7u cho ph\u00e9p l\u01b0u tr\u1eef t\u1ea5t c\u1ea3 th\u00f4ng tin c\u1ea7n thi\u1ebft cho website, bao g\u1ed3m n\u1ed9i dung, ng\u01b0\u1eddi d\u00f9ng, v\u00e0 c\u00e1c th\u00f4ng tin kh\u00e1c. V\u00ed d\u1ee5, n\u1ebfu b\u1ea1n s\u1eed d\u1ee5ng m\u1ed9t h\u1ec7 th\u1ed1ng qu\u1ea3n l\u00fd n\u1ed9i dung (CMS) nh\u01b0 WordPress, c\u01a1 s\u1edf d\u1eef li\u1ec7u s\u1ebd l\u01b0u tr\u1eef t\u1ea5t c\u1ea3 c\u00e1c b\u00e0i vi\u1ebft, trang, v\u00e0 th\u00f4ng tin ng\u01b0\u1eddi d\u00f9ng.<\/li>\n<li><strong>Qu\u1ea3n l\u00fd th\u00f4ng tin hi\u1ec7u qu\u1ea3:<\/strong> C\u01a1 s\u1edf d\u1eef li\u1ec7u gi\u00fap t\u1ed5 ch\u1ee9c v\u00e0 qu\u1ea3n l\u00fd th\u00f4ng tin m\u1ed9t c\u00e1ch c\u00f3 h\u1ec7 th\u1ed1ng, gi\u1ea3m thi\u1ec3u s\u1ef1 tr\u00f9ng l\u1eb7p v\u00e0 \u0111\u1ea3m b\u1ea3o t\u00ednh to\u00e0n v\u1eb9n c\u1ee7a d\u1eef li\u1ec7u. \u0110i\u1ec1u n\u00e0y r\u1ea5t quan tr\u1ecdng trong vi\u1ec7c duy tr\u00ec hi\u1ec7u su\u1ea5t c\u1ee7a website v\u00e0 \u0111\u1ea3m b\u1ea3o r\u1eb1ng ng\u01b0\u1eddi d\u00f9ng c\u00f3 th\u1ec3 truy c\u1eadp th\u00f4ng tin m\u1ed9t c\u00e1ch nhanh ch\u00f3ng v\u00e0 ch\u00ednh x\u00e1c.<\/li>\n<li><strong>Kh\u1ea3 n\u0103ng m\u1edf r\u1ed9ng:<\/strong> Khi website ph\u00e1t tri\u1ec3n, l\u01b0\u1ee3ng d\u1eef li\u1ec7u c\u1ea7n l\u01b0u tr\u1eef c\u0169ng t\u0103ng l\u00ean. C\u01a1 s\u1edf d\u1eef li\u1ec7u c\u00f3 th\u1ec3 m\u1edf r\u1ed9ng d\u1ec5 d\u00e0ng \u0111\u1ec3 \u0111\u00e1p \u1ee9ng nhu c\u1ea7u n\u00e0y, cho ph\u00e9p b\u1ea1n th\u00eam nhi\u1ec1u b\u1ea3ng, tr\u01b0\u1eddng v\u00e0 m\u1ed1i quan h\u1ec7 gi\u1eefa c\u00e1c d\u1eef li\u1ec7u m\u00e0 kh\u00f4ng l\u00e0m \u1ea3nh h\u01b0\u1edfng \u0111\u1ebfn hi\u1ec7u su\u1ea5t c\u1ee7a h\u1ec7 th\u1ed1ng.<\/li>\n<li><strong>H\u1ed7 tr\u1ee3 nhi\u1ec1u ng\u01b0\u1eddi d\u00f9ng:<\/strong> C\u01a1 s\u1edf d\u1eef li\u1ec7u cho ph\u00e9p nhi\u1ec1u ng\u01b0\u1eddi d\u00f9ng truy c\u1eadp v\u00e0 t\u01b0\u01a1ng t\u00e1c v\u1edbi d\u1eef li\u1ec7u c\u00f9ng m\u1ed9t l\u00fac. \u0110i\u1ec1u n\u00e0y r\u1ea5t quan tr\u1ecdng \u0111\u1ed1i v\u1edbi c\u00e1c <a href=\"https:\/\/interdata.vn\/blog\/web-application-la-gi\/\">\u1ee9ng d\u1ee5ng web<\/a> v\u00e0 d\u1ecbch v\u1ee5 tr\u1ef1c tuy\u1ebfn, n\u01a1i m\u00e0 nhi\u1ec1u ng\u01b0\u1eddi d\u00f9ng c\u00f3 th\u1ec3 c\u1ea7n truy c\u1eadp th\u00f4ng tin \u0111\u1ed3ng th\u1eddi.<\/li>\n<li><strong>B\u1ea3o m\u1eadt v\u00e0 qu\u1ea3n l\u00fd quy\u1ec1n truy c\u1eadp:<\/strong> C\u01a1 s\u1edf d\u1eef li\u1ec7u cho ph\u00e9p b\u1ea1n thi\u1ebft l\u1eadp c\u00e1c quy\u1ec1n truy c\u1eadp kh\u00e1c nhau cho ng\u01b0\u1eddi d\u00f9ng, \u0111\u1ea3m b\u1ea3o r\u1eb1ng ch\u1ec9 nh\u1eefng ng\u01b0\u1eddi c\u00f3 quy\u1ec1n m\u1edbi c\u00f3 th\u1ec3 truy c\u1eadp ho\u1eb7c thay \u0111\u1ed5i d\u1eef li\u1ec7u nh\u1ea1y c\u1ea3m. \u0110i\u1ec1u n\u00e0y gi\u00fap b\u1ea3o v\u1ec7 th\u00f4ng tin quan tr\u1ecdng c\u1ee7a b\u1ea1n kh\u1ecfi c\u00e1c truy c\u1eadp tr\u00e1i ph\u00e9p.<\/li>\n<\/ul>\n<p><!-- H2 #2 \u2014 T\u1ea1o MySQL Database --><\/p>\n<h2><span class=\"ez-toc-section\" id=\"Cach-tao-MySQL-database-tren-cPanel\"><\/span>C\u00e1ch t\u1ea1o MySQL database tr\u00ean cPanel<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>\u0110\u1ec3 b\u1eaft \u0111\u1ea7u l\u01b0u tr\u1eef d\u1eef li\u1ec7u cho website, b\u01b0\u1edbc \u0111\u1ea7u ti\u00ean b\u1ea1n c\u1ea7n th\u1ef1c hi\u1ec7n l\u00e0 t\u1ea1o database mysql cpanel v\u00e0 thi\u1ebft l\u1eadp User c\u00f3 quy\u1ec1n truy c\u1eadp t\u01b0\u01a1ng \u1ee9ng. Xem th\u00eam <strong><a href=\"https:\/\/interdata.vn\/blog\/cach-tao-database-tren-hosting-cpanel\/\">c\u00e1ch t\u1ea1o, qu\u1ea3n l\u00ed Database tr\u00ean Hosting cPanel t\u1ea1i \u0111\u00e2y<\/a><\/strong>.<\/p>\n<p>cPanel cung c\u1ea5p hai \u0111\u01b0\u1eddng v\u00e0o \u0111\u1ec3 t\u1ea1o database: <strong>MySQL Database Wizard<\/strong> (wizard t\u1eebng b\u01b0\u1edbc, ph\u00f9 h\u1ee3p ng\u01b0\u1eddi m\u1edbi) v\u00e0 <strong>MySQL Databases<\/strong> (trang qu\u1ea3n l\u00fd \u0111\u1ea7y \u0111\u1ee7, linh ho\u1ea1t h\u01a1n). C\u1ea3 hai \u0111\u1ec1u t\u1ea1o ra k\u1ebft qu\u1ea3 nh\u01b0 nhau \u2014 ch\u1ec9 kh\u00e1c \u1edf tr\u1ea3i nghi\u1ec7m thao t\u00e1c.<\/p>\n<h3><span class=\"ez-toc-section\" id=\"Dung-MySQL-Database-Wizard\"><\/span>D\u00f9ng MySQL Database Wizard<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>Wizard l\u00e0 c\u00e1ch nhanh nh\u1ea5t \u0111\u1ec3 t\u1ea1o xong to\u00e0n b\u1ed9 chu\u1ed7i database \u2192 user \u2192 c\u1ea5p quy\u1ec1n trong m\u1ed9t lu\u1ed3ng li\u00ean t\u1ee5c. Ph\u00f9 h\u1ee3p khi b\u1ea1n c\u00e0i m\u1ed9t \u1ee9ng d\u1ee5ng m\u1edbi v\u00e0 c\u1ea7n setup nhanh.<\/p>\n<p><strong>\u0110\u0103ng nh\u1eadp cPanel<\/strong>, t\u00ecm m\u1ee5c <em>Databases<\/em>, click v\u00e0o <strong>Database Wizard<\/strong>.<\/p>\n<p><strong>B\u01b0\u1edbc 1 \u2014 T\u1ea1o database:<\/strong> Nh\u1eadp t\u00ean database v\u00e0o \u00f4 &#8220;New Database&#8221; \u2192 click <em>Next Step<\/em>. T\u00ean th\u1ef1c t\u1ebf s\u1ebd c\u00f3 ti\u1ec1n t\u1ed1 username cPanel t\u1ef1 \u0111\u1ed9ng \u0111\u01b0\u1ee3c g\u1eafn v\u00e0o (v\u00ed d\u1ee5: <code>username_t\u00eanb\u1ea1nnh\u1eadp<\/code>). Ghi l\u1ea1i t\u00ean \u0111\u1ea7y \u0111\u1ee7 n\u00e0y \u2014 b\u1ea1n s\u1ebd c\u1ea7n khi c\u1ea5u h\u00ecnh \u1ee9ng d\u1ee5ng.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-40458\" src=\"https:\/\/interdata.vn\/blog\/wp-content\/uploads\/2026\/03\/Nhap-New-Database-va-nhan-next-step.png\" alt=\"Nh\u1eadp New Database v\u00e0 nh\u1ea5n next step\" width=\"496\" height=\"346\" title=\"\" srcset=\"https:\/\/interdata.vn\/blog\/wp-content\/uploads\/2026\/03\/Nhap-New-Database-va-nhan-next-step.png 496w, https:\/\/interdata.vn\/blog\/wp-content\/uploads\/2026\/03\/Nhap-New-Database-va-nhan-next-step-300x209.png 300w\" sizes=\"auto, (max-width: 496px) 100vw, 496px\" \/><\/p>\n<p><strong>B\u01b0\u1edbc 2 \u2014 T\u1ea1o user:<\/strong> Nh\u1eadp username v\u00e0 password. Password n\u00ean d\u00e0i \u00edt nh\u1ea5t 12 k\u00fd t\u1ef1, k\u1ebft h\u1ee3p ch\u1eef hoa, ch\u1eef th\u01b0\u1eddng, s\u1ed1, v\u00e0 k\u00fd t\u1ef1 \u0111\u1eb7c bi\u1ec7t. cPanel c\u00f3 c\u00f4ng c\u1ee5 generate password ng\u1eabu nhi\u00ean \u2014 d\u00f9ng t\u00ednh n\u0103ng n\u00e0y \u0111\u1ec3 tr\u00e1nh password y\u1ebfu.<\/p>\n<p><strong>B\u01b0\u1edbc 3 \u2014 C\u1ea5p quy\u1ec1n:<\/strong> Ch\u1ecdn m\u1ee9c quy\u1ec1n cho user v\u1eeba t\u1ea1o. V\u1edbi \u1ee9ng d\u1ee5ng web th\u00f4ng th\u01b0\u1eddng, ch\u1ecdn <em>ALL PRIVILEGES<\/em>. Xem chi ti\u1ebft v\u1ec1 t\u1eebng quy\u1ec1n \u1edf ph\u1ea7n c\u1ea5p quy\u1ec1n ph\u00eda d\u01b0\u1edbi.<\/p>\n<p><strong>Ho\u00e0n t\u1ea5t:<\/strong> Wizard hi\u1ec3n th\u1ecb t\u00f3m t\u1eaft. Database v\u00e0 user \u0111\u00e3 \u0111\u01b0\u1ee3c k\u1ebft n\u1ed1i \u2014 b\u1ea1n c\u00f3 th\u1ec3 b\u1eaft \u0111\u1ea7u c\u1ea5u h\u00ecnh \u1ee9ng d\u1ee5ng.<\/p>\n<h3><span class=\"ez-toc-section\" id=\"Tao-database-thu-cong-qua-MySQL-Databases\"><\/span>T\u1ea1o database th\u1ee7 c\u00f4ng qua MySQL Databases<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>Trang MySQL Databases cho ph\u00e9p qu\u1ea3n l\u00fd to\u00e0n b\u1ed9 database v\u00e0 user trong t\u00e0i kho\u1ea3n t\u1eeb m\u1ed9t m\u00e0n h\u00ecnh. Ch\u1ecdn c\u00e1ch n\u00e0y khi b\u1ea1n c\u1ea7n t\u1ea1o nhi\u1ec1u database c\u00f9ng l\u00fac, ho\u1eb7c c\u1ea7n assign m\u1ed9t user \u0111\u00e3 t\u1ed3n t\u1ea1i v\u00e0o database m\u1edbi.<\/p>\n<p>V\u00e0o <strong>MySQL Databases<\/strong> (kh\u00f4ng ph\u1ea3i Wizard). T\u00ecm ph\u1ea7n <em>Create New Database<\/em> \u1edf \u0111\u1ea7u trang.<\/p>\n<p>Nh\u1eadp t\u00ean database \u2192 click <strong>Create Database<\/strong>. H\u1ec7 th\u1ed1ng x\u00e1c nh\u1eadn t\u1ea1o th\u00e0nh c\u00f4ng.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-40459\" src=\"https:\/\/interdata.vn\/blog\/wp-content\/uploads\/2026\/03\/nhap-new-Database-va-nhan-Create-Database.png\" alt=\"nh\u1eadp new Database v\u00e0 nh\u1ea5n Create Database\" width=\"584\" height=\"214\" title=\"\" srcset=\"https:\/\/interdata.vn\/blog\/wp-content\/uploads\/2026\/03\/nhap-new-Database-va-nhan-Create-Database.png 584w, https:\/\/interdata.vn\/blog\/wp-content\/uploads\/2026\/03\/nhap-new-Database-va-nhan-Create-Database-300x110.png 300w\" sizes=\"auto, (max-width: 584px) 100vw, 584px\" \/><\/p>\n<p>Cu\u1ed9n xu\u1ed1ng ph\u1ea7n <em>Database Users<\/em>\u00a0\u2192 <em>Add New User<\/em> n\u1ebfu c\u1ea7n t\u1ea1o user m\u1edbi. N\u1ebfu \u0111\u00e3 c\u00f3 user \u2192 b\u1ecf qua b\u01b0\u1edbc n\u00e0y.<\/p>\n<p>Cu\u1ed9n ti\u1ebfp \u0111\u1ebfn ph\u1ea7n <em>Add User to Database<\/em> \u2192 ch\u1ecdn user v\u00e0 database t\u1eeb dropdown \u2192 click <strong>Add<\/strong>.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-40460\" src=\"https:\/\/interdata.vn\/blog\/wp-content\/uploads\/2026\/03\/Add-User-to-Database.png\" alt=\"Add User to Database\" width=\"673\" height=\"277\" title=\"\" srcset=\"https:\/\/interdata.vn\/blog\/wp-content\/uploads\/2026\/03\/Add-User-to-Database.png 673w, https:\/\/interdata.vn\/blog\/wp-content\/uploads\/2026\/03\/Add-User-to-Database-300x123.png 300w\" sizes=\"auto, (max-width: 673px) 100vw, 673px\" \/><\/p>\n<p>Trang Manage User Privileges xu\u1ea5t hi\u1ec7n \u2192 ch\u1ecdn quy\u1ec1n \u2192 <strong>Make Changes<\/strong>.<\/p>\n<p>Kh\u00e1c v\u1edbi Wizard, trang th\u1ee7 c\u00f4ng kh\u00f4ng b\u1eaft bu\u1ed9c b\u1ea1n ph\u1ea3i \u0111i theo th\u1ee9 t\u1ef1. B\u1ea1n c\u00f3 th\u1ec3 t\u1ea1o 5 database tr\u01b0\u1edbc, sau \u0111\u00f3 t\u1ea1o user v\u00e0 assign m\u1ed9t l\u1ea7n. Xem th\u00eam v\u1ec1<strong><a href=\"https:\/\/interdata.vn\/blog\/cach-tao-database-tren-hosting-cpanel\/\"> c\u00e1ch t\u1ea1o v\u00e0 qu\u1ea3n l\u00fd database user cPanel n\u00e2ng cao<\/a><\/strong> n\u1ebfu c\u1ea7n ph\u00e2n quy\u1ec1n chi ti\u1ebft h\u01a1n.<\/p>\n<h3><span class=\"ez-toc-section\" id=\"Dat-ten-database-dung-cach\"><\/span>\u0110\u1eb7t t\u00ean database \u0111\u00fang c\u00e1ch<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>cPanel gi\u1edbi h\u1ea1n t\u00ean database t\u1ed1i \u0111a 64 k\u00fd t\u1ef1 (bao g\u1ed3m ti\u1ec1n t\u1ed1 username). Ch\u1ec9 d\u00f9ng ch\u1eef th\u01b0\u1eddng, ch\u1eef s\u1ed1, v\u00e0 d\u1ea5u g\u1ea1ch d\u01b0\u1edbi (<code>_<\/code>) \u2014 kh\u00f4ng d\u1ea5u c\u00e1ch, kh\u00f4ng k\u00fd t\u1ef1 \u0111\u1eb7c bi\u1ec7t. M\u1ed9t s\u1ed1 \u1ee9ng d\u1ee5ng nh\u01b0 WordPress kh\u00f4ng quan t\u00e2m t\u00ean database, nh\u01b0ng v\u1edbi project t\u1ef1 ph\u00e1t tri\u1ec3n, n\u00ean \u0111\u1eb7t t\u00ean m\u00f4 t\u1ea3 \u0111\u01b0\u1ee3c n\u1ed9i dung: <code>mysite_ecommerce<\/code> r\u00f5 h\u01a1n <code>mysite_db1<\/code> khi b\u1ea1n nh\u00ecn l\u1ea1i sau 6 th\u00e1ng.<\/p>\n<p><!-- H2 #3 \u2014 T\u1ea1o v\u00e0 qu\u1ea3n l\u00fd Database User --><\/p>\n<h2><span class=\"ez-toc-section\" id=\"Tao-va-quan-ly-database-user-tren-cPanel\"><\/span>T\u1ea1o v\u00e0 qu\u1ea3n l\u00fd database user tr\u00ean cPanel<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>Database user l\u00e0 th\u00e0nh ph\u1ea7n x\u00e1c th\u1ef1c \u2014 thi\u1ebfu b\u01b0\u1edbc n\u00e0y, kh\u00f4ng \u1ee9ng d\u1ee5ng n\u00e0o k\u1ebft n\u1ed1i \u0111\u01b0\u1ee3c v\u00e0o database d\u00f9 b\u1ea1n \u0111\u00e3 t\u1ea1o database th\u00e0nh c\u00f4ng. Ph\u1ea7n l\u1edbn l\u1ed7i &#8220;Access denied for user&#8221; khi c\u00e0i WordPress hay Joomla \u0111\u1ec1u xu\u1ea5t ph\u00e1t t\u1eeb \u0111\u00e2y.<\/p>\n<h3><span class=\"ez-toc-section\" id=\"Tao-database-user-moi\"><\/span>T\u1ea1o database user m\u1edbi<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>V\u00e0o <strong>MySQL Databases<\/strong> \u2192 ph\u1ea7n <em>MySQL Users<\/em> \u2192 <em>Add New User<\/em>. \u0110i\u1ec1n username v\u00e0 password. T\u00ean user th\u1ef1c t\u1ebf trong MySQL c\u0169ng s\u1ebd c\u00f3 ti\u1ec1n t\u1ed1 cPanel username \u2014 v\u00ed d\u1ee5 b\u1ea1n nh\u1eadp <code>shopuser<\/code> v\u00e0 cPanel username l\u00e0 <code>mysite<\/code>, user th\u1ef1c t\u1ebf l\u00e0 <code>mysite_shopuser<\/code>.<\/p>\n<p>V\u1ec1 password: cPanel cho ph\u00e9p b\u1ea1n d\u00f9ng Password Generator \u0111\u1ec3 t\u1ea1o password ng\u1eabu nhi\u00ean \u0111\u1ee7 m\u1ea1nh. L\u01b0u password n\u00e0y v\u00e0o ch\u1ed7 an to\u00e0n ngay l\u00fac t\u1ea1o \u2014 sau n\u00e0y kh\u00f4ng c\u00f3 c\u00e1ch n\u00e0o xem l\u1ea1i password c\u0169, ch\u1ec9 c\u00f3 th\u1ec3 \u0111\u1ed5i password m\u1edbi.<\/p>\n<h3><span class=\"ez-toc-section\" id=\"Doi-password-database-user\"><\/span>\u0110\u1ed5i password database user<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>V\u00e0o <strong>MySQL Databases<\/strong> \u2192 ph\u1ea7n <em>Current Users<\/em> \u2192 click v\u00e0o t\u00ean user \u2192 <em>Change Password<\/em>. Sau khi \u0111\u1ed5i, m\u1ecdi \u1ee9ng d\u1ee5ng \u0111ang k\u1ebft n\u1ed1i b\u1eb1ng user n\u00e0y s\u1ebd b\u1ecb disconnect ngay l\u1eadp t\u1ee9c v\u00e0 b\u00e1o l\u1ed7i authentication. B\u1ea1n c\u1ea7n c\u1eadp nh\u1eadt file config c\u1ee7a t\u1eebng \u1ee9ng d\u1ee5ng (wp-config.php v\u1edbi WordPress, .env v\u1edbi Laravel, configuration.php v\u1edbi Joomla) tr\u01b0\u1edbc khi ho\u1eb7c ngay sau khi \u0111\u1ed5i password.<\/p>\n<h3><span class=\"ez-toc-section\" id=\"Xoa-database-user-%E2%80%94-can-biet-gi-truoc-khi-xoa\"><\/span>X\u00f3a database user \u2014 c\u1ea7n bi\u1ebft g\u00ec tr\u01b0\u1edbc khi x\u00f3a<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>X\u00f3a database user trong cPanel kh\u00f4ng x\u00f3a database m\u00e0 user \u0111\u00f3 \u0111ang c\u00f3 quy\u1ec1n truy c\u1eadp. D\u1eef li\u1ec7u trong database v\u1eabn nguy\u00ean v\u1eb9n. Nh\u01b0ng \u1ee9ng d\u1ee5ng \u0111ang d\u00f9ng user \u0111\u00f3 s\u1ebd kh\u00f4ng k\u1ebft n\u1ed1i \u0111\u01b0\u1ee3c n\u1eefa \u2014 x\u1eed l\u00fd nh\u01b0 downtime ho\u00e0n to\u00e0n.<\/p>\n<p>Tr\u00ecnh t\u1ef1 \u0111\u00fang tr\u01b0\u1edbc khi x\u00f3a user: ki\u1ec3m tra xem user \u0111\u00f3 \u0111ang \u0111\u01b0\u1ee3c d\u00f9ng trong \u1ee9ng d\u1ee5ng n\u00e0o, c\u1eadp nh\u1eadt \u1ee9ng d\u1ee5ng sang user kh\u00e1c, sau \u0111\u00f3 m\u1edbi x\u00f3a. Kh\u00f4ng c\u00f3 b\u01b0\u1edbc &#8220;undo&#8221; sau khi x\u00f3a user.<\/p>\n<div class=\"highlight-cta-box\">\n<h3><span class=\"ez-toc-section\" id=\"Hosting-gia-re-%E2%80%94-co-san-cPanel-MySQL\"><\/span>Hosting gi\u00e1 r\u1ebb \u2014 c\u00f3 s\u1eb5n cPanel, MySQL<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>\u0110ang t\u00ecm hosting \u0111\u1ec3 ch\u1ea1y WordPress, WooCommerce hay \u1ee9ng d\u1ee5ng PHP? InterData cung c\u1ea5p hosting v\u1edbi cPanel \u0111\u1ea7y \u0111\u1ee7 t\u00ednh n\u0103ng, ph\u1ea7n c\u1ee9ng th\u1ebf h\u1ec7 m\u1edbi CPU AMD EPYC, SSD NVMe U.2 \u2014 t\u1ed1c \u0111\u1ed9 load th\u1ef1c s\u1ef1 kh\u00e1c bi\u1ec7t so v\u1edbi hosting c\u00f9ng gi\u00e1.<\/p>\n<ul>\n<li>CPU AMD EPYC + SSD NVMe U.2 \u2014 database query nhanh h\u01a1n r\u00f5 r\u1ec7t so v\u1edbi HDD\/SATA SSD c\u00f9ng ph\u00e2n kh\u00fac gi\u00e1<\/li>\n<li>B\u0103ng th\u00f4ng l\u1edbn, uptime cam k\u1ebft 99.9% \u2014 ph\u00f9 h\u1ee3p web b\u00e1n h\u00e0ng, landing page, blog doanh nghi\u1ec7p<\/li>\n<li>Gi\u00e1 ch\u1ec9 t\u1eeb 30.000\u0111\/th\u00e1ng \u2014 c\u1ea5u h\u00ecnh m\u1ea1nh, uy t\u00edn, h\u1ed7 tr\u1ee3 k\u1ef9 thu\u1eadt th\u1ef1c s\u1ef1 c\u00f3 ng\u01b0\u1eddi tr\u1ea3 l\u1eddi<\/li>\n<\/ul>\n<a href=\"https:\/\/interdata.vn\/thue-hosting\/\" class=\"button primary is-primary is-medium\"  >\n\t\t<span>Xem g\u00f3i Hosting ph\u00f9 h\u1ee3p<\/span>\n\t<\/a>\n\n<\/div>\n<p><!-- H2 #4 \u2014 C\u1ea5p quy\u1ec1n --><\/p>\n<h2 id=\"phan-quyen-database-cpanel\"><span class=\"ez-toc-section\" id=\"Cap-quyen-database-user-trong-cPanel\"><\/span>C\u1ea5p quy\u1ec1n database user trong cPanel<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>C\u1ea5p quy\u1ec1n database user trong cPanel l\u00e0 vi\u1ec7c b\u1ea1n cho ph\u00e9p m\u1ed9t user (t\u00e0i kho\u1ea3n) \u0111\u01b0\u1ee3c quy\u1ec1n truy c\u1eadp v\u00e0 thao t\u00e1c tr\u00ean database trong cPanel.<\/p>\n<p>B\u01b0\u1edbc c\u1ea5p quy\u1ec1n (assign user to database) l\u00e0 b\u01b0\u1edbc m\u00e0 nhi\u1ec1u ng\u01b0\u1eddi l\u00e0m xong wizard nh\u01b0ng kh\u00f4ng th\u1ef1c s\u1ef1 hi\u1ec3u \u0111\u00e3 l\u00e0m g\u00ec. Khi t\u00edch ch\u1ecdn &#8220;ALL PRIVILEGES&#8221;, b\u1ea1n \u0111ang c\u1ea5p cho user \u0111\u00f3 quy\u1ec1n th\u1ef1c hi\u1ec7n m\u1ecdi thao t\u00e1c tr\u00ean database \u2014 k\u1ec3 c\u1ea3 x\u00f3a to\u00e0n b\u1ed9 d\u1eef li\u1ec7u ho\u1eb7c drop table.<\/p>\n<h3><span class=\"ez-toc-section\" id=\"Cac-muc-quyen-MySQL-va-khi-nao-dung-tung-muc\"><\/span>C\u00e1c m\u1ee9c quy\u1ec1n MySQL v\u00e0 khi n\u00e0o d\u00f9ng t\u1eebng m\u1ee9c<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>cPanel hi\u1ec3n th\u1ecb danh s\u00e1ch quy\u1ec1n MySQL khi b\u1ea1n assign user v\u00e0o database. D\u01b0\u1edbi \u0111\u00e2y l\u00e0 c\u00e1c quy\u1ec1n ph\u1ed5 bi\u1ebfn v\u00e0 \u00fd ngh\u0129a th\u1ef1c t\u1ebf:<\/p>\n<ul>\n<li><strong>ALL PRIVILEGES<\/strong> \u2014 To\u00e0n quy\u1ec1n. D\u00f9ng cho \u1ee9ng d\u1ee5ng web ch\u00ednh (WordPress, WooCommerce, custom app) c\u1ea7n \u0111\u1ecdc, ghi, t\u1ea1o b\u1ea3ng, x\u00f3a b\u1ea3ng. \u0110\u00e2y l\u00e0 l\u1ef1a ch\u1ecdn ph\u1ed5 bi\u1ebfn nh\u1ea5t nh\u01b0ng c\u0169ng r\u1ee7i ro nh\u1ea5t n\u1ebfu th\u00f4ng tin k\u1ebft n\u1ed1i b\u1ecb l\u1ed9.<\/li>\n<li><strong>SELECT<\/strong> \u2014 Ch\u1ec9 \u0111\u1ecdc. Ph\u00f9 h\u1ee3p cho c\u00f4ng c\u1ee5 b\u00e1o c\u00e1o, dashboard analytics c\u1ea7n query d\u1eef li\u1ec7u nh\u01b0ng kh\u00f4ng \u0111\u01b0\u1ee3c ph\u00e9p ghi. N\u00ean d\u00f9ng lo\u1ea1i user n\u00e0y khi chia s\u1ebb quy\u1ec1n truy c\u1eadp database v\u1edbi b\u00ean th\u1ee9 ba.<\/li>\n<li><strong>INSERT, UPDATE, DELETE<\/strong> \u2014 Quy\u1ec1n ghi c\u00f3 ki\u1ec3m so\u00e1t. D\u00f9ng khi mu\u1ed1n \u1ee9ng d\u1ee5ng ch\u1ec9 \u0111\u01b0\u1ee3c th\u00eam\/s\u1eeda\/x\u00f3a h\u00e0ng (row) trong b\u1ea3ng \u0111\u00e3 t\u1ed3n t\u1ea1i, kh\u00f4ng \u0111\u01b0\u1ee3c t\u1ea1o ho\u1eb7c x\u00f3a b\u1ea3ng (table).<\/li>\n<li><strong>CREATE, DROP, ALTER<\/strong> \u2014 Quy\u1ec1n thay \u0111\u1ed5i c\u1ea5u tr\u00fac database. C\u1ea7n thi\u1ebft trong qu\u00e1 tr\u00ecnh c\u00e0i \u0111\u1eb7t v\u00e0 update \u1ee9ng d\u1ee5ng, nh\u01b0ng r\u1ee7i ro cao \u2014 DROP cho ph\u00e9p x\u00f3a to\u00e0n b\u1ed9 b\u1ea3ng kh\u00f4ng th\u1ec3 kh\u00f4i ph\u1ee5c.<\/li>\n<li><strong>INDEX<\/strong> \u2014 T\u1ea1o v\u00e0 x\u00f3a index. Th\u01b0\u1eddng \u0111i k\u00e8m CREATE\/ALTER khi \u1ee9ng d\u1ee5ng c\u1ea7n t\u1ed1i \u01b0u query.<\/li>\n<\/ul>\n<p>Nguy\u00ean t\u1eafc th\u1ef1c t\u1ebf: v\u1edbi \u1ee9ng d\u1ee5ng production \u0111\u00e3 \u1ed5n \u0111\u1ecbnh (kh\u00f4ng c\u00f2n update <a href=\"https:\/\/interdata.vn\/blog\/schema-la-gi\/\">schema<\/a> th\u01b0\u1eddng xuy\u00ean), xem x\u00e9t gi\u1ea3m quy\u1ec1n t\u1eeb ALL PRIVILEGES xu\u1ed1ng SELECT + INSERT + UPDATE + DELETE. \u0110i\u1ec1u n\u00e0y gi\u1edbi h\u1ea1n thi\u1ec7t h\u1ea1i n\u1ebfu \u1ee9ng d\u1ee5ng b\u1ecb t\u1ea5n c\u00f4ng SQL injection.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-40464\" src=\"https:\/\/interdata.vn\/blog\/wp-content\/uploads\/2026\/03\/Cap-quyen-database-user-trong-cPanel-.jpg\" alt=\"C\u1ea5p quy\u1ec1n database user trong cPanel\u00a0\" width=\"800\" height=\"500\" title=\"\" srcset=\"https:\/\/interdata.vn\/blog\/wp-content\/uploads\/2026\/03\/Cap-quyen-database-user-trong-cPanel-.jpg 800w, https:\/\/interdata.vn\/blog\/wp-content\/uploads\/2026\/03\/Cap-quyen-database-user-trong-cPanel--300x188.jpg 300w, https:\/\/interdata.vn\/blog\/wp-content\/uploads\/2026\/03\/Cap-quyen-database-user-trong-cPanel--768x480.jpg 768w\" sizes=\"auto, (max-width: 800px) 100vw, 800px\" \/><\/p>\n<h3><span class=\"ez-toc-section\" id=\"Thay-doi-quyen-sau-khi-da-cap\"><\/span>Thay \u0111\u1ed5i quy\u1ec1n sau khi \u0111\u00e3 c\u1ea5p<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>V\u00e0o <strong>MySQL Databases<\/strong> \u2192 ph\u1ea7n <em>Current Databases<\/em> \u2192 t\u00ecm database c\u1ea7n thay \u0111\u1ed5i \u2192 click v\u00e0o t\u00ean user trong c\u1ed9t &#8220;Privileged Users&#8221;. Trang Manage User Privileges xu\u1ea5t hi\u1ec7n \u2014 b\u1ecf ch\u1ecdn ho\u1eb7c th\u00eam quy\u1ec1n \u2192 <em>Make Changes<\/em>. Thay \u0111\u1ed5i c\u00f3 hi\u1ec7u l\u1ef1c ngay, kh\u00f4ng c\u1ea7n restart service.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-40461\" src=\"https:\/\/interdata.vn\/blog\/wp-content\/uploads\/2026\/03\/Thay-doi-quyen-sau-khi-da-cap.png\" alt=\"Thay \u0111\u1ed5i quy\u1ec1n sau khi \u0111\u00e3 c\u1ea5p\" width=\"695\" height=\"834\" title=\"\" srcset=\"https:\/\/interdata.vn\/blog\/wp-content\/uploads\/2026\/03\/Thay-doi-quyen-sau-khi-da-cap.png 695w, https:\/\/interdata.vn\/blog\/wp-content\/uploads\/2026\/03\/Thay-doi-quyen-sau-khi-da-cap-250x300.png 250w\" sizes=\"auto, (max-width: 695px) 100vw, 695px\" \/><\/p>\n<h3><span class=\"ez-toc-section\" id=\"Kiem-tra-user-dang-co-quyen-gi\"><\/span>Ki\u1ec3m tra user \u0111ang c\u00f3 quy\u1ec1n g\u00ec<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>cPanel kh\u00f4ng c\u00f3 m\u00e0n h\u00ecnh t\u1ed5ng h\u1ee3p &#8220;user X \u0111ang c\u00f3 quy\u1ec1n g\u00ec tr\u00ean database n\u00e0o&#8221; \u2014 b\u1ea1n ph\u1ea3i v\u00e0o t\u1eebng database \u0111\u1ec3 xem. C\u00e1ch nhanh h\u01a1n: \u0111\u0103ng nh\u1eadp phpMyAdmin b\u1eb1ng user \u0111\u00f3, ch\u1ea1y c\u00e2u l\u1ec7nh <code>SHOW GRANTS FOR CURRENT_USER();<\/code> \u2014 k\u1ebft qu\u1ea3 tr\u1ea3 v\u1ec1 to\u00e0n b\u1ed9 quy\u1ec1n c\u1ee7a user hi\u1ec7n t\u1ea1i tr\u00ean t\u1ea5t c\u1ea3 database.<\/p>\n<p><!-- H2 #5 \u2014 H\u01b0\u1edbng d\u1eabn phpMyAdmin --><\/p>\n<h2><span class=\"ez-toc-section\" id=\"Su-dung-phpMyAdmin-tren-cPanel-%E2%80%94-tu-co-ban-den-thao-tac-thuc-te\"><\/span>S\u1eed d\u1ee5ng phpMyAdmin tr\u00ean cPanel \u2014 t\u1eeb c\u01a1 b\u1ea3n \u0111\u1ebfn thao t\u00e1c th\u1ef1c t\u1ebf<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>C\u00f4ng c\u1ee5 ph\u1ed5 bi\u1ebfn nh\u1ea5t \u0111\u1ec3 thao t\u00e1c tr\u1ef1c ti\u1ebfp v\u1edbi d\u1eef li\u1ec7u ch\u00ednh l\u00e0 phpMyAdmin. B\u1ea1n c\u00f3 th\u1ec3 t\u00ecm hi\u1ec3u s\u00e2u h\u01a1n v\u1ec1 <a href=\"https:\/\/interdata.vn\/blog\/phpmyadmin-la-gi\/\"><strong>phpMyAdmin l\u00e0 g\u00ec v\u00e0 xem h\u01b0\u1edbng d\u1eabn chi ti\u1ebft v\u1ec1 c\u00e1ch d\u00f9ng<\/strong> <strong>phpMyAdmin cpanel<\/strong><\/a> \u0111\u1ec3 bi\u1ebft c\u00e1ch ch\u1ec9nh s\u1eeda c\u00e1c d\u00f2ng l\u1ec7nh m\u00e0 kh\u00f4ng c\u1ea7n ki\u1ebfn th\u1ee9c l\u1eadp tr\u00ecnh s\u00e2u.<\/p>\n<p>phpMyAdmin l\u00e0 giao di\u1ec7n web \u0111\u1ec3 qu\u1ea3n l\u00fd MySQL database m\u00e0 kh\u00f4ng c\u1ea7n d\u00f2ng l\u1ec7nh. H\u1ea7u h\u1ebft hosting provider t\u00edch h\u1ee3p s\u1eb5n phpMyAdmin v\u00e0o cPanel \u2014 b\u1ea1n truy c\u1eadp t\u1eeb m\u1ee5c Databases \u2192 phpMyAdmin, h\u1ec7 th\u1ed1ng t\u1ef1 \u0111\u0103ng nh\u1eadp b\u1eb1ng quy\u1ec1n t\u00e0i kho\u1ea3n cPanel c\u1ee7a b\u1ea1n.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-40465\" src=\"https:\/\/interdata.vn\/blog\/wp-content\/uploads\/2026\/03\/phpMyAdmin-tren-cPanel.jpg\" alt=\"phpMyAdmin tr\u00ean cPanel\" width=\"800\" height=\"500\" title=\"\" srcset=\"https:\/\/interdata.vn\/blog\/wp-content\/uploads\/2026\/03\/phpMyAdmin-tren-cPanel.jpg 800w, https:\/\/interdata.vn\/blog\/wp-content\/uploads\/2026\/03\/phpMyAdmin-tren-cPanel-300x188.jpg 300w, https:\/\/interdata.vn\/blog\/wp-content\/uploads\/2026\/03\/phpMyAdmin-tren-cPanel-768x480.jpg 768w\" sizes=\"auto, (max-width: 800px) 100vw, 800px\" \/><\/p>\n<h3><span class=\"ez-toc-section\" id=\"Giao-dien-phpMyAdmin-%E2%80%94-doc-hieu-trong-2-phut\"><\/span>Giao di\u1ec7n phpMyAdmin \u2014 \u0111\u1ecdc hi\u1ec3u trong 2 ph\u00fat<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>C\u1ed9t tr\u00e1i l\u00e0 danh s\u00e1ch database thu\u1ed9c t\u00e0i kho\u1ea3n cPanel c\u1ee7a b\u1ea1n. Click v\u00e0o t\u00ean database \u0111\u1ec3 xem danh s\u00e1ch b\u1ea3ng (tables) b\u00ean trong. Click v\u00e0o t\u00ean b\u1ea3ng \u0111\u1ec3 xem d\u1eef li\u1ec7u. Thanh menu tr\u00ean c\u00f9ng c\u00f3 c\u00e1c tab: Structure (c\u1ea5u tr\u00fac b\u1ea3ng), Browse (xem d\u1eef li\u1ec7u), SQL (ch\u1ea1y c\u00e2u l\u1ec7nh tr\u1ef1c ti\u1ebfp), Import, Export.<\/p>\n<p>\u0110i\u1ec3m quan tr\u1ecdng: phpMyAdmin trong cPanel ch\u1ea1y v\u1edbi quy\u1ec1n c\u1ee7a t\u00e0i kho\u1ea3n cPanel \u2014 t\u1ee9c l\u00e0 b\u1ea1n c\u00f3 th\u1ec3 thao t\u00e1c t\u1ea5t c\u1ea3 database trong t\u00e0i kho\u1ea3n. N\u1ebfu b\u1ea1n mu\u1ed1n test quy\u1ec1n c\u1ee7a m\u1ed9t database user c\u1ee5 th\u1ec3, c\u1ea7n \u0111\u0103ng nh\u1eadp phpMyAdmin b\u1eb1ng th\u00f4ng tin user \u0111\u00f3 thay v\u00ec qua cPanel.<\/p>\n<h3><span class=\"ez-toc-section\" id=\"Import-database-tu-file-SQL\"><\/span>Import database t\u1eeb file SQL<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>Import l\u00e0 t\u00e1c v\u1ee5 ph\u1ed5 bi\u1ebfn khi chuy\u1ec3n website t\u1eeb hosting c\u0169 ho\u1eb7c restore backup.<\/p>\n<ol>\n<li>Trong phpMyAdmin, click v\u00e0o t\u00ean database c\u1ea7n import d\u1eef li\u1ec7u v\u00e0o (c\u1ed9t tr\u00e1i).<\/li>\n<li>Click tab <strong>Import<\/strong> \u1edf menu tr\u00ean c\u00f9ng.<\/li>\n<li>Click <em>Choose File<\/em> \u2192 ch\u1ecdn file <code>.sql<\/code> ho\u1eb7c <code>.sql.gz<\/code> t\u1eeb m\u00e1y t\u00ednh.<\/li>\n<li>Ki\u1ec3m tra encoding \u2014 th\u01b0\u1eddng \u0111\u1ec3 m\u1eb7c \u0111\u1ecbnh UTF-8 l\u00e0 \u0111\u00fang. N\u1ebfu d\u1eef li\u1ec7u b\u1ecb l\u1ed7i ch\u1eef Vi\u1ec7t sau import, th\u1eed l\u1ea1i v\u1edbi encoding <em>utf8mb4<\/em>.<\/li>\n<li>Click <strong>Go<\/strong>. phpMyAdmin ch\u1ea1y file SQL v\u00e0 b\u00e1o k\u1ebft qu\u1ea3. File l\u1edbn (&gt;50MB) c\u00f3 th\u1ec3 timeout \u2014 xem ph\u1ea7n x\u1eed l\u00fd file l\u1edbn b\u00ean d\u01b0\u1edbi.<\/li>\n<\/ol>\n<p>L\u1ed7i ph\u1ed5 bi\u1ebfn khi import: <em>&#8220;Table &#8216;X&#8217; already exists&#8221;<\/em> \u2014 x\u1ea3y ra khi database \u0111\u00edch \u0111\u00e3 c\u00f3 d\u1eef li\u1ec7u c\u0169. Gi\u1ea3i ph\u00e1p: ch\u1ecdn <em>DROP TABLE \/ VIEW \/ PROCEDURE \/ EVENT \/ TRIGGER before import<\/em> trong t\u00f9y ch\u1ecdn Import, ho\u1eb7c x\u00f3a s\u1ea1ch database tr\u01b0\u1edbc khi import.<\/p>\n<h3><span class=\"ez-toc-section\" id=\"Export-database-%E2%80%94-backup-du-lieu-thu-cong\"><\/span>Export database \u2014 backup d\u1eef li\u1ec7u th\u1ee7 c\u00f4ng<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>Click t\u00ean database \u2192 tab <strong>Export<\/strong> \u2192 ch\u1ecdn format (SQL l\u00e0 ph\u1ed5 bi\u1ebfn nh\u1ea5t) \u2192 click <strong>Go<\/strong>. phpMyAdmin t\u1ea3i file <code>.sql<\/code> v\u1ec1 m\u00e1y b\u1ea1n. V\u1edbi database nh\u1ecf d\u01b0\u1edbi 50MB, c\u00e1ch n\u00e0y \u0111\u1ee7 nhanh. Database l\u1edbn h\u01a1n n\u00ean d\u00f9ng t\u00ednh n\u0103ng Backup trong cPanel ho\u1eb7c mysqldump qua SSH \u0111\u1ec3 tr\u00e1nh timeout.<\/p>\n<p>Quick export (m\u1eb7c \u0111\u1ecbnh) export to\u00e0n b\u1ed9 database. Custom export cho ph\u00e9p ch\u1ecdn t\u1eebng b\u1ea3ng c\u1ee5 th\u1ec3 \u2014 h\u1eefu \u00edch khi b\u1ea1n ch\u1ec9 c\u1ea7n backup m\u1ed9t ph\u1ea7n d\u1eef li\u1ec7u.<\/p>\n<h3><span class=\"ez-toc-section\" id=\"Chay-cau-lenh-SQL-truc-tiep\"><\/span>Ch\u1ea1y c\u00e2u l\u1ec7nh SQL tr\u1ef1c ti\u1ebfp<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>Tab SQL trong phpMyAdmin l\u00e0 n\u01a1i b\u1ea1n ch\u1ea1y b\u1ea5t k\u1ef3 c\u00e2u l\u1ec7nh MySQL n\u00e0o. M\u1ed9t s\u1ed1 c\u00e2u h\u1eefu \u00edch th\u01b0\u1eddng d\u00f9ng:<\/p>\n<ul>\n<li><code>SHOW TABLES;<\/code> \u2014 li\u1ec7t k\u00ea to\u00e0n b\u1ed9 b\u1ea3ng trong database \u0111ang ch\u1ecdn<\/li>\n<li><code>SELECT COUNT(*) FROM wp_posts;<\/code> \u2014 \u0111\u1ebfm s\u1ed1 b\u00e0i vi\u1ebft trong WordPress<\/li>\n<li><code>UPDATE wp_options SET option_value = 'https:\/\/domain-moi.com' WHERE option_name = 'siteurl';<\/code> \u2014 \u0111\u1ed5i domain WordPress sau khi <a href=\"https:\/\/interdata.vn\/blog\/cach-chuyen-du-lieu-tu-hosting\/\">chuy\u1ec3n hosting<\/a><\/li>\n<li><code>SHOW PROCESSLIST;<\/code> \u2014 xem c\u00e1c query \u0111ang ch\u1ea1y, h\u1eefu \u00edch khi site ch\u1eadm b\u1ea5t th\u01b0\u1eddng<\/li>\n<\/ul>\n<p>C\u00e2u l\u1ec7nh DELETE v\u00e0 DROP ch\u1ea1y kh\u00f4ng c\u00f3 x\u00e1c nh\u1eadn \u2014 m\u1ecdi th\u1ee9 th\u1ef1c hi\u1ec7n ngay l\u1eadp t\u1ee9c v\u00e0 kh\u00f4ng c\u00f3 undo. V\u1edbi d\u1eef li\u1ec7u quan tr\u1ecdng, export backup tr\u01b0\u1edbc khi ch\u1ea1y b\u1ea5t k\u1ef3 c\u00e2u l\u1ec7nh thay \u0111\u1ed5i d\u1eef li\u1ec7u n\u00e0o.<\/p>\n<p><!-- CTA BOX #2 \u2014 Sau ph\u1ea7n How-to phpMyAdmin --><\/p>\n<div style=\"border-left: 4px solid #0284c7; background: #f0f7ff; border-radius: 0 8px 8px 0; padding: 20px 24px; margin: 40px 0; max-width: 100%;\">\n<div style=\"display: flex; align-items: center; margin-bottom: 12px;\"><span style=\"font-size: 22px; margin-right: 10px;\">\ud83d\udda5\ufe0f<\/span><br \/>\n<strong style=\"color: #0369a1; font-size: 17px;\">C\u1ea7n to\u00e0n quy\u1ec1n MySQL? VPS l\u00e0 l\u1ef1a ch\u1ecdn \u0111\u00fang \u2014 InterData<\/strong><\/div>\n<p style=\"color: #333; font-size: 14px; margin: 0 0 16px 0; line-height: 1.6;\">Shared hosting gi\u1edbi h\u1ea1n MySQL theo dung l\u01b0\u1ee3ng v\u00e0 quy\u1ec1n root. V\u1edbi <a href=\"https:\/\/interdata.vn\/blog\/vps-la-gi\/\">VPS<\/a> InterData, b\u1ea1n c\u00e0i MySQL\/MariaDB phi\u00ean b\u1ea3n t\u00f9y ch\u1ecdn, c\u1ea5u h\u00ecnh my.cnf theo workload, kh\u00f4ng b\u1ecb gi\u1edbi h\u1ea1n s\u1ed1 database hay connection pool.<\/p>\n<p style=\"color: #555; font-size: 13px; margin: 0 0 18px 0;\"><strong style=\"color: #0284c7;\">\u2713<\/strong> NVMe U.2 \u2014 I\/O database nhanh h\u01a1n SATA SSD 5\u20137 l\u1ea7n<br \/>\n<strong style=\"color: #0284c7;\">\u2713<\/strong> K\u00edch ho\u1ea1t t\u1ef1 \u0111\u1ed9ng, to\u00e0n quy\u1ec1n root<br \/>\n<strong style=\"color: #0284c7;\">\u2713<\/strong> H\u1ed7 tr\u1ee3 cPanel, <a href=\"https:\/\/interdata.vn\/blog\/directadmin-la-gi\/\">DirectAdmin<\/a>, Plesk<\/p>\n<p><a style=\"display: inline-block; background: #0284c7; color: #fff; font-size: 14px; font-weight: 600; text-decoration: none; padding: 10px 22px; border-radius: 6px;\" href=\"https:\/\/interdata.vn\/thue-vps\/\">Xem g\u00f3i VPS InterData \u2192<\/a><\/p>\n<\/div>\n<p><!-- H2 #6 \u2014 K\u1ebft n\u1ed1i \u1ee9ng d\u1ee5ng --><\/p>\n<h2><span class=\"ez-toc-section\" id=\"Ket-noi-ung-dung-web-voi-MySQL-database-tren-cPanel\"><\/span>K\u1ebft n\u1ed1i \u1ee9ng d\u1ee5ng web v\u1edbi MySQL database tr\u00ean cPanel<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>Sau khi t\u1ea1o xong database, user, v\u00e0 c\u1ea5p quy\u1ec1n \u2014 b\u01b0\u1edbc ti\u1ebfp theo l\u00e0 \u0111i\u1ec1n th\u00f4ng tin k\u1ebft n\u1ed1i v\u00e0o \u1ee9ng d\u1ee5ng. \u0110\u00e2y l\u00e0 \u0111i\u1ec3m d\u1ec5 nh\u1ea7m nh\u1ea5t v\u00ec ng\u01b0\u1eddi m\u1edbi hay \u0111i\u1ec1n sai th\u00f4ng tin ho\u1eb7c d\u00f9ng nh\u1ea7m username.<\/p>\n<h3><span class=\"ez-toc-section\" id=\"4-thong-tin-ket-noi-bat-buoc\"><\/span>4 th\u00f4ng tin k\u1ebft n\u1ed1i b\u1eaft bu\u1ed9c<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<table>\n<thead>\n<tr>\n<th>Th\u00f4ng tin<\/th>\n<th>Gi\u00e1 tr\u1ecb \u0111i\u1ec1n v\u00e0o<\/th>\n<th>L\u01b0u \u00fd<\/th>\n<\/tr>\n<\/thead>\n<tbody>\n<tr>\n<td>Database Host<\/td>\n<td><code>localhost<\/code><\/td>\n<td>G\u1ea7n nh\u01b0 lu\u00f4n l\u00e0 localhost tr\u00ean shared hosting<\/td>\n<\/tr>\n<tr>\n<td>Database Name<\/td>\n<td><code>cpanelusername_t\u00eandb<\/code><\/td>\n<td>T\u00ean \u0111\u1ea7y \u0111\u1ee7 g\u1ed3m c\u1ea3 ti\u1ec1n t\u1ed1, kh\u00f4ng ph\u1ea3i t\u00ean b\u1ea1n nh\u1eadp khi t\u1ea1o<\/td>\n<\/tr>\n<tr>\n<td>Database Username<\/td>\n<td><code>cpanelusername_t\u00eanuser<\/code><\/td>\n<td>Kh\u00f4ng ph\u1ea3i username \u0111\u0103ng nh\u1eadp cPanel<\/td>\n<\/tr>\n<tr>\n<td>Database Password<\/td>\n<td>Password c\u1ee7a database user<\/td>\n<td>Kh\u00f4ng ph\u1ea3i password \u0111\u0103ng nh\u1eadp cPanel<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<p>\u0110i\u1ec3m hay b\u1ecb nh\u1ea7m nh\u1ea5t: d\u00f9ng username v\u00e0 password c\u1ee7a cPanel thay v\u00ec c\u1ee7a database user. \u0110\u00e2y l\u00e0 hai h\u1ec7 th\u1ed1ng x\u00e1c th\u1ef1c ho\u00e0n to\u00e0n t\u00e1ch bi\u1ec7t. cPanel username d\u00f9ng \u0111\u1ec3 \u0111\u0103ng nh\u1eadp cPanel; database user d\u00f9ng \u0111\u1ec3 \u1ee9ng d\u1ee5ng k\u1ebft n\u1ed1i MySQL.<\/p>\n<h3><span class=\"ez-toc-section\" id=\"Dien-thong-tin-vao-WordPress\"><\/span>\u0110i\u1ec1n th\u00f4ng tin v\u00e0o WordPress<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>Khi c\u00e0i WordPress m\u1edbi, tr\u00ecnh c\u00e0i \u0111\u1eb7t s\u1ebd h\u1ecfi th\u00f4ng tin database. \u0110i\u1ec1n theo b\u1ea3ng tr\u00ean. Sau khi c\u00e0i xong, th\u00f4ng tin n\u00e0y \u0111\u01b0\u1ee3c l\u01b0u trong file <code>wp-config.php<\/code> \u1edf th\u01b0 m\u1ee5c g\u1ed1c website. N\u1ebfu c\u1ea7n s\u1eeda (v\u00ed d\u1ee5 \u0111\u1ed5i database sau khi chuy\u1ec3n hosting), m\u1edf file n\u00e0y v\u00e0 t\u00ecm c\u00e1c d\u00f2ng:<\/p>\n<pre><code>define('DB_NAME', 'cpanelusername_t\u00eandb');\r\ndefine('DB_USER', 'cpanelusername_t\u00eanuser');\r\ndefine('DB_PASSWORD', 'passwordc\u1ee7auser');\r\ndefine('DB_HOST', 'localhost');<\/code><\/pre>\n<h3><span class=\"ez-toc-section\" id=\"Ket-noi-tu-xa-Remote-MySQL\"><\/span>K\u1ebft n\u1ed1i t\u1eeb xa (Remote MySQL)<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>M\u1eb7c \u0111\u1ecbnh, MySQL tr\u00ean shared hosting ch\u1ec9 cho ph\u00e9p k\u1ebft n\u1ed1i t\u1eeb <code>localhost<\/code> \u2014 t\u1ee9c l\u00e0 t\u1eeb c\u00f9ng server. N\u1ebfu b\u1ea1n c\u1ea7n k\u1ebft n\u1ed1i t\u1eeb m\u00e1y t\u00ednh c\u00e1 nh\u00e2n (d\u00f9ng MySQL Workbench, DBeaver) ho\u1eb7c t\u1eeb server kh\u00e1c, ph\u1ea3i v\u00e0o cPanel \u2192 <strong>Remote MySQL<\/strong> \u2192 th\u00eam \u0111\u1ecba ch\u1ec9 IP \u0111\u01b0\u1ee3c ph\u00e9p k\u1ebft n\u1ed1i.<\/p>\n<p>Th\u00eam IP <code>%<\/code> (wildcard) cho ph\u00e9p k\u1ebft n\u1ed1i t\u1eeb m\u1ecdi IP \u2014 ti\u1ec7n nh\u01b0ng r\u1ee7i ro b\u1ea3o m\u1eadt. V\u1edbi shared hosting, nhi\u1ec1u provider ch\u1eb7n ho\u00e0n to\u00e0n t\u00ednh n\u0103ng Remote MySQL ho\u1eb7c gi\u1edbi h\u1ea1n port 3306 \u1edf t\u1ea7ng firewall. Khi c\u1ea7n remote access database th\u01b0\u1eddng xuy\u00ean, VPS cho ph\u00e9p c\u1ea5u h\u00ecnh firewall linh ho\u1ea1t h\u01a1n.<\/p>\n<p>N\u1ebfu b\u1ea1n c\u00f3 nhu c\u1ea7u qu\u1ea3n l\u00fd d\u1eef li\u1ec7u t\u1eeb m\u00e1y t\u00ednh c\u00e1 nh\u00e2n ho\u1eb7c k\u1ebft n\u1ed1i \u1ee9ng d\u1ee5ng t\u1eeb server kh\u00e1c, h\u00e3y tham kh\u1ea3o <strong><a href=\"https:\/\/interdata.vn\/blog\/add-ip-remote-mysql-tren-hosting-cpanel\/\">t\u00ednh n\u0103ng remote mysql cpanel<\/a><\/strong> \u0111\u1ec3 m\u1edf c\u1ed5ng truy c\u1eadp an to\u00e0n.<\/p>\n<p><!-- H2 #7 \u2014 L\u1ed7i th\u01b0\u1eddng g\u1eb7p --><\/p>\n<h2><span class=\"ez-toc-section\" id=\"Loi-thuong-gap-khi-quan-ly-database-tren-cPanel-va-cach-xu-ly\"><\/span>L\u1ed7i th\u01b0\u1eddng g\u1eb7p khi qu\u1ea3n l\u00fd database tr\u00ean cPanel v\u00e0 c\u00e1ch x\u1eed l\u00fd<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>Ph\u1ea7n n\u00e0y t\u1ed5ng h\u1ee3p c\u00e1c l\u1ed7i ph\u1ed5 bi\u1ebfn nh\u1ea5t \u2014 kh\u00f4ng ph\u1ea3i l\u00fd thuy\u1ebft, m\u00e0 l\u00e0 nh\u1eefng l\u1ed7i th\u1ef1c t\u1ebf ng\u01b0\u1eddi d\u00f9ng g\u1eb7p v\u00e0 c\u00e1ch gi\u1ea3i quy\u1ebft th\u1ef1c s\u1ef1 hi\u1ec7u qu\u1ea3.<\/p>\n<h3><span class=\"ez-toc-section\" id=\"%E2%80%9CAccess-denied-for-user%E2%80%9D-%E2%80%94-nguyen-nhan-va-cach-sua\"><\/span>&#8220;Access denied for user&#8221; \u2014 nguy\u00ean nh\u00e2n v\u00e0 c\u00e1ch s\u1eeda<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>L\u1ed7i n\u00e0y c\u00f3 4 nguy\u00ean nh\u00e2n ph\u1ed5 bi\u1ebfn, theo th\u1ee9 t\u1ef1 x\u00e1c su\u1ea5t t\u1eeb cao xu\u1ed1ng th\u1ea5p:<\/p>\n<ul>\n<li><strong>Qu\u00ean b\u01b0\u1edbc c\u1ea5p quy\u1ec1n (assign user to database)<\/strong> \u2014 \u0110\u00e2y l\u00e0 nguy\u00ean nh\u00e2n #1. T\u1ea1o database v\u00e0 user kh\u00f4ng t\u1ef1 \u0111\u1ed9ng k\u1ebft n\u1ed1i ch\u00fang. V\u00e0o MySQL Databases \u2192 Add User to Database \u0111\u1ec3 th\u1ef1c hi\u1ec7n b\u01b0\u1edbc n\u00e0y.<\/li>\n<li><strong>Nh\u1eadp sai t\u00ean user ho\u1eb7c database trong config<\/strong> \u2014 Ki\u1ec3m tra l\u1ea1i t\u00ean \u0111\u1ea7y \u0111\u1ee7 (g\u1ed3m c\u1ea3 ti\u1ec1n t\u1ed1 cPanel username). Copy ch\u00ednh x\u00e1c t\u1eeb cPanel thay v\u00ec g\u00f5 tay.<\/li>\n<li><strong>Password database user b\u1ecb thay \u0111\u1ed5i<\/strong> \u2014 Ai \u0111\u00f3 \u0111\u1ed5i password user nh\u01b0ng ch\u01b0a c\u1eadp nh\u1eadt file config \u1ee9ng d\u1ee5ng. \u0110\u1ed5i l\u1ea1i password v\u1ec1 c\u00e1i c\u0169 ho\u1eb7c c\u1eadp nh\u1eadt config.<\/li>\n<li><strong>K\u1ebft n\u1ed1i Remote MySQL t\u1eeb IP ch\u01b0a \u0111\u01b0\u1ee3c whitelist<\/strong> \u2014 Th\u00eam IP v\u00e0o Remote MySQL trong cPanel, ho\u1eb7c \u0111\u1ed5i DB_HOST th\u00e0nh <code>localhost<\/code> n\u1ebfu \u1ee9ng d\u1ee5ng ch\u1ea1y tr\u00ean c\u00f9ng server.<\/li>\n<\/ul>\n<h3><span class=\"ez-toc-section\" id=\"phpMyAdmin-bao-%E2%80%9CNo-database-selected%E2%80%9D\"><\/span>phpMyAdmin b\u00e1o &#8220;No database selected&#8221;<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>X\u1ea3y ra khi b\u1ea1n v\u00e0o tab SQL ho\u1eb7c Import m\u00e0 ch\u01b0a click ch\u1ecdn database \u1edf c\u1ed9t tr\u00e1i. Click v\u00e0o t\u00ean database tr\u01b0\u1edbc, sau \u0111\u00f3 m\u1edbi th\u1ef1c hi\u1ec7n thao t\u00e1c. N\u1ebfu database kh\u00f4ng xu\u1ea5t hi\u1ec7n trong danh s\u00e1ch, c\u00f3 th\u1ec3 database ch\u01b0a \u0111\u01b0\u1ee3c t\u1ea1o ho\u1eb7c t\u00e0i kho\u1ea3n cPanel kh\u00f4ng c\u00f3 quy\u1ec1n xem database \u0111\u00f3.<\/p>\n<h3><span class=\"ez-toc-section\" id=\"Import-file-SQL-bi-loi-timeout\"><\/span>Import file SQL b\u1ecb l\u1ed7i timeout<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>phpMyAdmin c\u00f3 gi\u1edbi h\u1ea1n th\u1eddi gian th\u1ef1c thi v\u00e0 k\u00edch th\u01b0\u1edbc file upload (th\u01b0\u1eddng 50\u2013100MB t\u00f9y server config). V\u1edbi file l\u1edbn h\u01a1n, c\u00f3 3 c\u00e1ch x\u1eed l\u00fd:<\/p>\n<ul>\n<li>N\u00e9n file SQL th\u00e0nh <code>.sql.gz<\/code> \u2014 phpMyAdmin h\u1ed7 tr\u1ee3 import file n\u00e9n, gi\u1ea3m \u0111\u01b0\u1ee3c 60\u201380% k\u00edch th\u01b0\u1edbc<\/li>\n<li>D\u00f9ng BigDump (script PHP chuy\u00ean x\u1eed l\u00fd file SQL l\u1edbn) \u2014 upload script l\u00ean hosting, ch\u1ea1y qua tr\u00ecnh duy\u1ec7t<\/li>\n<li>N\u1ebfu c\u00f3 SSH access: d\u00f9ng l\u1ec7nh <code>mysql -u username -p database_name &lt; backup.sql<\/code> \u2014 kh\u00f4ng b\u1ecb gi\u1edbi h\u1ea1n th\u1eddi gian<\/li>\n<\/ul>\n<h3><span class=\"ez-toc-section\" id=\"Khong-tim-thay-MySQL-Databases-trong-cPanel\"><\/span>Kh\u00f4ng t\u00ecm th\u1ea5y MySQL Databases trong cPanel<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>M\u1ed9t s\u1ed1 hosting provider \u1ea9n ho\u1eb7c \u0111\u1ed5i t\u00ean m\u1ee5c n\u00e0y. T\u00ecm trong ph\u1ea7n <em>Databases<\/em> c\u1ee7a cPanel dashboard. N\u1ebfu v\u1eabn kh\u00f4ng th\u1ea5y, t\u00e0i kho\u1ea3n hosting c\u1ee7a b\u1ea1n c\u00f3 th\u1ec3 kh\u00f4ng bao g\u1ed3m MySQL \u2014 li\u00ean h\u1ec7 nh\u00e0 cung c\u1ea5p \u0111\u1ec3 x\u00e1c nh\u1eadn g\u00f3i d\u1ecbch v\u1ee5. H\u01b0\u1edbng d\u1eabn <strong><a href=\"https:\/\/interdata.vn\/blog\/cpanel\/\">t\u1ed5ng quan v\u1ec1 cPanel v\u00e0 c\u00e1c t\u00ednh n\u0103ng qu\u1ea3n tr\u1ecb hosting<\/a><\/strong> c\u00f3 th\u1ec3 gi\u00fap b\u1ea1n \u0111\u1ecbnh h\u01b0\u1edbng giao di\u1ec7n nhanh h\u01a1n.<\/p>\n<p><!-- CTA BOX #3 \u2014 Tr\u01b0\u1edbc FAQ, nh\u1ea5n v\u00e0o chuy\u1ec3n \u0111\u1ed5i --><\/p>\n<div style=\"background: linear-gradient(135deg, #0284c7 0%, #075985 100%); border-radius: 12px; padding: 28px 32px; margin: 40px 0; max-width: 100%; box-shadow: 0 4px 20px rgba(2,132,199,0.3);\">\n<div style=\"display: inline-block; background: rgba(255,255,255,0.18); border-radius: 20px; padding: 4px 14px; margin-bottom: 14px;\"><span style=\"color: #fff; font-size: 12px; font-weight: bold; text-transform: uppercase; letter-spacing: 0.5px;\">\u0110ang ch\u1ea1y \u1ee9ng d\u1ee5ng PHP\/MySQL?<\/span><\/div>\n<h3 style=\"color: #ffffff; font-size: 21px; font-weight: bold; margin: 0 0 10px 0;\"><span class=\"ez-toc-section\" id=\"VPS-InterData-%E2%80%94-toan-quyen-MySQL-NVMe-U2-gia-tu-hop-ly\"><\/span>VPS InterData \u2014 to\u00e0n quy\u1ec1n MySQL, NVMe U.2, gi\u00e1 t\u1eeb h\u1ee3p l\u00fd<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p style=\"color: rgba(255,255,255,0.9); font-size: 14px; margin: 0 0 20px 0; line-height: 1.6;\">Shared hosting \u0111\u1ee7 cho web nh\u1ecf. Khi database v\u01b0\u1ee3t 500MB, l\u01b0\u1ee3t truy c\u1eadp t\u0103ng, ho\u1eb7c c\u1ea7n c\u00e0i th\u00eam Redis\/Memcached \u0111\u1ec3 cache \u2014 \u0111\u00f3 l\u00e0 l\u00fac VPS ph\u00e1t huy t\u00e1c d\u1ee5ng th\u1ef1c s\u1ef1. InterData cung c\u1ea5p VPS v\u1edbi h\u1ea1 t\u1ea7ng m\u00e1y ch\u1ee7 \u0111\u1eddi m\u1edbi, k\u00edch ho\u1ea1t t\u1ef1 \u0111\u1ed9ng, h\u1ed7 tr\u1ee3 \u0111\u1ea7y \u0111\u1ee7 Control Panel.<\/p>\n<ul style=\"list-style: none; padding: 0; margin: 0 0 22px 0;\">\n<li style=\"color: #fff; font-size: 14px; padding: 4px 0;\">\u26a1 NVMe U.2 \u2014 t\u1ed1c \u0111\u1ed9 I\/O v\u01b0\u1ee3t tr\u1ed9i, database query nhanh h\u01a1n r\u00f5 r\u00e0ng<\/li>\n<li style=\"color: #fff; font-size: 14px; padding: 4px 0;\">\u26a1 H\u1ed7 tr\u1ee3 cPanel, DirectAdmin, Plesk \u2014 ho\u1eb7c c\u00e0i tay theo \u00fd mu\u1ed1n<\/li>\n<li style=\"color: #fff; font-size: 14px; padding: 4px 0;\">\u26a1 Backup th\u01b0\u1eddng xuy\u00ean, \u0111\u01b0\u1eddng truy\u1ec1n t\u1ed1c \u0111\u1ed9 cao, k\u00edch ho\u1ea1t t\u1ef1 \u0111\u1ed9ng trong v\u00e0i ph\u00fat<\/li>\n<\/ul>\n<div style=\"display: flex; flex-wrap: wrap; gap: 12px;\">\n<p><a style=\"display: inline-block; background: #ffffff; color: #075985; font-size: 14px; font-weight: bold; text-decoration: none; padding: 11px 24px; border-radius: 8px;\" href=\"https:\/\/interdata.vn\/vps-amd\/\">Xem g\u00f3i VPS AMD t\u1ed1c \u0111\u1ed9 cao\u2192<\/a><\/p>\n<\/div>\n<\/div>\n<p><!-- FAQ Block --><\/p>\n<p><span class=\"ng-star-inserted\">Qu\u1ea3n tr\u1ecb d\u1eef li\u1ec7u lu\u00f4n \u0111i \u0111\u00f4i v\u1edbi an to\u00e0n th\u00f4ng tin. Tr\u01b0\u1edbc khi th\u1ef1c hi\u1ec7n b\u1ea5t k\u1ef3 thay \u0111\u1ed5i l\u1edbn n\u00e0o trong database, h\u00e3y ch\u1eafc ch\u1eafn b\u1ea1n \u0111\u00e3 n\u1eafm v\u1eefng <\/span><a href=\"https:\/\/interdata.vn\/blog\/cach-backup-du-lieu-hosting-cpanel\/\"><strong class=\"ng-star-inserted\"><span class=\"ng-star-inserted\">c\u00e1ch backup d\u1eef li\u1ec7u Hosting cPanel<\/span><\/strong><\/a><span class=\"ng-star-inserted\">\u00a0\u0111\u1ec3 tr\u00e1nh r\u1ee7i ro m\u1ea5t m\u00e1t d\u1eef li\u1ec7u.<\/span><\/p>\n<h2><span class=\"ez-toc-section\" id=\"Cau-hoi-thuong-gap-ve-quan-ly-database-tren-cPanel\"><\/span>C\u00e2u h\u1ecfi th\u01b0\u1eddng g\u1eb7p v\u1ec1 qu\u1ea3n l\u00fd database tr\u00ean cPanel<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<h3><span class=\"ez-toc-section\" id=\"Database-tren-cPanel-la-gi\"><\/span>Database tr\u00ean cPanel l\u00e0 g\u00ec?<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>Database tr\u00ean cPanel l\u00e0 c\u01a1 s\u1edf d\u1eef li\u1ec7u MySQL (ho\u1eb7c MariaDB) \u0111\u01b0\u1ee3c l\u01b0u tr\u00ean server hosting, qu\u1ea3n l\u00fd qua giao di\u1ec7n web cPanel. M\u1ed7i database ch\u1ee9a c\u00e1c b\u1ea3ng (tables) d\u00f9ng \u0111\u1ec3 l\u01b0u tr\u1eef d\u1eef li\u1ec7u c\u1ee7a \u1ee9ng d\u1ee5ng \u2014 nh\u01b0 b\u00e0i vi\u1ebft WordPress, \u0111\u01a1n h\u00e0ng WooCommerce, hay t\u00e0i kho\u1ea3n ng\u01b0\u1eddi d\u00f9ng. cPanel cung c\u1ea5p giao di\u1ec7n \u0111\u1ec3 t\u1ea1o, x\u00f3a, qu\u1ea3n l\u00fd database m\u00e0 kh\u00f4ng c\u1ea7n bi\u1ebft d\u00f2ng l\u1ec7nh MySQL.<\/p>\n<h3><span class=\"ez-toc-section\" id=\"Tai-sao-tao-database-xong-roi-ma-ung-dung-van-bao-loi-ket-noi\"><\/span>T\u1ea1i sao t\u1ea1o database xong r\u1ed3i m\u00e0 \u1ee9ng d\u1ee5ng v\u1eabn b\u00e1o l\u1ed7i k\u1ebft n\u1ed1i?<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>Nguy\u00ean nh\u00e2n ph\u1ed5 bi\u1ebfn nh\u1ea5t: b\u1ea1n \u0111\u00e3 t\u1ea1o database v\u00e0 user nh\u01b0ng ch\u01b0a th\u1ef1c hi\u1ec7n b\u01b0\u1edbc assign user v\u00e0o database. Trong cPanel, database v\u00e0 user l\u00e0 hai th\u1ee9 ho\u00e0n to\u00e0n t\u00e1ch bi\u1ec7t \u2014 t\u1ea1o xong c\u1ea3 hai ch\u01b0a \u0111\u1ee7, ph\u1ea3i v\u00e0o ph\u1ea7n &#8220;Add User to Database&#8221; \u0111\u1ec3 c\u1ea5p quy\u1ec1n. Sau khi c\u1ea5p quy\u1ec1n, ki\u1ec3m tra l\u1ea1i th\u00f4ng tin k\u1ebft n\u1ed1i trong file config c\u1ee7a \u1ee9ng d\u1ee5ng \u2014 t\u00ean database v\u00e0 user ph\u1ea3i bao g\u1ed3m ti\u1ec1n t\u1ed1 cPanel username.<\/p>\n<h3><span class=\"ez-toc-section\" id=\"Ten-database-va-user-toi-nhap-trong-cPanel-co-khac-voi-ten-thuc-te-khong\"><\/span>T\u00ean database v\u00e0 user t\u00f4i nh\u1eadp trong cPanel c\u00f3 kh\u00e1c v\u1edbi t\u00ean th\u1ef1c t\u1ebf kh\u00f4ng?<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>C\u00f3. cPanel t\u1ef1 \u0111\u1ed9ng g\u1eafn ti\u1ec1n t\u1ed1 l\u00e0 username cPanel v\u00e0o t\u00ean b\u1ea1n nh\u1eadp. V\u00ed d\u1ee5: cPanel username l\u00e0 <code>mysite<\/code>, b\u1ea1n t\u1ea1o database t\u00ean <code>shop<\/code> \u2192 t\u00ean th\u1ef1c t\u1ebf trong MySQL l\u00e0 <code>mysite_shop<\/code>. T\u01b0\u01a1ng t\u1ef1 v\u1edbi user: nh\u1eadp <code>shopuser<\/code> \u2192 th\u1ef1c t\u1ebf l\u00e0 <code>mysite_shopuser<\/code>. T\u00ean \u0111\u1ea7y \u0111\u1ee7 n\u00e0y m\u1edbi l\u00e0 th\u1ee9 b\u1ea1n \u0111i\u1ec1n v\u00e0o file config \u1ee9ng d\u1ee5ng.<\/p>\n<h3><span class=\"ez-toc-section\" id=\"phpMyAdmin-trong-cPanel-dung-de-lam-gi\"><\/span>phpMyAdmin trong cPanel d\u00f9ng \u0111\u1ec3 l\u00e0m g\u00ec?<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>phpMyAdmin l\u00e0 giao di\u1ec7n \u0111\u1ed3 h\u1ecda \u0111\u1ec3 thao t\u00e1c tr\u1ef1c ti\u1ebfp v\u1edbi d\u1eef li\u1ec7u trong MySQL database \u2014 kh\u00f4ng c\u1ea7n bi\u1ebft d\u00f2ng l\u1ec7nh. C\u00e1c t\u00e1c v\u1ee5 ph\u1ed5 bi\u1ebfn: xem v\u00e0 ch\u1ec9nh s\u1eeda d\u1eef li\u1ec7u trong b\u1ea3ng, import file SQL (th\u01b0\u1eddng d\u00f9ng khi chuy\u1ec3n hosting), export database \u0111\u1ec3 backup, ch\u1ea1y c\u00e2u l\u1ec7nh SQL nh\u01b0 UPDATE \u0111\u1ec3 s\u1eeda URL sau khi \u0111\u1ed5i domain WordPress, ho\u1eb7c xem c\u1ea5u tr\u00fac b\u1ea3ng \u0111\u1ec3 debug.<\/p>\n<h3><span class=\"ez-toc-section\" id=\"Xoa-database-user-co-xoa-du-lieu-trong-database-khong\"><\/span>X\u00f3a database user c\u00f3 x\u00f3a d\u1eef li\u1ec7u trong database kh\u00f4ng?<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>Kh\u00f4ng. X\u00f3a database user ch\u1ec9 x\u00f3a t\u00e0i kho\u1ea3n x\u00e1c th\u1ef1c \u2014 d\u1eef li\u1ec7u b\u00ean trong database v\u1eabn nguy\u00ean v\u1eb9n. Nh\u01b0ng \u1ee9ng d\u1ee5ng \u0111ang d\u00f9ng user \u0111\u00f3 s\u1ebd m\u1ea5t k\u1ebft n\u1ed1i ngay l\u1eadp t\u1ee9c, d\u1eabn \u0111\u1ebfn l\u1ed7i tr\u00ean website. Ng\u01b0\u1ee3c l\u1ea1i, x\u00f3a database th\u00ec m\u1ea5t to\u00e0n b\u1ed9 d\u1eef li\u1ec7u trong \u0111\u00f3 v\u0129nh vi\u1ec5n (n\u1ebfu kh\u00f4ng c\u00f3 backup) \u2014 thao t\u00e1c n\u00e0y cPanel kh\u00f4ng c\u00f3 b\u01b0\u1edbc x\u00e1c nh\u1eadn th\u00eam n\u00ean c\u1ea7n c\u1ea9n th\u1eadn.<\/p>\n<h3><span class=\"ez-toc-section\" id=\"Co-the-dung-mot-database-user-cho-nhieu-database-khong\"><\/span>C\u00f3 th\u1ec3 d\u00f9ng m\u1ed9t database user cho nhi\u1ec1u database kh\u00f4ng?<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>\u0110\u01b0\u1ee3c. M\u1ed9t database user c\u00f3 th\u1ec3 \u0111\u01b0\u1ee3c assign v\u00e0o nhi\u1ec1u database kh\u00e1c nhau, v\u1edbi m\u1ee9c quy\u1ec1n kh\u00e1c nhau cho t\u1eebng database. V\u00e0o MySQL Databases \u2192 Add User to Database, ch\u1ecdn user \u0111\u00e3 c\u00f3 v\u00e0 database mu\u1ed1n assign th\u00eam. Tuy nhi\u00ean, v\u1ec1 m\u1eb7t b\u1ea3o m\u1eadt, n\u00ean t\u1ea1o user ri\u00eang cho m\u1ed7i \u1ee9ng d\u1ee5ng thay v\u00ec d\u00f9ng chung m\u1ed9t user \u2014 n\u1ebfu m\u1ed9t \u1ee9ng d\u1ee5ng b\u1ecb compromise, user ri\u00eang gi\u00fap gi\u1edbi h\u1ea1n ph\u1ea1m vi thi\u1ec7t h\u1ea1i.<\/p>\n<h3><span class=\"ez-toc-section\" id=\"Import-file-SQL-lon-vao-phpMyAdmin-bi-loi-timeout-phai-lam-gi\"><\/span>Import file SQL l\u1edbn v\u00e0o phpMyAdmin b\u1ecb l\u1ed7i timeout ph\u1ea3i l\u00e0m g\u00ec?<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>C\u00f3 3 c\u00e1ch x\u1eed l\u00fd t\u00f9y \u0111i\u1ec1u ki\u1ec7n: (1) N\u00e9n file SQL th\u00e0nh <code>.gz<\/code> r\u1ed3i import \u2014 phpMyAdmin h\u1ed7 tr\u1ee3 import file n\u00e9n, gi\u1ea3m \u0111\u01b0\u1ee3c 60\u201380% k\u00edch th\u01b0\u1edbc v\u00e0 th\u1eddi gian upload. (2) D\u00f9ng script BigDump \u2014 upload l\u00ean hosting, ch\u1ea1y qua tr\u00ecnh duy\u1ec7t, t\u1ef1 \u0111\u1ed9ng chia nh\u1ecf file SQL l\u1edbn th\u00e0nh nhi\u1ec1u l\u1ea7n th\u1ef1c thi. (3) N\u1ebfu c\u00f3 SSH: ch\u1ea1y l\u1ec7nh <code>mysql -u dbuser -p dbname &lt; file.sql<\/code> tr\u1ef1c ti\u1ebfp \u2014 kh\u00f4ng b\u1ecb gi\u1edbi h\u1ea1n timeout.<\/p>\n<h3><span class=\"ez-toc-section\" id=\"Remote-MySQL-la-gi-va-khi-nao-can-dung\"><\/span>Remote MySQL l\u00e0 g\u00ec v\u00e0 khi n\u00e0o c\u1ea7n d\u00f9ng?<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>Remote MySQL l\u00e0 t\u00ednh n\u0103ng cho ph\u00e9p k\u1ebft n\u1ed1i \u0111\u1ebfn MySQL database t\u1eeb \u0111\u1ecba ch\u1ec9 IP b\u00ean ngo\u00e0i server hosting \u2014 t\u1ee9c l\u00e0 t\u1eeb m\u00e1y t\u00ednh c\u00e1 nh\u00e2n ho\u1eb7c t\u1eeb server kh\u00e1c. M\u1eb7c \u0111\u1ecbnh cPanel ch\u1ec9 cho ph\u00e9p k\u1ebft n\u1ed1i t\u1eeb localhost. C\u1ea7n d\u00f9ng khi b\u1ea1n mu\u1ed1n qu\u1ea3n l\u00fd database b\u1eb1ng c\u00f4ng c\u1ee5 nh\u01b0 MySQL Workbench ho\u1eb7c DBeaver tr\u00ean m\u00e1y t\u00ednh. V\u00e0o cPanel \u2192 Remote MySQL \u2192 th\u00eam IP c\u1ea7n cho ph\u00e9p. L\u01b0u \u00fd: nhi\u1ec1u shared hosting provider gi\u1edbi h\u1ea1n t\u00ednh n\u0103ng n\u00e0y \u1edf t\u1ea7ng firewall.<\/p>\n<h3><span class=\"ez-toc-section\" id=\"ALL-PRIVILEGES-nghia-la-gi-%E2%80%94-co-nen-cap-cho-moi-user-khong\"><\/span>ALL PRIVILEGES ngh\u0129a l\u00e0 g\u00ec \u2014 c\u00f3 n\u00ean c\u1ea5p cho m\u1ecdi user kh\u00f4ng?<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>ALL PRIVILEGES c\u1ea5p cho user \u0111\u00f3 to\u00e0n quy\u1ec1n tr\u00ean database: \u0111\u1ecdc, ghi, s\u1eeda, x\u00f3a d\u1eef li\u1ec7u, t\u1ea1o\/x\u00f3a b\u1ea3ng, thay \u0111\u1ed5i c\u1ea5u tr\u00fac. V\u1edbi \u1ee9ng d\u1ee5ng web \u0111ang trong qu\u00e1 tr\u00ecnh ph\u00e1t tri\u1ec3n ho\u1eb7c c\u00e0i \u0111\u1eb7t, ALL PRIVILEGES l\u00e0 c\u1ea7n thi\u1ebft. V\u1edbi production site \u0111\u00e3 \u1ed5n \u0111\u1ecbnh, n\u00ean gi\u1ea3m xu\u1ed1ng SELECT + INSERT + UPDATE + DELETE \u0111\u1ec3 gi\u1ea3m r\u1ee7i ro \u2014 n\u1ebfu \u1ee9ng d\u1ee5ng b\u1ecb t\u1ea5n c\u00f4ng, attacker kh\u00f4ng th\u1ec3 d\u00f9ng quy\u1ec1n CREATE\/DROP \u0111\u1ec3 ph\u00e1 ho\u1ea1i c\u1ea5u tr\u00fac database.<\/p>\n<h3><span class=\"ez-toc-section\" id=\"Co-the-doi-ten-database-da-tao-trong-cPanel-khong\"><\/span>C\u00f3 th\u1ec3 \u0111\u1ed5i t\u00ean database \u0111\u00e3 t\u1ea1o trong cPanel kh\u00f4ng?<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>cPanel kh\u00f4ng c\u00f3 t\u00ednh n\u0103ng rename database tr\u1ef1c ti\u1ebfp. C\u00e1ch duy nh\u1ea5t: export database c\u0169 ra file SQL, t\u1ea1o database m\u1edbi v\u1edbi t\u00ean mu\u1ed1n \u0111\u1ed5i, import file SQL v\u00e0o database m\u1edbi, c\u1eadp nh\u1eadt file config c\u1ee7a \u1ee9ng d\u1ee5ng \u0111\u1ec3 tr\u1ecf sang database m\u1edbi, sau \u0111\u00f3 x\u00f3a database c\u0169. Quy tr\u00ecnh n\u00e0y kh\u00f4ng ph\u1ee9c t\u1ea1p nh\u01b0ng c\u1ea7n backup k\u1ef9 tr\u01b0\u1edbc khi th\u1ef1c hi\u1ec7n.<\/p>\n<p><!-- Conclusion --><\/p>\n<h2><span class=\"ez-toc-section\" id=\"Tong-ket-%E2%80%94-quy-trinh-chuan-va-nhung-diem-khong-bo-qua\"><\/span>T\u1ed5ng k\u1ebft \u2014 quy tr\u00ecnh chu\u1ea9n v\u00e0 nh\u1eefng \u0111i\u1ec3m kh\u00f4ng b\u1ecf qua<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>Qu\u1ea3n l\u00fd database tr\u00ean cPanel kh\u00f4ng ph\u1ee9c t\u1ea1p v\u1ec1 m\u1eb7t k\u1ef9 thu\u1eadt, nh\u01b0ng c\u00f3 m\u1ed9t logic c\u1ea7n hi\u1ec3u \u0111\u00fang ngay t\u1eeb \u0111\u1ea7u: database v\u00e0 database user l\u00e0 hai th\u1ef1c th\u1ec3 t\u00e1ch bi\u1ec7t, v\u00e0 b\u01b0\u1edbc assign user v\u00e0o database l\u00e0 b\u01b0\u1edbc m\u00e0 ph\u1ea7n l\u1edbn l\u1ed7i k\u1ebft n\u1ed1i xu\u1ea5t ph\u00e1t t\u1eeb \u0111\u00f3.<\/p>\n<p>Quy tr\u00ecnh chu\u1ea9n g\u1ed3m 4 b\u01b0\u1edbc theo th\u1ee9 t\u1ef1: t\u1ea1o database \u2192 t\u1ea1o user \u2192 c\u1ea5p quy\u1ec1n \u2192 \u0111i\u1ec1n th\u00f4ng tin v\u00e0o \u1ee9ng d\u1ee5ng. B\u1ecf b\u01b0\u1edbc n\u00e0o c\u0169ng d\u1eabn \u0111\u1ebfn l\u1ed7i. V\u1edbi ng\u01b0\u1eddi m\u1edbi, MySQL Database Wizard trong cPanel \u0111\u01b0a b\u1ea1n qua \u0111\u1ee7 4 b\u01b0\u1edbc trong m\u1ed9t lu\u1ed3ng li\u00ean t\u1ee5c \u2014 \u00edt c\u00f3 c\u01a1 h\u1ed9i b\u1ecf s\u00f3t. Khi c\u1ea7n qu\u1ea3n l\u00fd nhi\u1ec1u database, trang MySQL Databases th\u1ee7 c\u00f4ng linh ho\u1ea1t h\u01a1n.<\/p>\n<p>phpMyAdmin l\u00e0 c\u00f4ng c\u1ee5 h\u1eefu \u00edch nh\u01b0ng c\u1ea7n d\u00f9ng c\u1ea9n th\u1eadn \u2014 c\u00e2u l\u1ec7nh DELETE v\u00e0 DROP th\u1ef1c thi ngay, kh\u00f4ng c\u00f3 undo. V\u1edbi database production, backup tr\u01b0\u1edbc m\u1ed7i thao t\u00e1c thay \u0111\u1ed5i d\u1eef li\u1ec7u l\u00e0 th\u00f3i quen c\u1ea7n x\u00e2y d\u1ef1ng t\u1eeb s\u1edbm.<\/p>\n<p>N\u1ebfu \u1ee9ng d\u1ee5ng c\u1ee7a b\u1ea1n \u0111ang ph\u00e1t tri\u1ec3n v\u1ec1 quy m\u00f4 \u2014 nhi\u1ec1u request \u0111\u1ed3ng th\u1eddi, database l\u1edbn h\u01a1n 500MB, ho\u1eb7c c\u1ea7n t\u00f9y ch\u1ec9nh MySQL configuration \u2014 h\u00e3y \u0111\u1ecdc th\u00eam v\u1ec1 <strong><a href=\"https:\/\/interdata.vn\/blog\/cpanel-va-whm\/\">s\u1ef1 kh\u00e1c bi\u1ec7t gi\u1eefa cPanel v\u00e0 WHM<\/a><\/strong> \u0111\u1ec3 hi\u1ec3u gi\u1edbi h\u1ea1n c\u1ee7a shared hosting, ho\u1eb7c xem x\u00e9t n\u00e2ng c\u1ea5p l\u00ean VPS v\u1edbi quy\u1ec1n qu\u1ea3n tr\u1ecb MySQL Server ho\u00e0n to\u00e0n.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>T\u00f3m t\u1eaft nhanh: Qu\u1ea3n l\u00fd database tr\u00ean cPanel bao g\u1ed3m 4 t\u00e1c v\u1ee5 c\u1ed1t l\u00f5i: t\u1ea1o MySQL database, t\u1ea1o database user, c\u1ea5p quy\u1ec1n truy c\u1eadp cho user v\u00e0o database, v\u00e0 thao t\u00e1c d\u1eef li\u1ec7u qua phpMyAdmin. cPanel t\u00e1ch bi\u1ec7t ho\u00e0n to\u00e0n database v\u00e0 user \u2014 t\u1ea1o xong c\u1ea3 hai v\u1eabn ch\u01b0a k\u1ebft n\u1ed1i \u0111\u01b0\u1ee3c cho<\/p>\n","protected":false},"author":11,"featured_media":40466,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[149],"tags":[],"class_list":["post-40457","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-control-panel"],"_links":{"self":[{"href":"https:\/\/interdata.vn\/blog\/wp-json\/wp\/v2\/posts\/40457","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=40457"}],"version-history":[{"count":7,"href":"https:\/\/interdata.vn\/blog\/wp-json\/wp\/v2\/posts\/40457\/revisions"}],"predecessor-version":[{"id":40476,"href":"https:\/\/interdata.vn\/blog\/wp-json\/wp\/v2\/posts\/40457\/revisions\/40476"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/interdata.vn\/blog\/wp-json\/wp\/v2\/media\/40466"}],"wp:attachment":[{"href":"https:\/\/interdata.vn\/blog\/wp-json\/wp\/v2\/media?parent=40457"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/interdata.vn\/blog\/wp-json\/wp\/v2\/categories?post=40457"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/interdata.vn\/blog\/wp-json\/wp\/v2\/tags?post=40457"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}