After an evaluation, GNOME has moved from Bugzilla to GitLab. Learn more about GitLab.
No new issues can be reported in GNOME Bugzilla anymore.
To report an issue in a GNOME project, go to GNOME GitLab.
Do not go to GNOME Gitlab for: Bluefish, Doxygen, GnuCash, GStreamer, java-gnome, LDTP, NetworkManager, Tomboy.
Bug 691069 - MySQL: Cannot specify the protocol
MySQL: Cannot specify the protocol
Status: RESOLVED FIXED
Product: libgda
Classification: Other
Component: MySQL provider
unspecified
Other Linux
: Normal normal
: ---
Assigned To: malerba
gnome-db Maintainers
Depends on:
Blocks:
 
 
Reported: 2013-01-03 13:24 UTC by Murray Cumming
Modified: 2013-01-03 23:15 UTC
See Also:
GNOME target: ---
GNOME version: ---

Attachments
libgda_mysql_use_tcp.patch (540 bytes, patch)
2013-01-03 13:25 UTC, Murray Cumming 		none Details | Review

Description Murray Cumming 2013-01-03 13:24:25 UTC 
MySQL does not allow connections on non-default ports unless you are explicitly connecting with the TCP protocol (or maybe other protocols too), as I discovered here:
http://dba.stackexchange.com/questions/31308/mysql-install-db-how-to-set-the-root-password/31310

But libgda does not have any way to specify this when calling, for instance, gda_connection_open_from_string(). I guess it should be a DSN parameter for use with the cnc_string.
Comment 1 Murray Cumming 2013-01-03 13:25:18 UTC 
Created attachment 232637 [details] [review]
libgda_mysql_use_tcp.patch

This little patch, not to be committed, shows how to set the protocol in the MySQL connection.
Comment 3 Murray Cumming 2013-01-03 23:15:53 UTC 
Yes, that seems to work fine, letting me add ;PROTOCOL=TCP to my connection string. Many thanks.