Topic: sme 6.0u / php .... + mysql

[lagraula]

hello !
I installed a sme server+gateway with a dyndns connection.
I try to develop a dynamic web site with php and ... myusql.
With php : no problem ; but with mysql : I've got the message : "Access denied for user"

I made some corrections with sme :
-> error messages in apache are available
-> php is allowed "outside localnetworkingonly !"
-> a specific user in mysql have been created !

And it doesn't work !!!!

(((

[mrjhb3]

Is this what you are looking to do:  

MySQL accepts only local connections

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/esmith/config setprop mysqld LocalNetworkingOnly no
/sbin/esmith/expandtemplate /etc/my.cnf
/etc/rc.d/init.d/mysqld restart

I think the above is a typo, it should read something like if you wish to enable public access..  Here is the link I got this from.
http://no.longer.valid/phpwiki/index.php/SME%20Server%20Announce%20v6.0

JB

[hemps]

I did all that you said, there were some typo's in you instructions. I restarted mysql tried to connect from another machine ---> no go.

[hemps]

This is the error