MySQL MacPorts Tutorial
MySQL version 5 has some significant improvements over the MySQL version 4.1.14 that shipped standard with Mac OS X 10.4.Before you configure MySQL version 5 you just installed, first install and configure Webmin (see menu at left). Login to Webmin on your server once it is up, and go the MySQL Webserver under the Servers menu. Click the Module Config link, and set the following configurable options:
Path to mysqlshow command:
/opt/local/bin/mysqlshow5
Path to mysqladmin command:
/opt/local/bin/mysqladmin5
Path to mysql command:
/opt/local/bin/mysql5
Path to mysqldump command:
/opt/local/bin/mysqldump5
Path to mysqlimport command:
/opt/local/bin/mysqlimport5
Command to start MySQL server:
cd /opt/local ; (./bin/safe_mysqld || ./bin/mysqld_safe) &
Path to MySQL shared libraries directory:
/usr/local/mysql/lib -> ?
Path to MySQL databases directory:
/usr/local/mysql/var -> ?
/opt/local/bin/mysqlshow5
Path to mysqladmin command:
/opt/local/bin/mysqladmin5
Path to mysql command:
/opt/local/bin/mysql5
Path to mysqldump command:
/opt/local/bin/mysqldump5
Path to mysqlimport command:
/opt/local/bin/mysqlimport5
Command to start MySQL server:
cd /opt/local ; (./bin/safe_mysqld || ./bin/mysqld_safe) &
Path to MySQL shared libraries directory:
/usr/local/mysql/lib -> ?
Path to MySQL databases directory:
/usr/local/mysql/var -> ?
Now you can start MySQL and test it!
