Creating a database user

pSysmon uses a database to manage all the data. To use pSysmon you have to have a database server running. See Requirements for more information.

To interact with the database server, pSysmon needs a dedicated database user. For this database user, a pSysmon database named psysmon_USERNAME will be created. This database will be used to create the database tables for each project which the user creates. To create a database user, you have to know the root (administrator) password of the database server.

To create a database user select the menu Edit → Create DB user. This will open a dialog window in which you have to enter the following values:

?? root user:: The name of the database user with root privileges.!!
?? root pwd:: The password of the root user.!!
?? mysql host:: The IP address or URL of the computer on which the database server is running. You can use //localhost// if the server is running on your local computer.!!
?? username:: The name of the pSysmon database user which should be created.!!
?? user pwd:: The password of the pSysmon database user. Leave empty if no password should be used.!!

The dialog window for creating the database user stefan with no password on the database server running on the local computer looks like this:

Enter the values of your choice and confirm by clicking the OK button.

If everything runs without an error, the database user USERNAME and the database psysmon_USERNAME (e.g. stefan and psysmon_stefan, respectively) has been created in your mysql database.

Checking the database user

You can check if the database user and the database has been created using the mysql commandline client:

user@computer $ mysql -u USERNAME -p

In the mysql command prompt check if the database has been created:

mysql> show databases;

For the example above (username: stefan) the show databases command should include the psysmon_stefan database:

mysql> show databases;
+--------------------+
| Database           |
+--------------------+
| information_schema |
| psysmon_stefan     |
| test               |
+--------------------+
3 rows in set (0.00 sec)