MySQL on Mac OS X


MySQL on Mac OS X 10.7.3 Installation & configuration Download the mac based tar or dmg from MySQL website Add group mysql Add user mysql who’s group is mysql shell> cd /usr/local shell> tar zxvf /path/to/mysql-VERSION-OS.tar.gz shell> cd mysql shell> chown -R mysql . shell> chgrp -R mysql . shell> scripts/mysql_install_db –user=mysql shell> chown -R […]

Read More MySQL on Mac OS X

MYSQL replication in the same box


MYSQL replication in the same box   MYSQL 5.0.17 standard (SLAVE) – 10.0.0.1 MYSQL 4.1.1 standard (MASTER) – 10.0.0.2 MASTER running on port 3306 SLAVE running on port 3308 MASTER (my.cnf) server-id = 1 log-bin SLAVE (my.cnf) [mysqld] server-id = 2 master-host = localhost master-user = root master-password = mysql master-port = 3306 replicate-do-db = […]

Read More MYSQL replication in the same box