# GKSPHONE Real App Installation {% hint style="info" %} GKSPHONE REAL APP is only authorized to view your SQLs. They do not have the authority to change / effect / add / delete / drop {% endhint %} ## Connecting your database information {% tabs %} {% tab title="HeidiSQL" %} 1. Log in to your database using HeidiSQL 2. Open `Tools` > `User Manager`

3. `Click Add` 4. Enter user name, password and set `%` in the `From Host` field. This is to provide SQL access with GKSPhone Real App.

5. In the `Allow access to:` section, click `Add object` 6. Choose your server database then click `OK`

7. Select `EXECUTE`, `SELECT`, `SHOW VIEW` permissions and click the `Save` button.

{% endtab %} {% tab title="phpMyAdmin" %} 1. Open your **phpMyAdmin Web Panel** 2. Click on the `User accounts` section

3. Click `Add user account`

4. Enter user name, password and `Host Name` section should be set to `Any Host` and its value should be `%` This is to provide SQL access with GKSPhone Real App

5. After creating the account, click `Edit privileges`

6. Choose your server database then click `GO`

7. Select `SELECT`, `SHOW VIEW` permissions and click the `Go` button.

{% endtab %} {% endtabs %} ## Connecting your SQL account information to the application
{% tabs %} {% tab title="Add your server" %} 1. Go to [APP GKSHOP](https://app.gkshop.org/#/) site 2. Log in to your account. If you aren't registered, `register with the email address you purchased your Real App subscription from!` 3. Go to `Services` > `Real App`

4. Enter your create SQL account and server information in the table that appears on the screen.

| Field | Value | | ----------- | --------------------------------------------------------------------------------------------------------------------------------- | | Server ID | Your [fivem server id](https://gkshop.org/gksphone/serverid.png) | | Host/Adress | Enter your server ip | | Port | SQL Port, Default 3306 | | Database | Enter your database name | | Username | [SQL account username you created](https://docs.gkshop.org/other-products/gksphone-real-app#connecting-your-database-information) | | Password | [SQL account password you created](https://docs.gkshop.org/other-products/gksphone-real-app#connecting-your-database-information) | 5. After filling in all fields, press the `TEST CONNECTION` button

GKSHOP Application - Real App > Test Connection

6. After the test connection is successful, click the `SAVE` button

GKSHOP Application - Real App > Test Connection Succesful

7. Now your added server will appear here

GKSHOP Application - Real App > Server List

{% endtab %} {% endtabs %} ## Port Forwarding The real app needs a MySQL port to access your information. If you receive the following error in the `Test Connection` step even though you entered all your information correctly, it means that your MySQL `3306` port is not open.

GKSHOP Application - Real App > Test Connection Error

You can check whether this port is open by typing your machine IP address and port 3306 [on this site.](https://www.yougetsignal.com/tools/open-ports/) {% hint style="danger" %} After making sure your port is closed, you need to open the port. If you have no knowledge about opening a port, **"please contact your hosting provider."** {% endhint %} ## Core and Vehicle Table Configuration

{% hint style="info" %} In this section you must write your core information and sql tool table name. This is mandatory for the application to work correctly and display the correct data! {% endhint %} {% hint style="danger" %} **Don't forget to select your server from the Servers section then to click "UPDATE" after making your settings.** {% endhint %} ## **Application Configuration**

{% hint style="info" %} This section shows the applications found in real app. You can close the application that you don't want to use from these applications. Simply remove the tick next to the application name. {% endhint %} {% hint style="danger" %} **Don't forget to select your server from the Servers section then to click "UPDATE" after making your settings.** {% endhint %} ## **Configuration for Real App Functions** After doing all the above steps, you need to change the `Config.RealApplication` setting in `gksphone/config/config.lua` to true.