> I am typing the following at the command line to change the value of a > variable: > > mysqld --set-variable max_allowed_packet=16000000 > > And get the following message: > 021030 17:08:34 Can't start server: Bind on TCP/IP port: Address > already in use > 021030 17:08:34 Do you already have another mysqld server running on > port: 3306 ? > 021030 17:08:34 Aborting > > 021030 17:08:34 ./bin/mysqld: Shutdown Complete > > What am I doing wrong?
I think mysqld is telling you the daemon is already using the port. If all you want to do is set the variable, you can set it in the [mysqld] section of my.cnf/my.ini: max_allowed_packet=<n> (the set-variable command prefix is no longer required), or you can set it on the command line the first time you start the server. hth PB --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
