Versions Compared

Key

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

...

  1. You should set the FD_ADMIN password before running the scripts.
  2. Open the file /database/mysql/install/scripts/CreateFD.sql
  3. Edit the line: CREATE USER 'FD_ADMIN'@'%' IDENTIFIED BY 'welcome1' so that it has a new password in it.
  4. Open a command prompt or putty window to the /database/mysql/install folder from extracted zip, launch mysql (use full path if not available on PATH environment)
  5. Run using a username with privileges to login from the host that you are running the commands from and to create users and objects.
  6. Change the bold text as needed in your environment.
  7. Run the appropriate command below.

...

Linux

  • /path/to/mysql -u username -h hostname --port=3306 -p < CreateFlexDeploySchemas.sql > mysqlDDL.txt

...

Windows

  • "C:\path to\mysql" -u username -h hostname --port=3306 -p < CreateFlexDeploySchemas.sql > mysqlDDL.txt

Type the password when asked.

...

The creation will take a few moments. Then you are ready to connect your datasource to the database.

Tip

You should record the FD_ADMIN password

...

, which you modified in CreateSchemas.sql file.