#44532: Confusion regarding Mysql server went away ----------------------+----------------------- Reporter: jeff@… | Owner: pixilla@… Type: request | Status: new Priority: Normal | Milestone: Component: ports | Version: 2.3.1 Resolution: | Keywords: Port: mysql5 | ----------------------+----------------------- Comment (by jeff@…): I'd like to first resolve this error appearing before upgrading (so that I don't end up with the same problem after the effort). I already seem to have 5.5 on the system too, thought it's not being used apparently. When I run phpinfo() I get the following: mysql MySQL Support enabled Active Persistent Links 0 Active Links 0 Client API version mysqlnd 5.0.8-dev - 20102224 - $Id: 731e5b87ba42146a687c29995d2dfd8b4e40b325 $ Directive Local Value Master Value mysql.allow_local_infile On On mysql.allow_persistent On On mysql.connect_timeout 60 60 mysql.default_host no value no value mysql.default_password no value no value mysql.default_port no value no value mysql.default_socket /opt/local/var/run/mysql5/mysqld.sock /opt/local/var/run/mysql5/mysqld.sock mysql.default_user no value no value mysql.max_links Unlimited Unlimited mysql.max_persistent Unlimited Unlimited mysql.trace_mode Off Off mysqli MysqlI Support enabled Client API library version mysqlnd 5.0.8-dev - 20102224 - $Id: 731e5b87ba42146a687c29995d2dfd8b4e40b325 $ Active Persistent Links 0 Inactive Persistent Links 0 Active Links 0 Directive Local Value Master Value mysqli.allow_local_infile On On mysqli.allow_persistent On On mysqli.default_host no value no value mysqli.default_port 3306 3306 mysqli.default_pw no value no value mysqli.default_socket /opt/local/var/run/mysql5/mysqld.sock /opt/local/var/run/mysql5/mysqld.sock mysqli.default_user no value no value mysqli.max_links Unlimited Unlimited mysqli.max_persistent Unlimited Unlimited mysqli.reconnect Off Off mysqlnd mysqlnd enabled Version mysqlnd 5.0.8-dev - 20102224 - $Id: 731e5b87ba42146a687c29995d2dfd8b4e40b325 $ Compression supported SSL supported Command buffer size 4096 Read buffer size 32768 Read timeout 31536000 Collecting statistics Yes Collecting memory statistics Yes Tracing n/a This leads me to believe that I'm running mysql 5 and that it's the macports one. However, when I run mysql client and enter: show variables like "%version%"; I get: +-------------------------+------------------------------+ | Variable_name | Value | +-------------------------+------------------------------+ | innodb_version | 1.1.8 | | protocol_version | 10 | | slave_type_conversions | | | version | 5.5.15 | | version_comment | MySQL Community Server (GPL) | | version_compile_machine | i386 | | version_compile_os | osx10.6 | +-------------------------+------------------------------+ Which seems to say 5.5 is running, instead. That said, the settings page (OSX 10.8.5) has MySql enabled, and when I disable it by clicking the button under Mysql, I no longer have access to it even from the command line until I enable it again. Also, other than the macports source directories, find / -name=my.cnf inds only two, one in /opt/local/etc/mysql5 and the other in /opt/local/etc/mysql55. I edited the one in mysql5 AND mysql55 adding: [mysqld] max_allowed_packet=100M and restarted apache and mysql. there is no new row appearing in phpinfo() with that setting, and it didn't make a difference. But I don't know how to verify that it's actually present. The problem for me, in general, is that I don't know how to verify much of anything in this case. -- Ticket URL: <https://trac.macports.org/ticket/44532#comment:2> MacPorts <http://www.macports.org/> Ports system for OS X