Topic: remote mysqld

[grosbedos]

hi,

i'have a sme server. Another pc on my network has a web server and that pc must 'talk' with the mysql server of my sme.

(:p i'm french...lol)

i've read on the forum :

Code: [Select]


[root@sme root]# /sbin/e-smith/db configuration setprop mysqld LocalNetworkingOnly no

[root@sme root]# /sbin/e-smith/expand-template /etc/my.cnf

[root@sme root]# /sbin/service mysqld restart


Ok, i have do that..but it didn't work for me.

in my /etc/my.cnf .. i haven't "skip-networking"..but it didn't work..

i must tell you that i use mysql 4.0 (install by the update script of contribs..)

it's the only log usefull (/var/log/mysqld.log) :
"""Warning: Asked for 196608 thread stack, but got 126976"""

when i want to connect to the mysql server the error return is :
Host 'post.domain.com' is not allowed to connect to this MySQL Server

if you have an idea...i'm open ^^

thanks

[letouriste]

Hello;


Try with PHPMyAdmin to check he config

[grosbedos]

thanks for the tips,
with the good privileges it's work great