Topic: OSCOMMERCE can't connect to mysql on '192.168.1.12' (111)

[davidebellei]

Hi
I have this problem installing oscommerce.
During installation it give this error
"can't connect to mysql (111)"
Reading previous posts, I found that I need to grant access to mysql from local netword, doing the following:

/sbin/e-smith/db configuration setprop mysqld LocalNetworkingOnly no
/sbin/e-smith/expand-template /etc/my.cnf
/sbin/service mysqld restart
Even after a complete restart of the server, I can't access mysql and always have errore "can't connect to mysql on '192.168.1.12' (111).

I'm running sme server 6 at 192.168.1.12
I'm trying to access the server from win2000 at 192.168.1.83 on local network

Can anyone help me?

Thank you!

[Boris]

In addition to allowing network access to mysql you need to create mysql-user@192.168.1.83 with appropriate permissions to database

[davidebellei]

Still not working...
Thank you for your advice.
I'm not sure I'm on the right way...

I manually created (phisically on mitel) database ecommerce and created sqluser@192.168.1.83 as following:

grant alter, select, insert, update, delete, index, create, drop on on ecommerce.* to sqluser@192.168.1.83 identified by 'password';

The error is the same "Can't connect to MySQL server on '192.168.1.12' (111)"

I also tried from dos prompt:

telnet 192.168.1.12 3306

but...able to connect to host.
Maybe something wrong on  enabling access to mysql on network? I did exactly the commands as in my previous post...

Can you help me? Thank you so much !
Davide

[davidebellei]

Wait wait!
I retyped commands to enable mysql over network. Now it works....
Ops, maybe I mistyperd it....

Now i'm having trouble with chmod.
How can i chmod a file via ftp to 706 or 777 as admin, if it says I have not the rights to do it?
550 permission denied?

[Boris]

you can not chmod via ftp as this feature disabled. Use ssh instead.

[davidebellei]

Thank you Boris, unfortunately I don't know how to do this......  

[Boris]

Welcome, unfortunately I don't have time or will to teach you the basics. You have to do some reading on your own.
Try WinSCP3 instead of FTP. It will let you change permissions and transfer files if you have rights on the server.

[davidebellei]

Thank you very much.
You gave me the... idea.
Now I will work and study on it.
Thanks again!
Davide