Create an empty database for SoftSlate Commerce to use in MySQL, Microsoft SQL Server 2000, PostgreSQL, or Oracle.
It is possible to install SoftSlate Commerce in an existing database. All of the
database tables used by SoftSlate Commerce begin with the prefix
Example 1.1. Creating an Empty Database in MySQL
To, create an empty database in MySQL, log into the MySQL monitor:
mysql -u root -p
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.
create database softslate;
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):
create database softslate
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: