# Step 5 — Safe Database Connection & Schema Verification

This step does NOT modify the MySQL database.

## 1. Keep credentials out of the ZIP

Edit only your local/server copy of:

`config/database.php`

Put your existing database credentials there. Do not send that file back in chat and do not commit it to a public repository.

The file should return an array with these keys:

- host
- port
- database
- username
- password
- charset

Example structure (use your real values only on your server):

```php
<?php
return array(
    'host' => 'YOUR_HOST',
    'port' => 3306,
    'database' => 'YOUR_DATABASE',
    'username' => 'YOUR_USERNAME',
    'password' => 'YOUR_PASSWORD',
    'charset' => 'utf8mb4'
);
```

## 2. Verify the database

Open:

`/numerology-platform/tools/verify-database-schema.php`

It checks that the connection works and that the required existing tables are present.

## 3. Expected result

The JSON should report:

`"success": true`

and:

`"missing_tables": []`

## 4. Important

Do NOT import another SQL file.
Do NOT create new tables.
Do NOT alter existing tables.
Do NOT run migrations.

This step is verification only.

## 5. After verification

If the result is successful, the next step is to test the first numerology profile API against the database using a controlled test user.

If it fails, send me only the error message/result — never send database credentials.