You are currently viewing Zend Server 5.x documentation. Click here to view the latest Zend Server online documentation.

You are here: Zend Server User Guide > Tasks > phpMyAdmin > Mac OS X

Working with MySQL Server: Mac OS X

The Zend Server Community Edition Mac package includes MySQL and phpMyAdmin. This enables the files to be installed seamlessly and to ensure a smooth configuration process.

Configuration Definitions

File Locations

mySQL binaries (such as 'mysql') reside in:
<install_path>/mysql/bin/
mySQL tables and database reside in:
<install_path>/mysql/data/
Configuration files, in particular, my.cnf reside at:
<install_path>/mysql/data/

Default Port and Socket

Since, by default the 'Skip-networking' option is enabled, the MySQL server does not listen on a TCP/IP port at all; All interactions with 'mysqld' must be made via Unix sockets. The socket file resides at <install_path>/mysql/tmp/mysql.sock.

Starting and Stopping

Generally, zendctl.sh is used to start and stopZend Server Community Edition modules. To start and stop the MySQL server use:

<install_path>/bin/zendctl.sh stop-mysql

<install_path>/bin/zendctl.sh start-mysql

Password

Default user is: zend, and password is left blank

Change the password, either at the config file 'my.cnf', or using the phpMyAdmin interface. To access the phpMyAdmin interface go to the Dashboard and follow the 'Open phpMyAdmin' link.

phpMyAdmin Note:

phpMyAdmin access is by default allowed only from the localhost. To open phpMyAdmin interface to remote user comment out the following lines from /gui/lighttpd/etc/lighttpd.conf:
138 #    $HTTP["remoteip"] !~ "127.0.0.1" {
139 #        $HTTP["url"] =~ "^/phpmyadmin/" {
140 #            url.access-deny = ( "" )
141 #            server.errorfile-prefix = "/usr/local/zend/gui/lighttpd/share/lighttpd-custom-errors/errorcode-"
142 #        }
143 #    }