# on Ubuntu 16.04 LTS, edit /etc/mysql/mysql.conf.d/mysqld.cnf # bind-address = 127.0.0.1 --> bind-address = 0.0.0.0 # to allow remote access CREATE USER 'sotorrent'@'localhost' IDENTIFIED BY ''; CREATE USER 'sotorrent'@'%' IDENTIFIED BY ''; GRANT ALL PRIVILEGES ON sotorrent18_03.* TO 'sotorrent'@'localhost'; GRANT ALL PRIVILEGES ON sotorrent18_03.* TO 'sotorrent'@'%'; GRANT FILE ON *.* TO 'sotorrent'@'localhost'; GRANT FILE ON *.* TO 'sotorrent'@'%'; FLUSH PRIVILEGES;