1 Topic by madssigvert

  • madssigvert
  • Member
  • Offline
  • Registered: 2014-03-27
  • Posts: 36

Topic: mysql acces from remote server

==== Required information ====
- iRedMail version: 0.3
- Store mail accounts in which backend (LDAP/MySQL/PGSQL): MySQL
- Linux/BSD distribution name and version: Ubuntu
- Related log if you're reporting an issue:
====

Hello

Can any tell me know i enable acces to the mysql on a iredmail server from remote machines?

also how would you "move" from a mysql running on the webhost, to a remote mysql ? would it be as simple as dump the database, load it into another mysql server ?

----

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

2 Reply by ZhangHuangbin

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

Re: mysql acces from remote server

madssigvert wrote:

Can any tell me know i enable acces to the mysql on a iredmail server from remote machines?

Unblock port 3306 in iptables on iRedMail server, then it should be fine.

madssigvert wrote:

also how would you "move" from a mysql running on the webhost, to a remote mysql ? would it be as simple as dump the database, load it into another mysql server ?

Reference: http://www.iredmail.org/docs/migrate.to … erver.html

3 Reply by madssigvert

  • madssigvert
  • Member
  • Offline
  • Registered: 2014-03-27
  • Posts: 36

Re: mysql acces from remote server

Thank you!

when i try to allow remote acces to root (yes i know security risk, but i only opned it on my ip) i cant seem to make it grant remote acces, i tryed everything google turned up, any idea on why it wont grant me any acces?

mysql> SELECT host FROM mysql.user WHERE User = 'root';
+-----------------+
| host            |
+-----------------+
| %               |
| 127.0.0.1       |
| 54.247.159.146  |
| ::1             |
| ip-10-35-171-44 |
| localhost       |
+-----------------+

the mysql bind adress is removed. What do i need to change to open up for acces?

4 Reply by ZhangHuangbin

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

Re: mysql acces from remote server

*) Do you have port 3306 open in iptables and your network router?
*) Does remote connection timed out or report incorrect password?