It is very easy to connect server database from localhost. In this tutorial, we will see how to connect server databases from local server.
To connect to server db mean to use remote MySQL connection, First of all we have to activate remote MySQL from cPanel.
Login to cpanel.
Go to remote MySQL option.
Add wildcard(%) and save.
Now simply we need to change connection parameters in localhost connection file.Then we have to include connection file in all other pages where need MySQL connection.
Example:
<?php
$db['host'] = 'server IP address here';
$db['user'] = 'server db username';
$db['pass'] = 'server db password';
$db['name'] = 'server dbname';
$db['port'] = '3306';
$conn = mysqli_connect($db['host'],$db['user'],$db['pass'],$db['name'], $db['port']);
if (mysqli_connect_errno($conn)) {
trigger_error('Database connection failed: ' . mysqli_connect_error());
}
?>