For more information, please refer to the following section of our online documentation: MySQL Databases
help MySQL 5 Connection Settings:
Local (web applications):
Host: localhost
Socket: /tmp/mysql5.sock
Note: Most PHP applications/scripts will accept the following syntax:
MySQL Host: localhost:/tmp/mysql5.sock
Remote (MySQL clients):
Host: mysql5.example-server.com
Port: 3307
When using "mysql5.example-server.com" as a MySQL Host, you need to enable "Remote Connections" for your MySQL user.(more info)
DB Master Username: example
You can manipulate your DBs with phpMyAdmin (log in)
Local (web applications):
Host: localhost
Socket: /tmp/mysql5.sock
Note: Most PHP applications/scripts will accept the following syntax:
MySQL Host: localhost:/tmp/mysql5.sock
Remote (MySQL clients):
Host: mysql5.example-server.com
Port: 3307
When using "mysql5.example-server.com" as a MySQL Host, you need to enable "Remote Connections" for your MySQL user.(more info)
DB Master Username: example
You can manipulate your DBs with phpMyAdmin (log in)
Databases
Create new database
MySQL users
| DB Name | MySQL User | Privileges | Remote Connections | Actions |
| example_forum | example | Master user | Enable remote | Delete |
| example_surebuilder | example | Master user | Enable remote | |
| example_surebuilder | sbexample | Create, Alter SP, Execute SP, Update, Delete, Show View, Lock, Create View, Drop, Create SP, Select, Alter, Insert | Delete | |
| example_tests | example | Master user | Disable remote | Delete |
| example_tests | testuser | Create, Update, Delete, Select, Insert | Enable remote | Delete |