Topic: MySQL remote access on SME 7pre3 Question

[Mjohnson]

Is this still the correct command for allowing remote access to MySQL db's??

/sbin/e-smith/config setprop mysqld LocalNetworkingOnly no


Thanks

MJ

[Mjohnson]

This did not work:

config setprop mysqld LocalNetworkingOnly no
signal-event post-upgrade
signal-event reboot



Any thoughts??

[Mjohnson]

This did not work:

config set mysqld service access public status enabled TCPPort 3306
signal-event remoteaccess-update


Still no ideas folks...

[Mjohnson]

No sir, I was wrong.  The last attempt was the charm.  I added a signal-event reboot to the end and all was better.

So here it is to allow remote access to MySQL under 7pre3:

config set mysqld service access public status enabled TCPPort 3306
signal-event remoteaccess-update
signal-event reboot

[dswillia]

Following the above directions, the mysql server is still not listening on 3306.  I am trying to install software that utilizes a mysql backend using a jdbc java connector.  I have enabled it with the above commands, did a reboot via signal-event and still nothing.  I really only need it to listen on 127.0.0.1 or the local ip address 192.168.0.1, I don't really care to open mysql to the outside interface.  

Regards

[Mjohnson]

I used the above proceedure to allow access to MySQL from a remote computer.  

It sounds like you are having problems accessing from your local machine.

I am not familar with the application you reference, but can you confirm access to mysql via a command line or perhaps phpmyadmin??

Have you reviewed the log files?  

Port 3306 is a standard MySql port, is that consistent with your application?

[CharlieBrady]

Following the above directions, the mysql server is still not listening on 3306.  

This:

Code: [Select]


config setprop mysqld LocalNetworkingOnly no
signal-event post-upgrade
signal-event reboot


is required to reconfigure mysql to listen to port 3306 - it will only be accessible to clients on the local network. You will also need to set up mysql access lists.

The other instructions (the ones which you have followed) are required to give remote access to mysql. You probably don't want to do that. You should undo those changes by doing:

config setprop mysqld access private

before making the other change.

[LeoM]

Hi all,

Can anyone give me an example how to connect to a remote MySql database.

I need someone to give access to the database of my e-shop from outside my local network.

Also; what is the set-up in MySql, do I need to create a special user for this?

By "Googling around", and reading the above, I did some tests, but with none of them I could reach the database on my remote server (SME 6.01-0.1)

Regards,

Leo.

[silasp]

Yeah, me too.

I've tried the following:

Code: [Select]


config setprop mysqld LocalNetworkingOnly no
signal-event post-upgrade
signal-event reboot
config set mysqld service access public status enabled TCPPort 3306
signal-event remoteaccess-update
signal-event reboot


From the local shell, the following connects
telnet localhost 3306

From a remote shell, the following times out
telnet myhost.com 3306

What else do I have to do to enable remote access to mysql?

Cheers,
Silas

[mmccarn]

Do you need to create a 'port forwarding' rule to forward TCP traffic on port 3306 to port 3306 on localhost?

(or, you could use the firewall to put your sql server on a different port - to avoid simple port scanning attacks...)

[silasp]

Thanks mmcarn. Forwarding another port worked a treat.

The only other thing I needed to do to get it to work was to set the server to use old passwords as per this page:
http://dev.mysql.com/doc/refman/5.0/en/old-client.html

Cheers,
Silas

[georgelee]

I tried to execute the command below to access to mysql server locally or remotely and all fail.

Execute:
telnet localhost 3306          /             telnet 192.168.1.189 3306
And I got:
telnet: connect to address 127.0.0.1: Connection refused.

Please help!

[jameswilson]

Hi all
I'm looking at doing the above but I'm a little concerned, just to open mysql to the world.
I run a web shop on my server and need remote mysql access for a lttle vb.net apo I have developed. Obviously this works great on the local network, and if I opened it up then I'd be able to remotly too, but as above I'm sure it was disabled for a very good reason. Can I restrict it to the 2 ip's that nned access, is mysql host security enough, any basic best practices I should be looking into to keep my superb sme as reliable and secure as it has been

Many Thanks Guys
James

[william_syd]

Do you allow any other remote administration to your SMEServer? SSH?

[jameswilson]

Do you allow any other remote administration to your SMEServer? SSH?

no i prefer to only open them up when needed. I have temp setup a port forward on 3306 as this works but i have only done this for testing and have since removed the forward.

If i open sh i assume i disable root login, and stop it accepting passwords and only use certs?