Want to setup your own IP for hosting your own data on the StatsDrone app?

Follow these instructions on getting started. If you run into any 

  1. Install an Ubuntu server and open its terminal.
  2. Install the OpenSSH package on the server:
    sudo apt-get install openssh-server
    sudo systemctl enable ssh
    sudo systemctl start ssh
  3. Install the MySQL client on the server:
    sudo apt update
    sudo apt install mysql-server
    sudo systemctl start mysql.service
  4. Create a new database:
    sudo mysql
    CREATE DATABASE YourDatabaseName;
  5. Check that your database has been created:
    SHOW DATABASES;
  6. Create a new MySQL user that can access your database from the StatsDrone server:
    CREATE USER ‘YourUser’@’143.110.218.77’ IDENTIFIED BY ‘YourPassword’;
    GRANT ALL PRIVILEGES ON YourDatabaseName.* TO ‘YourUser’@’143.110.218.77’;
    ALTER USER ‘YourUser’@’143.110.218.77’ IDENTIFIED WITH mysql_native_password BY ‘YourPassword’;
    FLUSH PRIVILEGES;
    \quit
    sudo systemctl restart mysql;
  7. Check that your user has been created with the necessary permissions:
    sudo mysql
    SELECT user,host,account_locked,password_expired FROM mysql.user;
    SHOW GRANTS FOR ‘YourUser’@’143.110.218.77’;
    \quit
  8. Allow remote access to your database server:
    sudo nano /etc/mysql/mysql.conf.d/mysqld.cnf
    Edit the file, change the bind-address from 127.0.0.1 to 0.0.0.0 and save the changes.
    sudo ufw allow from 143.110.218.77 to any port 3306
    sudo systemctl restart mysql;
  9. Login the StatsDrone app with your account, go to the Settings page, open the Self-hosting settings menu and enter your: Ubuntu server IP address; your MySQL database name; your MySQL username; your MySQL password.

Need more tech help?

You can always ask for tech help inside the app in the chat button.