Skip to main content

MySQL

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

Steps to setup MySQL server:

To install it, update the package index on your server with apt:
```
sudo apt update
```
Then install the default package:
```
sudo apt install mysql-server
```
Open the mysql shell:
```
sudo mysql
```

Now in the MySQL shell, let's create a new user:

mysql> CREATE USER 'tdms_user'@'%' IDENTIFIED BY 'yoursupersecretpassword';

Now log in to MySQL shell as the new user:
```
mysql -u tdms_user -p
```
Create a new database:
```
mysql> CREATE DATABASE mydb;
```
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.

Steps to setup MySQL server:
Setting up your MySQL storage on CloudTDMS