How do I enable remote MySQL on cPanel?
Enabling Remote MySQL in the Domain cPanel Interface Log in to the domain’s cPanel interface and find the section on the main page labeled Databases. In the Databases section find the link/button labeled Remote MySQL and click on it. The following page will appear in your browser.
How do I connect to a git repository from cPanel?
Login to your cPanel server via SSH as your cPanel user, or use the Terminal icon in the cPanel account to access the command line. Run the following command to generate the private and public keys that you will use to authenticate to your remote Git repository.
How do I access the command line in cPanel?
Login to your cPanel server via SSH as your cPanel user, or use the Terminal icon in the cPanel account to access the command line. NOTE: Pay special attention to the example output.
How do I upload an SSH key to cPanel?
Navigate to the Auth interface under the SSH category. Click Browse, select the private key file to upload, and click Open. Navigate to cPanel’s Manage SSH Keys interface ( Home >> Security >> SSH Access >> Manage SSH Keys) and import the server’s keys.
What is cPanel server?
A server on which to install web applications. The method we’re about to describe will work if you install and configure sites manually, but it is faster and more convenient with cPanel.
How to add a new profile to WHM?
To add a new profile, log in to WHM and navigate to Manage MySQL® Profiles under SQL Services in the sidebar menu. WHM can log in to the server, create a new MySQL superuser to manage databases, and configure MySQL. If you have already configured the MySQL installation with a superuser, you can add those details instead.
What is a profile in a database?
Profiles can be used to configure several types of remote databases, including those running on other cPanel & WHM servers, dedicated MySQL servers, and databases running on Amazon’s Relational Database™ Service.
What is a host in WHM?
Hosts added in WHM are applied to all cPanel user accounts and the MySQL users associated with those accounts.
How to use MySQL server?
You might use a remote MySQL server to: 1 Offload database workloads from the webserver to improve the performance of busy sites and the database. 2 Use a server specifically configured for database hosting. 3 Centralize database management for multiple servers. 4 Isolate the database from servers accessible via a public IP address.
Can a website and cPanel be installed on the same server?
Typically, websites and cPanel’s MySQL instance are installed on the same server. However, it’s sometimes useful to separate them so that sites use a remote MySQL database hosted on a different server. You might use a remote MySQL server to:
Can you create a MySQL profile in WHM?
In addition to configuring remote databases in cPanel & WHM, server administrators can create MySQL profiles in WHM to connect with remote database servers. A MySQL Profile allows administrators to define the remote database used throughout cPanel & WHM; in fact, the local machine’s default database is configured via a profile.
What is SSH access in cPanel?
This section of cPanel’s SSH Access interface allows you to create, import, manage, and remove SSH keys. The system will use these keys when you confirm that a specific computer has the right to access your website’s information with SSH.
How to log into a server using SSH?
To log in to a server via SSH with PuTTY and a public key, perform the following steps: From the Windows Start menu, open the client. Navigate to the PuTTY Key Generator interface. Under the Actions heading, click Generate. PuTTY will generate the key and display the result under the Key menu.
Where to upload private key?
Upload your PRIVATE key to the ~/.ssh directory of your cPanel account . This can be done via the File Manager icon in cPanel, FTP, SFTP, or you can copy and paste it in via SSH if you know how.
Do you need to pull changes from a remote git repository?
You need to pull changes from a remote Git repository to the repository that is hosted in your cPanel account and the remote repository requires authentication.
Can you use a passphrase protected key in cPanel?
NOTE: Keys that are passphrase protected are not compatible with cPanel Git™ Version Control. If your existing keys require a passphrase, please make use of the section labeled: Option #1 - Generate a New Private and Public Key Pair to learn how to generate a compatible set of keys.
Enabling Remote MySQL in the WHM Interface
Log in to the server’s WHM interface and find the section in the left-side navigation bar labeled SQL Services. You can sort the list by typing ‘sql’ in the search box. Click on the link marked Additional MySQL Access Hosts:
Enabling Remote MySQL in the Domain cPanel Interface
Log in to the domain’s cPanel interface and find the section on the main page labeled Databases.
About the Author: Jay Allen
Our Sales and Support teams are available 24 hours by phone or e-mail to assist.
