从不在linux cpanel上工作的不同数据库中选择两个或多个表

Question

This query is working on local xampp:

SELECT t1.id, t1.name, t2.id, t2.telephone
FROM db1.table1 t1
INNER JOIN db2.table2 t2 on t1.id = t2.id;

But the same query isn't working on LINUX cPanel

<?php 

    $hostname='localhost'; 
    $username='root'; 
    $password=''; 
    $db='smart_software'; 

    $username2='root'; 
    $password2=''; 
    $db2='smart_stationary'; 

    $con1 = mysqli_connect($hostname, $username, $password, $db); 
    $con2 = mysqli_connect($hostname, $username2, $password2, $db2);

    $result=mysqli_query($con2,"select MSC.mobile_sub_cat_id, MSC.employee_id, ED.employee_name, LN.location, MC.mobile_cat_name, MSC.service_provider, MSC.number FROM smart_stationary.mobile_sub_cat MSC LEFT JOIN smart_stationary.mobile_cat MC ON MC.mobile_cat_id=MSC.mobile_cat_id LEFT JOIN smart_software.employee_details ED ON ED.employee_id=MSC.employee_id LEFT JOIN smart_stationary.location LN ON LN.location_id=MSC.location_id"); 

    while($row=mysqli_fetch_array($result)) { 
        echo $row['location']; 
    } 
?>

Answer 1

---

-Are u sure both database in mysql access

1. create user on cpanel phpmyadmin.
2. set privilege