external database access / mysql
external database access / mysql
Hi,
What are the steps to make external database (mysql) access?
Also, I tried to create a rule into Firewall, and there's no "Save" button? When I go back into that screen, the rule is gone.
What are the steps to make external database (mysql) access?
Also, I tried to create a rule into Firewall, and there's no "Save" button? When I go back into that screen, the rule is gone.
Re: external database access / mysql
Oh I found the save button now. But still can't enable remote access.
Re: external database access / mysql
Anyone? How do you guys connect mysql using external connection (like MySQL Workbench for example). Which steps should I make to make this external connection work?
Re: external database access / mysql
There's a configuration option for this within KeyHelp. I'm using the German version, but it should be something like Configuration > System > Database Server. The first option there allows external access.
It would be more secure to use an SSH tunnel, though. Several programs have this feature built-in; Navicat is a nice one, for example, but it's not free. You can use free tools like PuTTY to create a tunnel and then use any program with it.
Cheers,
Jan
It would be more secure to use an SSH tunnel, though. Several programs have this feature built-in; Navicat is a nice one, for example, but it's not free. You can use free tools like PuTTY to create a tunnel and then use any program with it.
Cheers,
Jan
This message has been ROT-13 encrypted twice for higher security.
Re: external database access / mysql
Hi,
Thanks for answer. I've done this Configuration > System - Database Server > [X] Enabled Allow remote access, and also allow port on Firewall.
It doesn't work. I would need to connect without tunnel for an external server application that connects to this server's database.
Anything else should need to activate maybe?
Thanks for answer. I've done this Configuration > System - Database Server > [X] Enabled Allow remote access, and also allow port on Firewall.
It doesn't work. I would need to connect without tunnel for an external server application that connects to this server's database.
Anything else should need to activate maybe?
Re: external database access / mysql
Hello,
there is also a third step needed: Within the setting of the specific database you must allow connections from your external host.
there is also a third step needed: Within the setting of the specific database you must allow connections from your external host.
Viele Grüße,
Martin
Martin
Re: external database access / mysql
Hi Martin,
Thanks for answer. Wouldn't work the rule that I've made for any remote connection? Or did I made it wrong maybe?
Could you explain how can I make this rule exactly?
Really grateful.
Re: external database access / mysql
@tom83
I see a red box above your ACCEPT rule in your screenshot. It seems that your REJECT rule is above the MariaDB/MySQL rule, which leads to a rejection before it can be accepted by the MariaDB/MySQL rule. See the screenshot below for a correct order.
---
Summary of all required steps for admins looking for the same information in the future.
1. Step:
Enable MariaDB/MySQL to listen on the appropriate port.
"Configuration" -> "Database server" -> "Allow remote access"
2. Step:
Enable the appropriate user to be able to use a remote connection.
"User-Administration" -> "Add user" / "Edit user" -> Tab "Resource & permissions" -> Scroll down to "Database remote access"
3. Step
Depending on your current Firewall rules this may be optional. Open the MariaDB/MySQL port in the firewall settings.
4. Step
Within the user area of the user, who should be able to use remote database access, enable access to the appropriate database.
"Databases" -> "Add database" / "Edit database" -> "Remote access" and choose the desired option.
I see a red box above your ACCEPT rule in your screenshot. It seems that your REJECT rule is above the MariaDB/MySQL rule, which leads to a rejection before it can be accepted by the MariaDB/MySQL rule. See the screenshot below for a correct order.
---
Summary of all required steps for admins looking for the same information in the future.
1. Step:
Enable MariaDB/MySQL to listen on the appropriate port.
"Configuration" -> "Database server" -> "Allow remote access"
2. Step:
Enable the appropriate user to be able to use a remote connection.
"User-Administration" -> "Add user" / "Edit user" -> Tab "Resource & permissions" -> Scroll down to "Database remote access"
3. Step
Depending on your current Firewall rules this may be optional. Open the MariaDB/MySQL port in the firewall settings.
4. Step
Within the user area of the user, who should be able to use remote database access, enable access to the appropriate database.
"Databases" -> "Add database" / "Edit database" -> "Remote access" and choose the desired option.
Mit freundlichen Grüßen / Best regards
Alexander Mahr
**************************************************************
Keyweb AG - Die Hosting Marke
Neuwerkstr. 45/46, 99084 Erfurt / Germany
http://www.keyweb.de - http://www.keyhelp.de
**************************************************************
Alexander Mahr
**************************************************************
Keyweb AG - Die Hosting Marke
Neuwerkstr. 45/46, 99084 Erfurt / Germany
http://www.keyweb.de - http://www.keyhelp.de
**************************************************************
Re: external database access / mysql
Hi,
Thanks for all steps! I've made all those again, and I've changed the order (on firewall) like you said:
ps.: I didn't know that the order on firewall rules would matter.... and it does.
Thank you!
Thanks for all steps! I've made all those again, and I've changed the order (on firewall) like you said:
And WORKED fine now.I see a red box above your ACCEPT rule in your screenshot. It seems that your REJECT rule is above the MariaDB/MySQL rule, which leads to a rejection before it can be accepted by the MariaDB/MySQL rule. See the screenshot below for a correct order.
ps.: I didn't know that the order on firewall rules would matter.... and it does.
Thank you!