6.2. Creating a database

You need to create a database with the appropriate user, password, and user privileges. Please follow the sample script below, adapting to your server operating conditions.

  • Execute the mysql command line. In the command below, you may change root to some other mysql username with sufficient privileges.

    $ mysql -u root -p

  • In the mysql command line, create a database. Substitute your_database with the desired name of your database.

    mysql> create database your_database;

  • Create a database user. ProsePoint will act as this username for accessing the database. Substitute your_database, your_username and your_password with the desired values.

    mysql> GRANT SELECT, INSERT, UPDATE, DELETE, CREATE, DROP, INDEX, ALTER, CREATE TEMPORARY TABLES, LOCK TABLES ON your_database.* TO 'your_username'@'localhost' IDENTIFIED BY 'your_password';

    Please do not forget the single quotes nor the semicolon.

  • Refresh database privileges and quit out of the mysql command line.

    mysql> flush privileges;

    mysql> \q