Configure MariaDB / MySQL

Configure the database

Create the database:

From the command line run "mysql -u root -p"

ucontrol@ubuntu:~$ mysql -u root -p
Enter password: 
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 39
Server version: 10.2.13-0ubuntu0.12.04.1 (Ubuntu)


Copyright (c) 2000, 2013, Oracle and/or its affiliates. All
rights reserved.

Oracle is a registered trademark of Oracle Corporation
and/or its affiliates. Other names may be trademarks of their
respective owners.

Type 'help;' or '\h' for help. Type '\c' to clear the
current input statement.

Create the database instance tekwurx

mysql> create database TekWurx7;
Query OK, 1 row affected (0.00 sec)

Configure MYSQL / MariaDB from the CLI

The following default setting are used here :

Database Name : TekWurx7

Database user : tekwurx

Database user password : TekWurx1uControl

These however, can all be defined as required.

Login to mysql
```
mysql -u root -p
```
Using the root account created during install of MySQL, default root password is blank (Press enter)
Create the TekWurx Database
```
CREATE DATABASE TekWurx7;
```

Create and assign privileges to the tekwurx user for the TekWurx Schema

GRANT ALL ON TekWurx7.* TO tekwurx@'localhost' IDENTIFIED BY '<PASSWORD>';
GRANT ALL ON TekWurx7.* TO tekwurx@'%' IDENTIFIED BY '<PASSWORD>';

Logout of mysql
```
exit
```
Default password : TekWurx1uControl

uControl Documentation 7.0

Configure MariaDB / MySQL

Configure the database

Create the database:

Configure MYSQL / MariaDB from the CLI

Updates to the MySQL my.cnf file