How to Create Databases - WSP

<p>WebsitePanel allows you to create two types of databases.&nbsp;This article will cover how to create a database, database user, and how to assign a database user to a&nbsp;<strong>SQL Server 2012</strong>&nbsp;and&nbsp;<strong>MySQL 5.x</strong>&nbsp;database.</p>

<ul>
	<li><a href="#createdb">Create a Database</a></li>
	<li><a href="#createuser">Create a Database User</a></li>
</ul>

<h3><strong><a id="createdb"></a>Creating a Database</strong></h3>

<p>To create a database:</p>

<ol>
	<li>Log into your WebsitePanel Hosting Space.</li>
	<li>Mouseover Databases and select&nbsp;<strong>SQL Server 2012</strong>&nbsp;or&nbsp;<strong>MySQL 5.x</strong>.
	<p><img alt="Hosting Spaces Database MySQL" class="img-responsive" src="https://content.arvixe.com/arvixe/img/hosting-spaces-databases-mysql.png" style="max-width: 100%;" /></p>
	</li>
	<li>Click&nbsp;<strong>Create Database</strong>.
	<p><img alt="Create Database" class="img-responsive" src="https://content.arvixe.com/arvixe/img/hosting-spaces-databases-create-database.png" style="max-width: 100%;" /></p>
	</li>
	<li>Enter a name for your database.
	<p><img alt="Create Database Properties" class="img-responsive" src="https://content.arvixe.com/arvixe/img/hosting-spaces-databases-sql-database-properties.png" style="max-width: 100%;" /></p>
	</li>
	<li>Click&nbsp;<strong>Save.</strong></li>
</ol>

<h3><strong><a id="createuser"></a>Create a Database User</strong></h3>

<p>To access a database you must create a database user to connect to it with. If a user was not created when the database was created or if you would like to create an additional user, please do the following:</p>

<ol>
	<li>Log into your WebsitePanel Hosting Space.</li>
	<li>Mouseover Databases and select&nbsp;<strong>SQL Server 2012</strong>&nbsp;or&nbsp;<strong>MySQL 5.x</strong>.
	<p><img alt="Hosting Spaces Database MySQL" class="img-responsive" src="https://content.arvixe.com/arvixe/img/hosting-spaces-databases-mysql.png" style="max-width: 100%;" /></p>
	</li>
	<li>Click&nbsp;<strong>Create User</strong>.
	<p><img alt="Create User" class="img-responsive" src="https://content.arvixe.com/arvixe/img/hosting-spaces-databases-create-user.png" style="max-width: 100%;" /></p>
	</li>
	<li>Provide the following:
	<ul>
		<li>Username: Create a database username.</li>
		<li>Password: Create a password for the database user name.
		<p><img alt="Create User Properties" class="img-responsive" src="https://content.arvixe.com/arvixe/img/hosting-spaces-databases-sql-user-properties.png" style="max-width: 100%;" /></p>
		</li>
	</ul>
	</li>
	<li>Using the checkboxes under&nbsp;<strong>Databases</strong>, select a database(s) to assign to the user name.</li>
	<li>Click&nbsp;<strong>Save</strong>&nbsp;to create and assign the user to a database.</li>
</ol>