Search for a command to run...
I am a full-stack software developer driven by the goal of creating scalable solutions to automate business processes. Throughout my career, I have successfully developed web, mobile and USSD applications that serve thousands of users, both for profit and non-profit.
No comments yet. Be the first to comment.
Kenya is often celebrated as the “Silicon Savannah” — a country known for mobile money innovation, startup culture, and rapid digital growth. From fintech to e-commerce, new apps are launched every ye
Perfectionism often looks like excellence on the outside, but inside it quietly becomes a barrier to progress, confidence, and fulfillment. The Downsides of Perfectionism Perfectionists often struggle
Kenya loves celebrating tech: more developers, more startups, more digital infrastructure. The narrative is clear: if you’re in tech, you’re winning. But here’s the uncomfortable truth — most of what
There is a quiet performance happening in African tech. On social media, we speak Kubernetes.In production, we deploy chaos. We proudly announce: Microservices Event-driven systems Serverless archi
In Kenya today, social media is no longer just entertainment. It is: A CV A branding tool A social class signal A relationship filter A moral scoreboard We have quietly turned Instagram, X, Facebook, and TikTok into character assessment tools....
On this page
cPanel is a web-based control panel that provides a graphical interface and automation tools designed to simplify the process of hosting and managing a server/website ranging from emails files, databases, domains, and more.
Assume you have databases hosted on different cPanel accounts e.g. your company may have multiple cPanel accounts or you may have various clients who want their information shared across their accounts.
Login to the cPanel account of the host (server to use the database from another server). Navigate to the right side window. Under "General Information", get the server IP address of the The shared IP address adopts a format as this 140.105.20.19.
Login to the cPanel of the remote(server to have its database shared). Locate the "Database" section, and click on "Remote Database Access".
You need to inform the remote server to allow traffic from the host server by whitelisting its IP address acquired in Step 1 above. Assume your host is 140.105.20.19, type it in the "Host" input. Specifying the comment is optional, however, it may be helpful where you have multiple hosts.
Once the hosts server IP address is whitelisted, you may choose to update or delete it when necessary.
Go to the remote cPanel account (the one whose database is being shared). Follow the procedures as shown in Step 1 to get the IP address of the remote server.
Go back to the host cPanel and write/host your database connection script. The script can be used to test if the connection is successful. Below is a sample code using PHP.
Note: Your server name being used is the remote server IP address obtained from Step 4 above. Assume our remote IP address is 150.105.20.19
<?php
$servername = "150.105.20.19"; // Remote server IP address
$username = "database_username"; // MySQL database username
$password = "database_password"; // MySQL database password
$database = "database_name"; // MySQL database name
// Create connection
$conn = new mysqli($servername, $username, $password, $database);
// Check connection
if ($conn->connect_error) {
die("Connection failed: " . $conn->connect_error);
}
echo "Connected successfully";
// Perform database operations here
// Close connection
$conn->close();
?>
Cheers! You can now test and run your script. For any inquiries, feel free to contact me using +254791323200 or mail@douglas.africa