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
rootto some other mysql username with sufficient privileges.$ mysql -uroot-p -
In the mysql command line, create a database. Substitute
your_databasewith the desired name of your database.mysql> create databaseyour_database; -
Create a database user. ProsePoint will act as this username for accessing the database. Substitute
your_database,your_usernameandyour_passwordwith the desired values.mysql> GRANT SELECT, INSERT, UPDATE, DELETE, CREATE, DROP, INDEX, ALTER, CREATE TEMPORARY TABLES, LOCK TABLES ONyour_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
