MySQL Database Connection Test
Test 1: PHP PDO MySQL Extension
✅ PDO MySQL extension is installed and enabled
Test 2: MySQLi Extension (Alternative)
✅ MySQLi extension is also available
Test 3: Configuration File
✅ db_config.php file exists
Test 4: Database Connection
✅ Successfully connected to MySQL database!
Test 5: Database Information
MySQL Version: 10.6.20-MariaDB-cll-lve
Current Database: edaught1_desimon
Character Set: utf8mb4
Server Hostname: web115.dnchosting.com
Test 6: Create Test Table
✅ Test table created successfully
✅ Test data inserted successfully (ID: 61)
✅ Test data retrieved successfully
Test Summary
🎉
All tests passed! Your database connection is working correctly.
Next Steps:- Create your database schema (tables)
- Upload these files to your public_html folder
- Update db_config.php with production credentials
- Remove or protect this test file in production
Your Directnic MySQL Credentials Location:
You can find your MySQL database details in your Directnic control panel:
- Log into your Directnic account
- Go to "Web Hosting" or "MySQL Databases" section
- Look for:
- Database Name: Usually prefixed with your username
- Database User: Often the same as database name
- Database Password: The password you set when creating the database
- Database Host: Usually "localhost" for Directnic
← Back to Homepage