LogoLogo
SupportServer Hosting
  • Sonoran CAD
  • 📱Download The App
    • Steam Browser - Workaround
    • Web Browser - Clear Cache
    • Desktop App - Clear Cache
    • GTA RP Tablet - Clear Cache
    • Steam Browser - Clear Cache
  • Why Choose Sonoran CAD?
    • 🏆Why Choose Sonoran CAD?
  • Other Products
    • 🖥️FiveM Hosting
    • 📝Sonoran CMS
    • 📡Sonoran Radio
  • Tutorials
    • Getting Started
      • Registering Your Account
      • Registering Your Community
      • Inviting Users to Your CAD
      • Granting Account Permissions
      • View Your Limits
      • Community ID and API Keys
      • Troubleshooting
    • Customization
      • Custom Domain & Login Page
      • Customizing Your Layout
      • Community Branding and Settings
      • Creating Custom Record and Report Types
      • Sharing Custom Records
      • Custom Search Types
      • Geographical Settings
      • Penal Codes
      • 10-Codes
      • Addresses and Street Names
      • Unit Status Codes
      • Tone Board
      • Custom Audio Notifications
      • Custom Emails
      • Quick Links
      • Custom Page Colors
      • User Account Restrictions
      • Configuring Multiple Servers
      • Advanced Query Strings
    • Dispatching
      • Creating a Call
      • Self Dispatch
      • Timers
      • Command Line Interface (CLI)
    • Records Management
      • Record Lookups
      • Adding a Record
      • PDF Records
      • Scene Diagram Builder
    • Administration
      • System Logs
      • Remove User Account
      • Deleting or Transferring your CAD
    • Other Features
      • Configurable Hotkeys
      • Voice Commands
      • Volume and Language
  • Integration Capabilities
    • 🗃️Paid Integration Resources
      • Mobile Command Center
      • ATM Robbery
      • In-Vehicle Radar
      • Evidence Camera
      • Power Grid
      • Speed Cameras
      • Shot Spotter
    • 🛠️Integrated Vendors
    • 📺Twitch Bodycam, Bot, & Lighting Integration
    • Database Sync and Merge
      • Database Sync Credentials
      • QB Core Mapping Tutorial
      • Troubleshooting
    • Discord Bot Integration
    • Discord Rich Presence
    • Discord Webhooks
    • TeamSpeak 3 Integration
    • Stream Deck Integration
    • 🎮FiveM
      • FiveM Installation
        • Submodule Configuration
          • Submodule Troubleshooting
          • Submodule Configuration Updates
        • FiveM Submodules
          • Body Camera
          • Call Commands
          • Check API ID
          • Civilian Integration
          • Dispatch Notify
          • Emergency Response Simulator (ERS)
          • Framework Support (ESX/QBCore) and Auto Fines
          • FivePD
          • ForceReg
          • Kick
          • Locations
          • Live Map
          • Lookups
          • Postals
          • Smart Signs
          • Sonoran Radio (sonrad)
          • Station Alert
          • Tablet & Mini-CAD
          • TeamSpeak 3
          • Traffic Stop
          • Unit Status
          • VehReg
          • WraithV2
      • FiveM Development Documentation
        • Client Functions
        • Shared Functions
        • Server Functions
        • Server Events
        • HTTP Request Handling
      • Error Codes
    • 🎮Roblox ER:LC
  • Developer API Documentation
    • 📖API Integration
      • Getting Started
        • Retrieving Your Credentials
        • Integration API ID
        • Account Secret ID
      • Push Events
        • Event Restrictions
        • Record Events
          • Record Added
          • Record Edited
          • Record Removed
        • Unit Events
          • Unit Panic
          • Unit Login
          • Unit Logoff
          • Unit Status Update
          • Unit Group Name Change
          • Unit Group Add
          • Unit Group Remove
        • Dispatch Events
          • New Dispatch
          • Modified Dispatch
          • Closed Dispatch
          • Dispatch Note
          • Attach Unit
          • Detach Unit
          • Toggle Bodycam
        • Event 911
        • Remove 911
        • Sign Updated
        • Tone Played
        • Civilian
          • Character Selected
        • ERS
          • New Callout
        • Station Alert
          • New Station Alert
      • API Endpoints
        • API Restrictions
        • Emergency
          • Identifiers
            • Get Identifiers
            • Modify Identifier
            • Set Identifier
            • Unit Panic
            • Kick Unit
            • Unit Status
            • Get Active Units
            • Update Unit Location
          • Dispatch and Emergency Calls
            • Get Calls
            • New Dispatch
            • Attach Unit
            • Detach Unit
            • Update Call Postal
            • Add Call Note
            • Update Call Primary
            • Close Dispatch
            • New 911 Call
            • Remove 911
          • Custom Blips
            • Get Map Blips
            • Add Blip
            • Modify Blip
            • Remove Blip
          • Street Signs
            • Set Street Sign Config
            • Update Street Sign
          • ERS
            • Set Available Callouts
          • Station Alert
            • Set Stations
        • Civilian
          • Set Character
          • Get Characters
          • New Character
          • Edit Character
          • Remove Character
          • DB Sync: Get Character Links
          • DB Sync: Link Character
        • General
          • Get Servers
          • Set Servers
          • Get Version
          • Set Penal Codes
          • Set API IDs
          • Custom Records
            • API Options for Adding and Modifying Records
            • Get Record Templates
            • New Record
            • Edit Record
            • Remove Record
          • Lookup By Value
          • Lookup Name or Plate
          • Get Account
          • Get Accounts
          • Check API ID
          • Apply Permission Key
          • Modify Account Permissions
          • Kick or Ban User
          • Verify Secret
          • Auth Street Signs
          • Set Postal Config
          • Set Clock Time
          • Send Photo
          • Leave Community
          • Join Community
        • Local Endpoints
          • Smart Lighting
        • Internal
          • FiveM Download
      • API Examples
        • Emergency
          • LUA Examples
            • Dispatch and Emergency Calls
              • New 911 Call
              • Remove 911
              • Add Call Note
              • Set Call Postal
            • Custom Blips
              • Add Blip
              • Add Blips
              • Add Temp Blip
              • Get Map Blips
              • Remove Blip
              • Remove Blip With Subtype
            • General
              • Lookup Name or Plate
          • JavaScript Examples
            • Dispatch and Emergency Calls
              • New 911 Call
              • Remove 911
              • Add Call Note
              • Set Call Postal
            • Custom Blips
              • Add Blip
              • Add Blips
              • Add Temp Blip
              • Get Map Blips
              • Remove Blip
              • Remove Blip With Subtype
            • General
              • Lookup Name or Plate
      • Development Branch
    • 💵Developer Bounties
    • 🌎Translation Support
  • Pricing
    • Pricing FAQ
      • Military and First Responder Discount
      • Expert Installation
      • Accessing the Payment Center
      • Create and Manage a Subscription
      • Request Discord Role
    • View and Compare Plans
  • Roadmap
    • 📋Changelog
  • Other
    • AI QA
    • Contact Us
    • Policy
      • Rocket CAD Closure
      • Terms of Service
      • Privacy Policy
      • Refund and Purchase Policy
      • Discord Bot
    • Archive
      • Fire Siren
