Skip to main content

MySQL

We will be using an ubuntu/debain machine to setup a MySQL server.

Steps to setup MySQL server:

  1. To install it, update the package index on your server with apt:
    sudo apt update
  2. Then install the default package:
    sudo apt install mysql-server
  3. Open the mysql shell:
    sudo mysql
  4. Now in the MySQL shell, let's create a new user:
    mysql> CREATE USER 'tdms_user'@'%' IDENTIFIED BY 'yoursupersecretpassword';
  5. Now log in to MySQL shell as the new user:
    mysql -u tdms_user -p
  6. Create a new database:
    mysql> CREATE DATABASE mydb;
  7. Allow remote connections to your MySQL server:
    • Open the file located at /etc/mysql/mysql.conf.d/mysqld.cnf
    • Change the following lines:
      bind-address = 127.0.0.1
      to
      bind-address = 0.0.0.0
    • Restart mysql service:
      sudo service mysql restart

Setting up your MySQL storage on CloudTDMS

Open the storages tab and insert the following values for your new MySQL storage

  • Name: Name for the storage.
  • Hostname: Domain Name or IPv4 address of your MySQL server.
  • Port: The port on which your MySQL server is listening for connections (default is 3306).
  • Username: Username of your MySQL server.
  • Password: Password of your MySQL user.
  • Database: The database name.