Comment on page

Database Sync Credentials

Getting your database Credentials to use with Database Sync.

Database Sync is not enabled with the free version of Sonoran CAD.
For more information, see our pricing or view how to check your community limits.
Looking for VPS, web, or dedicated hosting? Check out our official server hosting!
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
HeidiSQL
Zap Hosting
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
phpMyAdmin - 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.
phpMyAdmin - New User Information
5. Once created, edit the user account privileges
phpMyAdmin - Edit Account Privileges
6. Select your specific database
phpMyAdmin - Set Database
7. Select only the required permissions
SELECT and SHOW VIEW will ensure this account can only read from your database.
phpMyAdmin - Read Only Permissions
8. Save the user and set credentials in Sonoran CAD
You will now want to go to http://whatsmyip.org and get your Public IP Address to use as your Host.
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.
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.
HeidiSQL - Open User Manager
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
HeidiSQL - User Account Credentials
4. Select the Database
Select the name of your database, then hit Ok.
HeidiSQL - Select Database
5. Select the Permissions
Check off the EXECUTE, SELECT, and SHOW VIEW read permissions. Then press Save.
HeidiSQL - Select User Permissions
6. Save the user and set credentials in Sonoran CAD
You will now want to go to http://whatsmyip.org and get your Public IP Address to use as your Host.
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.
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.
ZAP Hosting Tools - Database
3. View Database Credentials
In the Center of your screen you will see you're database Credentials. 
Zap Hosting - 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
See Database Sync and Merge Connection Credentials to figure out how to add Credentials to your CAD Instance using the information above.
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.
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.
​
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 IP:
23.27.5.3
​
​
​
​
​