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 https://domain.com:2443/siteworx/
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
- Use localhost if your web application and database is on the same server. This is the most common and secure option.
- IP, say 11.22.33.44 if you need to limit remote access to your database from that IP.
- Use the percent symbol % if you need to allow remote access from anywhere (this is not recommended).
Heres another screenshot of setting 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.
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, javapipe.com 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.
