Topic: ODBC Connection Problem

[grahowler]

Hi

I have a problem connecting to my SME server via ODBC. I have an SME server acting as a gateway and server for a small network. The SME machine is set to 192.168.0.1 and I am trying to connect to MySQL via a windows machine, 192.168.0.2.

When I try and connect via ODBC I get an Error:

[MySQL][ODBC Driver 3.51] Lost connection to MySQL Server during query.

I have created two users as per the MySQL documentation using:

1. "GRANT ALL PRIVILEGES ON *.* TO myUser@localhost IDENTIFIED BY 'myUserPass'"
2. "GRANT ALL PRIVILEGES ON *.* TO myUser@"%" IDENTIFIED BY 'myUserPass'"

The MySQL documentation states:

"A full superuser who can connect to the server from anywhere... Note that we must issue GRANT statements for both monty@localhost and monty@"%"."

I know I should check to see if port 3306 is open but I am unsure how to do this. I am at a dead end now in that I don't know what to try next. Any ideas?

Thx in advance.

[Ray Mitchell]

You don't say which version sme you are using.

On v5.6 some extra rpms are needed (glibc.....)
On 6.0b3 there is a command line mod to do

Search these forums on mysql and I'm sure you'll find the references I'm referring to

Regs
Ray

[mike mattos]

is there a link to the command line fix somewhere?  My MySQL is working properly in PHP and from a terminal screen, but not via ODBC

( 6b3 SME )

Suggetions welcome

Mike

[Ray Mitchell]

Mike
Search these forums on mysql and you'll find the references, go back a few months though.
Ray

[%sig%]

[Paul]

On version 6b3 you need to do the following:

/sbin/e-smith/config setprop mysqld LocalNetworkingOnly no