Powered by GitBook
On this page
  • 1. Getting your Credentials
  • 2. Port Forwarding
  • IP Whitelisting

Was this helpful?

Edit on GitHub
  1. Integration Capabilities
  2. Database Sync and Merge

Database Sync Credentials

Getting your database Credentials to use with Database Sync.

PreviousDatabase Sync and MergeNextQB Core Mapping Tutorial

Last updated 1 month ago

Was this helpful?

Database Sync is not enabled with the free version of Sonoran CAD. For more information, see our or view how to check your community .

Looking for VPS, web, or dedicated hosting? Check out our official !

Database Sync is a read-only system. All characters, licenses, and vehicle registrations pulled from your database can not be modified in the CAD. Database Merge allows you to save off additional, manually specified data in the CAD.

1. Getting your Credentials

phpMyAdmin - Database Credentials

1. Navigate to your phpMyAdmin Web Panel

2. Navigate to User Accounts

At the top of your screen click on User Accounts.

3. Create a new user account

4. Fill out the account information

The Host Name field should be set as Any Host and the value as %. This will allow external IPs (Sonoran CAD) to connect to your database.

5. Once created, edit the user account privileges

6. Select your specific database

7. Select only the required permissions

SELECT and SHOW VIEW will ensure this account can only read from your database.

8. Save the user and set credentials in Sonoran CAD

Database Translation Information:

phpMyAdmin

SonoranCAD

Host

Host/Address

Database

Database

User name

Username

Password

Password

HeidiSQL - Database Credentials

1. Login to your database using HeidiSQL.

2. Open the User Manager

At the top of your screen click Tools and then User Manager. Then, click Add at the top left.

3. Enter the Account Information

Enter a user name, password, and enter % in the From host field. This will allow external IPs (Sonoran CAD) to connect to your database.

Under Allow Access To select Add Object

4. Select the Database

Select the name of your database, then hit Ok.

5. Select the Permissions

Check off the EXECUTE, SELECT, and SHOW VIEW read permissions. Then press Save.

6. Save the user and set credentials in Sonoran CAD

Database Translation Information

HeidiSQL

SonoranCAD

Host

Host/Address

User name

Username

Password

Password

Database

Database

Zap Hosting - Database Credentials

1. Login

Login to your Zap Hosting Account and Navigate to your FiveM Server.

2. View the Tools Section

Scroll down until you see TOOLS on the left hand side of your screen and select Databases.

3. View Database Credentials

In the Center of your screen you will see you're database Credentials.

4. Set DB Credentials in Sonoran CAD

Database Translation Information

Zap Hosting

SonoranCAD

Server/IP

Host/Address

Database

Database

User

Username

Password

Password

2. Port Forwarding

If your database port has not already been opened, you will need to forward/open this port. Typically, the default MySQL port is 3306.

If you are unsure how to open a port, you will need to contact your hosting provider.

IP Whitelisting

My community wants to whitelist only the Sonoran CAD IP address to connect on this SQL user account. How can I do this?

You may whitelist the following IPs:

23.27.5.3
24.199.66.94
198.199.90.248

Last Updated : 3/26/2025

You will now want to go to and get your Public IP Address to use as your Host.

See to figure out how to add Credentials to your CAD Instance using the information above.

You will now want to go to and get your Public IP Address to use as your Host.

See to figure out how to add Credentials to your CAD Instance using the information above.

See to figure out how to add Credentials to your CAD Instance using the information above.

To check if your MySQL port has been properly opened, and enter your MySQL server's IP address and port.

http://whatsmyip.org
http://whatsmyip.org
visit a port checking utility
pricing
limits
server hosting
Database Sync and Merge Connection Credentials
Database Sync and Merge Connection Credentials
Database Sync and Merge Connection Credentials
phpMyAdmin - New User Account
phpMyAdmin - New User Information
phpMyAdmin - Edit Account Privileges
phpMyAdmin - Set Database
phpMyAdmin - Read Only Permissions
HeidiSQL - Open User Manager
HeidiSQL - User Account Credentials
HeidiSQL - Select Database
HeidiSQL - Select User Permissions
ZAP Hosting Tools - Database
Zap Hosting - Database Credentials