NAME

ncid-mysql-setup

SYNOPSIS

ncid-setup mysql <authentication>

DESCRIPTION

The ncid-mysql-setup script initializes the MySQL or MariaDB database, table and user that is required for the ncid-mysql output module. All existing data will be erased.

The ncid-mysql-setup script uses the ncid-mysql.conf file for the database configuration.

You do not execute ncid-mysql-setup directly. Instead, you launch it as follows:

ncid-setup mysql <authentication>

ARGUMENTS

<authentication>

Represents a string of options passed directly to the mysql command line client (it is called mysql for both MySQL and MariaDB).

It must specify a user and password (if needed) that has MySQL or MariaDB administrative privileges.

This is usually a MySQL or MariaDB user called 'root'. It is not the same as the 'root' login for this machine.

Typically you would type:

ncid-setup mysql -u root
or: ncid-setup mysql -u root -p<password>
or: ncid-setup mysql -u root --password=<password>

If a password is required for the administrative login, you must specify it on the command line.

REQUIREMENTS

Network access to a MySQL or MariaDB database server.

The MySQL or MariaDB command line client 'mysql'.

Configured ncid-mysql.conf file.

FILES