[Solved]: How to change coppermine database port

[kazekun]

I've installed coppermine with database connection on port 3306 some time ago and it's working fine.  Recently, I need to change the mysql database from the default port to another port .  Now when I try to access the photo gallery, it says

Coppermine critical error:
Unable to connect to database !

MySQL said: Lost connection to MySQL server at 'reading initial communication packet', system error: 111

I've googled around and found a similar post (http://forum.coppermine-gallery.net/index.php?topic=53674.0) with the solution of "Edit include/config.inc.php and specify the port. For example localhost:3305".  I would like to ask how to make the aforementioned change in the config.php.  In the config.php, it has

// MySQL configuration
$CONFIG['dbserver'] =                         '127.0.0.1';        // Your database server
$CONFIG['dbuser'] =                         'xxxx';        // Your mysql username
$CONFIG['dbpass'] =                         'xxxx';                // Your mysql password
$CONFIG['dbname'] =                         'xxxxi';        // Your mysql database name

So where do I add in the new port number? I tried $CONFIG['dbserver'] = '127.0.0.1:23800' and it didn't work.

[Hein Traag]

Have you tried localhost:23800 ?

[kazekun]

Cannot use localhost:xxxxx, because my apache is in chroot, so the mysql.sock is not in the default /tmp/mysql.sock.  That's why in the user account I need to set host part as 127.0.0.1 instead of localhost in the first place.  I tried the suggestion of localhost:xxxxx (also created user account 'username'@'localhost' in mysql for this purpose), which resulted in the following error message:

Coppermine critical error:
Unable to connect to database !

MySQL said: Can't connect to local MySQL server through socket '/chroot/apache/tmp/mysql.sock' (2)

[kazekun]

Actually, got it working now by using 'server_ipaddr:23800'.  (tried it before but I seemed to have put the wrong port number in at that time).  Anyway, many thanks for your help! ^_^

[Hein Traag]

Your welcome and thanks for the info on the port number setting. Bound to be usefull to others.