Comment on page
Database Sync Credentials
Getting your database Credentials to use with Database Sync.
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.
phpMyAdmin
HeidiSQL
Zap Hosting
At the top of your screen click on
User Accounts
.
3. Create a new user account

phpMyAdmin - New User Account
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.
phpMyAdmin - New User Information

phpMyAdmin - Edit Account Privileges

phpMyAdmin - Set Database
SELECT
and SHOW VIEW
will ensure this account can only read from your database.
phpMyAdmin - Read Only Permissions
Database Translation Information:
phpMyAdmin | SonoranCAD |
Host | Host/Address |
Database | Database |
User name | Username |
Password | Password |
See Database Sync and Merge Connection Credentials to figure out how to add Credentials to your CAD Instance using the information above.
At the top of your screen click
Tools
and then User Manager.
Then, click Add
at the top left.
HeidiSQL - Open User Manager
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

HeidiSQL - User Account Credentials
Select the name of your database, then hit
Ok
.
HeidiSQL - Select Database
Check off the
EXECUTE
, SELECT
, and SHOW VIEW
read permissions. Then press Save
.
HeidiSQL - Select User Permissions
Database Translation Information
HeidiSQL | SonoranCAD |
Host | Host/Address |
User name | Username |
Password | Password |
Database | Database |
See Database Sync and Merge Connection Credentials to figure out how to add Credentials to your CAD Instance using the information above.
Login to your Zap Hosting Account and Navigate to your FiveM Server.
Scroll down until you see TOOLS on the left hand side of your screen and select
Databases
.
ZAP Hosting Tools - Database
In the Center of your screen you will see you're database Credentials.

Zap Hosting - Database Credentials
Database Translation Information
Zap Hosting | SonoranCAD |
Server/IP | Host/Address |
Database | Database |
User | Username |
Password | Password |
See Database Sync and Merge Connection Credentials to figure out how to add Credentials to your CAD Instance using the information above.
If your database port has not already been opened, you will need to forward/open this port.
Typically, the default MySQL port is
3306
.To check if your MySQL port has been properly opened, visit a port checking utility and enter your MySQL server's IP address and port.
If you are unsure how to open a port, you will need to contact your hosting provider.
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 IP:
23.27.5.3