Koozali.org: home of the SME Server

Legacy Forums => General Discussion (Legacy) => Topic started by: cosy on May 30, 2004, 11:38:46 AM

Title: From Windows XP connect to SME Mysql database
Post by: cosy on May 30, 2004, 11:38:46 AM

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

Title: From Windows XP connect to SME Mysql database
Post by: MasterSleepy on May 30, 2004, 11:51:34 AM

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.

Title: From Windows XP connect to SME Mysql database
Post by: Anonymous on May 30, 2004, 02:00:59 PM

:hammer: Thank you so much  :pint:

cosy

Title: From Windows XP connect to SME Mysql database
Post by: cydonia on November 26, 2004, 07:08:41 PM

Quote from: "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.

Thanks:) this just helped me out...