SoftSlate Commerce - Java Shopping Cart - Create an Empty Database

Create an Empty Database

Create an empty database for SoftSlate Commerce to use in MySQL, Microsoft SQL Server 2000, PostgreSQL, or Oracle.

	Note
	It is possible to install SoftSlate Commerce in an existing database. All of the database tables used by SoftSlate Commerce begin with the prefix `ssc`. If your existing database has no tables that would conflict, you can use it. This may be advantageous in situations where you need to integrate SoftSlate Commerce with other applications.

Example 1.1. Creating an Empty Database in MySQL

To, create an empty database in MySQL, log into the MySQL monitor:


[root@server root]# mysql -u root -p
Enter password:

Run the create database command. (You may name the database whatever you wish. You will be asked for the name by the Installer tool.)


Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 978 to server version: 3.23.58

Type 'help;' or '\h' for help. Type '\c' to clear the buffer.

mysql>create database softslate;

If you wish to use the InnoDB engine as the table type in order to support transactions and foreign key constraints, you must update the MySQL table_type system variable before running the installer.
```
mysql>SET GLOBAL table_type=innodb;
							
```

Example 1.2. Creating an Empty Database in Microsoft SQL Server

You can use the following script to create a database in Microsoft's Query Analyzer application (or a modified form of this script):


USE master
GO
create database softslate
on 
( 
	name='DATA_softslate',
	filename='C:\Program Files\Microsoft SQL Server\MSSQL\Data\DATA_softslate.mdf',
	size=2,
	filegrowth=10% 
)
log on
(
	name='XLOG_softslate',
	filename='C:\Program Files\Microsoft SQL Server\MSSQL\Data\XLOG_softslate.ldf',
	size=1,
	filegrowth=10%
)
GO

Important

	Important
It's often wise to create a separate database user for each application handled by your database. For example, these commands in MySQL will create a user who only has access to the database and nothing else: mysql>*`grant all privileges on softslate. to 'myuser'@'%' identified by 'mypassword';` mysql>`grant all privileges on softslate.* to 'myuser'@'localhost' identified by 'mypassword';`**

It's often wise to create a separate database user for each application handled by your database. For example, these commands in MySQL will create a user who only has access to the database and nothing else:


mysql>grant all privileges on softslate.* to 'myuser'@'%' identified by 'mypassword';
mysql>grant all privileges on softslate.* to 'myuser'@'localhost' identified by 'mypassword';

SoftSlate Commerce - User Guide
Prev	Chapter 1. Installing SoftSlate Commerce	Next

Prev	Up	Next
Download SoftSlate Commerce	Home	Upload and Deploy SoftSlate Commerce