GNOME Bugzilla – Bug 691069
MySQL: Cannot specify the protocol
Last modified: 2013-01-03 23:15:53 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.
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.
Can you check with commit http://git.gnome.org/browse/libgda/commit/?id=25d2de4ed5de311c836faa676b08eeeab1e876ae ?
Yes, that seems to work fine, letting me add ;PROTOCOL=TCP to my connection string. Many thanks.