Connect to MariaDB (remote access)

RedBanza

How to remotely connect to my database?

I use Flarum with MariaDB and GUI Client - HeidiSQL.

I open port 3306 in firewall and add this line bind-address = 0.0.0.0 to /etc/mysql/my.cnf, but can't connected.

root@host:~# netstat -ant | grep 3306
tcp        0      0 0.0.0.0:3306            0.0.0.0:*               LISTEN

My config.php on Flarum

 'database' => 
  array (
    'driver' => 'mysql',
    'host' => 'localhost',
    'port' => 3306,
    'database' => 'localhostdb',
    'username' => 'reduser',
    'password' => 'qwerty12345',
    'charset' => 'utf8mb4',
    'collation' => 'utf8mb4_unicode_ci',
    'prefix' => '',
    'strict' => false,
    'engine' => 'InnoDB',
    'prefix_indexes' => true,
  ),

Maybe someone has experience remote work with the database of the forum and will tell me what the problem is or maybe I need another client? Sorry for the stupid question

luceos

RedBanza the host entry needs to point to the IP of your remote server. Eg:

'host' => '123.456.0.0',

RedBanza

luceos

Thank you! It's help me with add new user to MariaDB with remote access:

CREATE USER 'user'@'%' IDENTIFIED BY 'password123';
GRANT ALL PRIVILEGES ON *.* TO 'user'@'%'
WITH GRANT OPTION;