Topic: From Windows XP connect to SME Mysql database

[cosy]

Hi All,

   Wanna connect to mysql database from my laptop runing windows xp i try following on SME server logon as a root but no luck

GRANT ALL PRIVILEGES ON osCommerce.*
            TO osCommerce@'192.168.96.%' IDENTIFIED BY
            "CommerceAdmin" WITH GRANT OPTION;
Query OK, 0 rows affected (0.12 sec)

Error when creating DSN

[MySQL][ODBC 3.51 Driver]can't connect to MySql server on '192.168.96.11'(10061)

please help

[MasterSleepy]

Hi,

You have to enable mysql to be accessed by local network:

Code: [Select]


/sbin/e-smith/db configuration setprop mysqld LocalNetworkingOnly no
/sbin/e-smith/expand-template /etc/my.cnf
/sbin/service mysqld restart
These command should solve the problem.

Regards.

[Anonymous]

Thank you so much  

cosy

[cydonia]

Hi,

You have to enable mysql to be accessed by local network:

Code: [Select]


/sbin/e-smith/db configuration setprop mysqld LocalNetworkingOnly no
/sbin/e-smith/expand-template /etc/my.cnf
/sbin/service mysqld restart
These command should solve the problem.

Regards.

Thanks:) this just helped me out...