Preparation of MySQL database

A correctly configured MySQL database should be running on your system. For MySQL specific installation and configuration issues, visit the Web Site of MySQL for any help, as this falls outside the scope of this document.

To create the database in MySQL, logon to mysql client as the database administrator user (by default is this user root) and type:

$ mysql -h localhost -u root -p mysql

The database can then be created as follows:

mysql> CREATE DATABASE netadm;

If this step went OK, you will see a result as follows:

Query OK, 1 row affected (0.06 sec)

The user can then be created as follows:

mysql> GRANT ALL ON netadm.* TO 'prolinga'@'localhost';

In this example setup the user is given all privileges for the netadm database. In production environments, stricter security measures should probably apply.