SOLVED: remote mySQL login

cowen
Posts: 32
Joined: Fri Sep 20, 2013 9:32 am
Location: NRW - Germany

SOLVED: remote mySQL login

Postby cowen » Fri Sep 20, 2013 9:37 am

Hi Guys (sorry a Gals),

I have been running a small FreeNas server for a couple of years and decided it was time to play with something new and so I am not trying ubuntu and Amahi for the first time. My first encounter with ubuntu and so everything is 10 times harder than expected. But hey...

Anyway - I can see that mysql is installed and using Chive, I can create a schema and perform queries etc. I know the root password - all is OK.

So now I want to connect to the database from my desktop PC (e.g from a self made application or mysql workbench or whatever). The problem is, no matter what privileges I grant, the connection always gets rejected. Can you tell me is there a firewall in place or some security 'thing' stopping LAN connections to the database?

Posted this as a newbie. I hope this is OK.

Thanks

User avatar
bigfoot65
Project Manager
Posts: 11861
Joined: Mon May 25, 2009 4:31 pm

Re: remote mySQL login

Postby bigfoot65 » Fri Sep 20, 2013 9:59 am

Good chance the firewall is on your client. You will have to enable port 3306 access.
ßîgƒσστ65
Applications Manager

My HDA: Intel(R) Core(TM) i5-3570K CPU @ 3.40GHz on MSI board, 16GB RAM, 1TBx1+2TBx2+4TBx2

cowen
Posts: 32
Joined: Fri Sep 20, 2013 9:32 am
Location: NRW - Germany

Re: remote mySQL login

Postby cowen » Fri Sep 20, 2013 10:15 am

Hi,
Thanks but in this case definately not. My desktop PC's and work laptop all connect to work based databases and to the database on my FreeNAS server. There is definately something not configured, or firewalled or ????? at the Amahi server.

Having serached for hours, I am out of ideas.

User avatar
bigfoot65
Project Manager
Posts: 11861
Joined: Mon May 25, 2009 4:31 pm

Re: remote mySQL login

Postby bigfoot65 » Fri Sep 20, 2013 10:43 am

Firewall is disabled on the HDA. Keep in mind Amahi is a platform add on, so it does not administer any firewalls. That would be the resposibility of the OS. Might be worth searching the internet for the distribution or even checking MySQL web site.
ßîgƒσστ65
Applications Manager

My HDA: Intel(R) Core(TM) i5-3570K CPU @ 3.40GHz on MSI board, 16GB RAM, 1TBx1+2TBx2+4TBx2

cowen
Posts: 32
Joined: Fri Sep 20, 2013 9:32 am
Location: NRW - Germany

Re: remote mySQL login

Postby cowen » Fri Sep 20, 2013 1:24 pm

OK - This is solved.

I had initially tried Amahi 6 and was unable to open the mysql database for remote access. This was after searching cnf files and also granting privileges to the users. It just would not work.

So, I have now wiped the system and installed Amahi 7 from the express CD. This allowed remote access as soon as I granted the correct privileges to the user accounts. Simple clear and easy!!

This issue is solved from my perspective as I have a solution that I am happy with.


I have to say, I really do prefer Amahi 7. Headless, simple, fast. I like it. :-)

User avatar
bigfoot65
Project Manager
Posts: 11861
Joined: Mon May 25, 2009 4:31 pm

Re: SOLVED: remote mySQL login

Postby bigfoot65 » Fri Sep 20, 2013 1:52 pm

Glad it's working for ya. Amahi 7 is leaner and faster. Still have some tweaks to finish, but it appears to be working well.
ßîgƒσστ65
Applications Manager

My HDA: Intel(R) Core(TM) i5-3570K CPU @ 3.40GHz on MSI board, 16GB RAM, 1TBx1+2TBx2+4TBx2

trw3937
Posts: 23
Joined: Mon Jul 16, 2012 9:53 am

Re: SOLVED: remote mySQL login

Postby trw3937 » Tue Oct 01, 2013 10:58 am

SQL root access from the internet through port 3306 not a good idea. I'd setup ssh on an obscure port and allow public login with a non-root account with keys then drop to root after login to access sql as its root user. mysql root and server root are 2 different accounts just fyi.

cowen
Posts: 32
Joined: Fri Sep 20, 2013 9:32 am
Location: NRW - Germany

Re: SOLVED: remote mySQL login

Postby cowen » Thu Oct 03, 2013 11:14 am

HI,
I have no intention of doing remore access over the internet. My problem was on my local network only.

Cheers

Who is online

Users browsing this forum: No registered users and 4 guests