Versions Compared

Old Version 59

changes.mady.by.user Dominic Sandhu (Unlicensed)

Saved on

compared with

New Version 60

changes.mady.by.user Dominic Sandhu (Unlicensed)

Saved on

Key

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

...

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 @schema/oracle/install/create_user

Sql Server:

This command requires the user, the password, the login and the database to be provided as parameters.

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

If you are installing PhixFlow on SQLServer locally and you have followed the standard installation process above, then no Server Specification (the '-S' modifier on the SQLCMD) is required

MySQL:

Start a session the database:

Code Block
mysql --user=myrootuser --password

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

Code Block
create database phixflow;
grant all privileges on phixflow.* to 'myuser'@'%' identified by 'mypass';
exit

...