Differences

This shows you the differences between two versions of the page.

--- docs:mac:builds:mysql [2007/11/19 23:10] – external edit 127.0.0.1
+++ docs:mac:builds:mysql [2012/04/25 22:09] (current) – [mysql] billh
@@ Line 1: / Line 1: @@
 ====== mysql ======
   * download source from http://dev.mysql.com (version 5)
+  * [[..:add_user|create a 'mysql' user account]] (Leopard comes with a _mysql user)
 <code>
-(create a mysql user)
+./configure --prefix=/usr/local/mysql \
+--mandir=/usr/local/man \
-./configure --prefix=/usr/local/mysql
+--infodir=/usr/local/info \
+--enable-local-infile \
+--enable-thread-safe-client
 make
@@ Line 10: / Line 13: @@
 sudo make install
-cp /usr/local/mysql/share/mysql/my-medium.cnf /etc/my.cnf
+sudo cp /usr/local/mysql/share/mysql/my-medium.cnf /etc/my.cnf
 (modify /etc/my.cnf as desired)
@@ Line 20: / Line 23: @@
 sudo chown -R root .
 sudo chown -R mysql var
+(note - if you get a socket error when trying the command below to start the server, you need to create the socket file like this)
+cd /tmp
+sudo touch mysql.sock
+sudo chown mysql:wheel mysql.sock
 (start the MySQL server)
 sudo /usr/local/mysql/bin/mysqld_safe --user=mysql &
+(setup a password for root)
+sudo /usr/local/mysql/bin/mysqladmin -u root password 'new-password'
 (shutdown the MySQL server)
 sudo /usr/local/mysql/bin/mysqladmin -u root -p shutdown
 </code>
+===== thread safe client =====
+The **%%--enable-thread-safe-client%%** flag tells mysql to build mysqlclient_r.  The is required in some programs, such as [[mediatomb]].
+===== See Also =====
+  * [[..:creating_startup_items]]
+===== External Links =====
+  * [[http://www.osxfaq.com/Tutorials/LearningCenter/HowTo/Startup/index.ws|creating a startup item in Mac OS X (uses mysql as an example)]]
+  * http://dev.mysql.com/doc/refman/5.0/en/mac-os-x-installation.html