1 Topic by jdnielsendevelopment

  • jdnielsendevelopment
  • Member
  • Offline
  • Registered: 2023-02-03
  • Posts: 12

Topic: How to enable a remote user on mariadb/mysql after iredmail install

==== REQUIRED BASIC INFO OF YOUR IREDMAIL SERVER ====
- iRedMail version (check /etc/iredmail-release): 1.6.2 MariaDB Edition
- Deployed with iRedMail Easy or the downloadable installer? - downloadable installer
- Linux/BSD distribution name and version: Ubuntu 22.04 LTS
- Store mail accounts in which backend (LDAP/MySQL/PGSQL): MySQL
- Web server (Apache or Nginx): Nginx
- Manage mail accounts with iRedAdmin-Pro? No
- [IMPORTANT] Related original log or error message is required if you're experiencing an issue.
====

just wondering how i would configure remote access to this version of mariadb without screwing up the other softwares access to the databases

----

Spider Email Archiver: On-Premises, lightweight email archiving software developed by iRedMail team. Supports Amazon S3 compatible storage and custom branding.

2 Reply by Cthulhu

  • Cthulhu
  • Member
  • Offline
  • Registered: 2019-06-04
  • Posts: 907

Re: How to enable a remote user on mariadb/mysql after iredmail install

CREATE USER 'sqladmin'@'%' IDENTIFIED BY 'password';

GRANT ALL PRIVILEGES ON * . * TO 'sqladmin'@'%';

FLUSH PRIVILEGES;

open port 3306 in firewall

/etc/mysql/mariadb.conf.d/50-server.cnf

bind-address            = 0.0.0.0

service mysql restart


https://www.heidisql.com/

Create a new connection, login

3 Reply by ZhangHuangbin

  • ZhangHuangbin
  • ZhangHuangbin
  • iRedMail Developers
  • Offline
  • Registered: 2009-05-06
  • Posts: 31,082

Re: How to enable a remote user on mariadb/mysql after iredmail install

Why do you need to access MariaDB server remotely?

4 Reply by jdnielsendevelopment

  • jdnielsendevelopment
  • Member
  • Offline
  • Registered: 2023-02-03
  • Posts: 12

Re: How to enable a remote user on mariadb/mysql after iredmail install

ZhangHuangbin wrote:

Why do you need to access MariaDB server remotely?

I want to build a remote GUI where I can add a user - would need to send the querey into MariaDB remotely I believe. I am also new at this so if there is an easier way to do this please let me know!

5 Reply by jdnielsendevelopment

  • jdnielsendevelopment
  • Member
  • Offline
  • Registered: 2023-02-03
  • Posts: 12

Re: How to enable a remote user on mariadb/mysql after iredmail install

Cthulhu wrote:

CREATE USER 'sqladmin'@'%' IDENTIFIED BY 'password';

GRANT ALL PRIVILEGES ON * . * TO 'sqladmin'@'%';

FLUSH PRIVILEGES;

open port 3306 in firewall

/etc/mysql/mariadb.conf.d/50-server.cnf

bind-address            = 0.0.0.0

service mysql restart




Create a new connection, login

Any idea why this wouldnt work? I double checked that 3306 is open and mysql is listening on that port. Unsure where Im going wrong

6 Reply by jdnielsendevelopment

  • jdnielsendevelopment
  • Member
  • Offline
  • Registered: 2023-02-03
  • Posts: 12

Re: How to enable a remote user on mariadb/mysql after iredmail install

Side note: I used telnet ip-address 3306 and the connection opened fine - maybe something further in the config settings?