Gossamer Forum
Home : Products : Gossamer Links : Discussions :

howto change mysql port

Quote Reply
howto change mysql port
Hi all,

I am wondering how to modify the linksql to enable it to connect mysql daemon listenning at other port than the default 3306.

I'd check the linkssql pm files but not sure if there is a official way.

Tks,

Hong
Quote Reply
Re: [cefs99] howto change mysql port In reply to
Hi,

I believe you can change it in /admin/defs/database.def, by finding;

Code:
'port' => undef

..and changing to;

Code:
'port' => '1234'

..where 1234 is your MySQL port.

Hope that helps.

Cheers

Andy (mod)
andy@ultranerds.co.uk
Want to give me something back for my help? Please see my Amazon Wish List
GLinks ULTRA Package | GLinks ULTRA Package PRO
Links SQL Plugins | Website Design and SEO | UltraNerds | ULTRAGLobals Plugin | Pre-Made Template Sets | FREE GLinks Plugins!
Quote Reply
Re: [Andy] howto change mysql port In reply to
Hi,

Sorry I had away from computer for my illness and just back and read your post. However, just change the port setting in the defs/database.def file doesn't work as expected. it seems Glinks still use the default socket which is generated by the mysql server listening at 3306. But actually I want it to connect to another mysql server at port 4306.


Any idea where to tell glinks to use another mysql socket?


Tks,

Hong
Quote Reply
Re: [cefs99] howto change mysql port In reply to
You might have to also reset the .def files... try changing the port as above, then reinstall paths to MySQL from admmin? Careful, so NOT overwrite your data!
dave

Big Cartoon DataBase
Big Comic Book DataBase
Quote Reply
Re: [cefs99] howto change mysql port In reply to
Hi,

A MySQL only work around is to use 'hostname:port' as the hostname in Gossamer Links setup.

Cheers,

Alex
--
Gossamer Threads Inc.