Two domains using same mqsql database

Yes, same MySQL user and same code for both domains. I even tried to create a new mysql use and grant access, same result. I can connect to mysql database via putty fine.

The issue you’re facing with your second domain not displaying data, despite using the same droplet and MySQL database as the first domain, could be due to a variety of factors. Here are some possible causes and troubleshooting steps:

1. Database Connection Credentials: Double-check the credentials (username, password, database name) used for the connection. They should be identical for both domains if they’re accessing the same database.

2. Database User Permissions: Ensure that the MySQL user specified in your connection string has the necessary permissions to access and query the database from the second domain.

3. PHP Error Reporting: Enable PHP error reporting to see if there are any warnings or errors that aren’t immediately visible. You can enable error reporting by adding the following lines at the beginning of your script:

error_reporting(E_ALL);
ini_set('display_errors', 1);

4. SQL Query Execution: Check if you’re executing any SQL queries after connecting to the database. If so, ensure they are being executed correctly. Use mysql_error() to print any errors related to SQL queries.

5. PHP Script Differences: If there are differences in the PHP scripts between the two domains, even small ones, they could lead to different behaviors. Review the code on the second domain to ensure it’s intended to fetch and display data.

6. File Permissions: Ensure that the PHP files on the second domain have the correct permissions to be read and executed by the server.

7. Server Configuration: There might be differences in server configuration (like .htaccess files, Apache or Nginx configurations) between the two domains. These could affect how PHP scripts are executed.

8. DNS and Server Cache: Sometimes, issues can be related to DNS or server caching. Clearing the cache or waiting for DNS propagation (if there have been recent changes) might resolve the issue.

9. Database Table Structure: Ensure that the database table structure is compatible with the queries in your PHP script. If there were recent changes to the database, they might affect how data is fetched and displayed.

10. Cross-Domain Issues: If the script is making any cross-domain requests (for example, fetching data from a domain different from where the script is hosted), ensure there are no cross-domain policies (like CORS) preventing the data from being fetched.

11. Network Issues: Rarely, the issue could be due to network problems between your server and the database. Check if there are any network connectivity issues.

As a best practice, consider moving away from the deprecated mysql_* functions and use mysqli or PDO for database interactions in PHP. This not only improves security but also provides better error handling and debugging capabilities.