Topic: MySql outside the "Box"

[edlentz]

I can use PHPMyAdmin from within an Ibay on the SME box, but I can't get to Mysql with ODBC connector, or MySql Administrator from the network.  Is there a permission I need to change in SME?  I have created users in Mysql to allow this.
Thanks

[Henk]

I found this in the release notes of SME 6.0:


The mysql database daemon is configured by default to accept only
local connections (i.e. it is not accessible via the network).
This is a security precaution. We only use mysql for webmail
preferences, and only require access from localhost.

If you wish to enable local network access, you can do so via:

/sbin/e-smith/config setprop mysqld LocalNetworkingOnly no
/sbin/e-smith/expand-template /etc/my.cnf
/etc/rc.d/init.d/mysqld restart

[edlentz]

Thanks for the reply Henk.  I looked in the areas you suggested but didn't find what you referred to.  I did install version 7.0beta  Would that make a difference?

[juncool]

I can use PHPMyAdmin from within an Ibay on the SME box, but I can't get to Mysql with ODBC connector, or MySql Administrator from the network. Is there a permission I need to change in SME? I have created users in Mysql to allow this.

If you wish to enable local network access, you can do so via:

/sbin/e-smith/config setprop mysqld LocalNetworkingOnly no
/sbin/e-smith/expand-template /etc/my.cnf
/etc/rc.d/init.d/mysqld restart

after i have executed the above commands and granted privileges on a mysql user (e.g. grant all on somedb.* to someuser@192.168.1.2 identified by 'somepasswd' with grant option), i have successfully connected to mysql through odbc connector, assuming that your sme box has the ip address 192.168.1.1 and the pc you're using is 192.168.1.2, you can also connect using mysql administrator however mysql server 4.0 or higher is preferred to use. hope this would help.

- juncool

 

[edlentz]

DOH!!  Such a newbie I just didn't see what you were showing me!  Thanks for your help.