{"id":18422,"date":"2026-09-29T23:51:15","date_gmt":"2026-09-29T20:51:15","guid":{"rendered":"https:\/\/www.hyyat.com\/knowledgebase\/enable-remote-mysql\/"},"modified":"2026-09-29T23:51:15","modified_gmt":"2026-09-29T20:51:15","password":"","slug":"enable-remote-mysql","status":"publish","type":"docs","link":"https:\/\/www.hyyat.com\/en\/knowledgebase\/enable-remote-mysql\/","title":{"rendered":"How to Enable Remote MySQL Connections in WHM and cPanel"},"content":{"rendered":"
In short:<\/strong> To allow connections to a MySQL database from an external server or computer: in WHM, go to SQL Services, then Additional MySQL Access Hosts, and add the allowed IP address. Then in cPanel, go to Databases, then Remote MySQL, and add the same address. Only allow specific IP addresses; do not use %, which opens your databases to everyone.<\/div>\n

By default, remote MySQL connections are disabled on cPanel servers. You need them when an application or website on another server connects to your database, or when you manage the database from a program on your computer such as MySQL Workbench or HeidiSQL. Only allow specific, trusted IP addresses, because opening databases to everyone is a serious security risk.<\/p>\n

In WHM (server administrators)<\/h2>\n

1.<\/strong> Log in to WHM at https:\/\/your-server-ip:2087<\/strong> with your username and password.<\/p>\n

\"WHM<\/p>\n

2.<\/strong> Go to SQL Services<\/strong>.<\/p>\n

\"SQL<\/p>\n

3.<\/strong> Click Additional MySQL Access Hosts<\/strong>.<\/p>\n

\"Additional<\/p>\n

4.<\/strong> Enter one or more hostnames or IP addresses and click Save<\/strong>. To apply them to all accounts, use the link on the same page.<\/p>\n

\"Add<\/p>\n

In cPanel (each account)<\/h2>\n

1.<\/strong> Log in to cPanel (see how to log in to cPanel<\/a>).<\/p>\n

2.<\/strong> In the Databases<\/strong> section, click Remote MySQL<\/strong>.<\/p>\n

\"Remote<\/p>\n

3.<\/strong> Add the hostname or IP address you want to allow and click Add Host<\/strong>. To remove one later, click Delete<\/strong> next to it.<\/p>\n

\"Add<\/p>\n

Connect using your server hostname or IP as the host, port 3306, and the database user and password you created in cPanel.<\/p>\n

Related service:<\/strong> Hyyat Host server management<\/a> can set up secure database access for you, with 24\/7 support.<\/p>\n","protected":false},"excerpt":{"rendered":"

In short: To allow connections to a MySQL database from an external server or computer: in WHM, go to SQL Services, then Additional MySQL Access Hosts, and add the allowed IP address. Then in cPanel, go to Databases, then Remote MySQL, and add the same address. Only allow specific IP addresses; do not use %, […]<\/p>\n","protected":false},"author":4,"featured_media":0,"comment_status":"open","ping_status":"closed","template":"","meta":{"inline_featured_image":false,"_templately_pack_id":"","_templately_imported_at":"","_templately_source":"","_templately_import_session_id":"","footnotes":""},"doc_category":[2734],"doc_tag":[],"class_list":["post-18422","docs","type-docs","status-publish","hentry","doc_category-whm-cpanel-control-panels"],"year_month":"2026-10","word_count":250,"total_views":"3","reactions":{"happy":"0","normal":"0","sad":"0"},"author_info":{"name":"ahmed fathy","author_nicename":"ahmed-fathy","author_url":"https:\/\/www.hyyat.com\/en\/author\/ahmed-fathy\/"},"doc_category_info":[{"term_name":"whm\/cpanel control panels","term_url":"https:\/\/www.hyyat.com\/en\/kb\/whm-cpanel-control-panels\/"}],"doc_tag_info":[],"knowledge_base_info":[],"knowledge_base_slug":[],"_links":{"self":[{"href":"https:\/\/www.hyyat.com\/en\/wp-json\/wp\/v2\/docs\/18422","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.hyyat.com\/en\/wp-json\/wp\/v2\/docs"}],"about":[{"href":"https:\/\/www.hyyat.com\/en\/wp-json\/wp\/v2\/types\/docs"}],"author":[{"embeddable":true,"href":"https:\/\/www.hyyat.com\/en\/wp-json\/wp\/v2\/users\/4"}],"replies":[{"embeddable":true,"href":"https:\/\/www.hyyat.com\/en\/wp-json\/wp\/v2\/comments?post=18422"}],"version-history":[{"count":0,"href":"https:\/\/www.hyyat.com\/en\/wp-json\/wp\/v2\/docs\/18422\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.hyyat.com\/en\/wp-json\/wp\/v2\/media?parent=18422"}],"wp:term":[{"taxonomy":"doc_category","embeddable":true,"href":"https:\/\/www.hyyat.com\/en\/wp-json\/wp\/v2\/doc_category?post=18422"},{"taxonomy":"doc_tag","embeddable":true,"href":"https:\/\/www.hyyat.com\/en\/wp-json\/wp\/v2\/doc_tag?post=18422"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}