Versions Compared

Version Old Version 28 New Version Current
Changes made by

Zoe Baldwin

Samuel Kirby

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

Creating the database user is dependent on the database platform, and will often have to be varied to meet local requirements regarding naming and security. These example commands will be adequate basic installations.

Platform

Create the database user

Oracle:

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

Code Block
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_

AS

UTF8

Code Block
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.

Code Block
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.

Code Block
SELECT DATABASEPROPERTYEX('
DBNAME
phixflow', 'Collation');

MySQL:

Anchor
MariaDB-database-creation
MariaDB-database-creation
Connect to the database as root (or an administrator):

Code Block
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:

Code Block
sudo mysql

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

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

SQL Server:

...

If a database, with login details, was provided (i.e. you did not perform the step above for creating the login, user and database), please check that the database has the correct collation:

E.g.

...