How to create database in Siteworx Print

  • 38

How to create a database in siteworx

With Sitworx UI you have full control over the creation of your database and user access when using our PHP or Java hosting.

Please note: You cannot create and manage users via shell. You must use Siteworx

Login to your control panel at

Click Hosting features >> MySql >> Databases

In the page that opens, enter the database name, check the box to Create User, and click Add as shown below

Important: Option “when connecting from” can be any of the below

  1. Use localhost if your web application and database is on the same server. This is the most common and secure option.
  2. IP, say if you need to limit remote access to your database from that IP.
  3. Use the percent symbol % if you need to allow remote access from anywhere (this is not recommended).

Heres another screenshot of setting user permissions.
Screenshot of user permissions

If you already have a user setup for the database, you can simply add an existing user but clicking on [Manage Users] link after the database has been created.
Shows screenshot of manage users in siteworx

After you have created your database and assigned a user, you can use PHPMyAdmin to import data or create tables.

You may also manage your database via shell after you have created the database and user. Such as importing database SQL file, mysqldump, or simply connecting and browsing your database if data exists.

Database  and Database User Names

When setting up your database and database user, the system will add your account username as a prefix. This is to insure your database name and database user is unique on the server. For example, will have a username javapipe for the hosting account, and any user you add such as 'john' your database username will then be 'javapipe_john'. This is the same with the database name. For example, if you name the database 'wp' for Wordpress then the database name would be 'javapipe_wp'. 

Please Note: 'root' is a reserved word so you cannot use this in your database name or username. For example, something_root will fail to connect.


Was this answer helpful?

« Back