...
Creating the database user is heavily 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 @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" |
|
MySQL:MariaDB: | | Anchor |
|---|
| mariaDBexampleDBcreateCommand |
|---|
| mariaDBexampleDBcreateCommand |
|---|
|
Connect to the database as root (or an administrator): | 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 CHARACTER SET = 'utf8' COLLATE = 'utf8_bin';
grant all privileges on phixflow.* to '<myuser>'@'%' identified by '<mypass>';
exit |
|
...