Page Comparison

Platform

Create the database user

Oracle:

This command will prompt for the name of the user to be created.

sqlplus SYS/SYSPassword@SID as SYSDBA @install/oracle/create_user

Sql Server:

Before creating the database, ensure that default collation is Latin1_General_100_CI_AI_SC_ASUTF8

SELECT SERVERPROPERTY('collation');

If it is not, please talk to the database administrator to get this updated to the required collation (see also Install MS SQL Server).

This command creates a local (SQL Server) login, a user with required user mappings, sets the password for the login and creates the database.

sqlcmd -S localhost\myservice -i /install/sql_server/create_database_and_user.sql -v dbName="phixflow" dbLogin="phixflow" dbUser="phixflow" dbPassword="mypass"

Run the following command to confirm the collation setting is correct.

SELECT DATABASEPROPERTYEX('phixflow', 'Collation');

MySQL:

mysql --user=<myrootuser> --password

If you followed the suggested PhixFlow installation notes for installing MySQL, you will be using unix_socket authentication (see Install MySQL), and the command to log into the database as root is simply:

sudo mysql

Create the user, supplying the name of the database, the user and the password in the commands below:

create database phixflow CHARACTER SET = 'utf8mb4' COLLATE = 'utf8mb4_bin';
create user '<myuser>'@'%' identified by '<mypass>';
grant all privileges on phixflow.* to '<myuser>'@'%';
exit