Need step by step instructions on installing, and setting up MySQL on Mac OSX 10.6

It would appear that the previous Expert comment has provided instructions. It is for 64-bit, but suspect it should function regardless of if using 32-bit.

So circling back to that question, you pick 64-bit based on your machine's capabilities and operating system actually being 64-bit. So as long as you are running Snow Leopard on a 64-bit machine then I would go for MySQL 64-bit as you get to take advantage of the more memory addressing capabilities.

I believe the link covers your other questions, but for MySQL Workbench it is greatly improved. I would suspect the setup is easy - it is just a DMG file.
http://dev.mysql.com/doc/workbench/en/wb-installing-mac.html

Navicat is also a good option on Mac.

HTH
Kevin

Thanks for your quick replies.  I have the following follow up question for you:

In setting the PATH variable, the page you sent me states:


Using the editor of your choice, create and edit a file in your home directory named .profile (note the “.” preceding the filename).

If you’re using TextMate like you should be and have installed the UNIX mate command, then you can create and start editing the file like this:

mate ~/.profile
To the end of this file, add the following line (or verify that it’s already there):

export PATH="/usr/local/bin:/usr/local/sbin:/usr/local/mysql/bin:$PATH"

I'm using my default editor, TextEdit.  So, I should create a file called .profile, with the following text inside:

export PATH="/usr/local/bin:/usr/local/sbin:/usr/local/mysql/bin:$PATH"

Is this correct?  Also, what is my "home directory", to where I should be saving this file?

I apologize for sounding retarded, but I just want to make sure I do everything right, which is why I don't want to assume anything.

Thanks again for your help.

It should be your personal folder, the one named after your logged on user name. And yes, that is what you need to do with the file.

Thanks for clarifying that for me.  Here's what I did:

1.  I opened up textedit, and created a document with only the following text:

export PATH="/usr/local/bin:/usr/local/sbin:/usr/local/mysql/bin:$PATH"

I saved it as .profile as a Rich Text Format, in the location that is myname that appears under the heading "PLACES" on the left hand side, underneath "Desktop", and above "Applications" when you click on "finder" at the bottom.  I opened up the terminal window, and then typed:

source ~/.profile

at which point I get the following message:

-bash:  /Users/myname/.profile:  No such file or directory  

What am I doing wrong?  Any suggestions?

Thanks again for your help and patience.

Do I use your code snippet instead of:

export PATH="/usr/local/bin:/usr/local/sbin:/usr/local/mysql/bin:$PATH"

or do I simply use your snippet at the end of the first one:

export PATH="/usr/local/bin:/usr/local/sbin:/usr/local/mysql/bin:echo $PATH"

?

Just wondering.

Thanks again for your help.

Wait, did you mean to use that in the terminal window by itself?  Sorry, I'm new to unix also.

Ok, I did as you asked, and I got the following response:

/usr/bin:/bin:/usr/sbin:/sbin:/usr/local/bin:/usr/X11/bin

What should I do next?

Thanks again for your help and patience.

I'm using TextEdit to make the file, and it gives me these options as the format to save it in:

Rich Text Format
Rich Text Format with Attachments
Web Page (.html)
Web Archive
OpenDocument Text (.odt)
Word 2007 Format (.docx)
Word 2003 Format (.xml)
Word 97 Format (.doc)

Which format should I use, or should I use another program altogether?

Thanks again for your help and patience.

Thanks for your reply.  Here is the text from terminal window:


Last login: Tue Aug 24 00:30:21 on ttys001
Fayyazuddin-Syeds-Mac-mini:~ fayyazuddinsyed$ touch .profile
Fayyazuddin-Syeds-Mac-mini:~ fayyazuddinsyed$ cd ~/
Fayyazuddin-Syeds-Mac-mini:~ fayyazuddinsyed$ touch .profile
Fayyazuddin-Syeds-Mac-mini:~ fayyazuddinsyed$


Nothing happened when I entered the line:  touch .profile, except give me an identical line underneath.  When I opened TextEdit, and simply tried to save, I still got the message, that prompted me to choose the format to save the document in.    Having said that, I tried to follow the steps again, creating a new file named .profile saved in my home directory, and then re-opened my terminal window and did the following:


Last login: Wed Aug 25 00:58:48 on ttys002
Fayyazuddin-Syeds-Mac-mini:~ fayyazuddinsyed$ source ~/.profile
Fayyazuddin-Syeds-Mac-mini:~ fayyazuddinsyed$ echo $PATH
/usr/bin:/bin:/usr/sbin:/sbin:/usr/local/bin:/usr/X11/bin
Fayyazuddin-Syeds-Mac-mini:~ fayyazuddinsyed$

However, I am not seeing, "/usr/local/bin" at the beginning.  Am I making any progress here?

Thanks again for your help, and patience.

Ok, here is what I did:


Fayyazuddin-Syeds-Mac-mini:~ fayyazuddinsyed$ nano export PATH="/usr/local/bin:/usr/local/sbin:/usr/local/mysql/bin:$PATH"

I pressed CTRL-O to select "WriteOut"  

I was prompted with the message:  File Name to Write:

To which I entered:  .profile , and pressed "Enter"

I was then prompted with the message:  File exists, OVERWRITE ?      

I was then given the message:    [ Wrote 0 lines ]

I then pressed CTRL-X to exit, and I got the following message:

[ Switched to PATH=/usr/local/bin:/usr/local/sbin:/usr/local/mysql/bin:/usr/bi ]
^G Get Help  ^O WriteOut  ^R Read File ^Y Prev Page ^K Cut Text  ^C Cur Pos
^X Exit      ^J Justify   ^W Where Is  ^V Next Page ^U UnCut Text^T To Spell

I then press CTRL-X, and I return to the screen I was at:

Last login: Wed Aug 25 01:07:56 on ttys002
Fayyazuddin-Syeds-Mac-mini:~ fayyazuddinsyed$ echo $PATH/usr/bin:/bin:/usr/sbin:/sbin:/usr/local/bin:/usr/X11/bin
Fayyazuddin-Syeds-Mac-mini:~ fayyazuddinsyed$ nano export PATH="/usr/local/bin:/usr/local/sbin:/usr/local/mysql/bin:$PATH"
Fayyazuddin-Syeds-Mac-mini:~ fayyazuddinsyed$


When I enter:

echo $PATH I get:

/usr/bin:/bin:/usr/sbin:/sbin:/usr/local/bin:/usr/X11/bin
Fayyazuddin-Syeds-Mac-mini:~ fayyazuddinsyed$


Did I do everything correctly, or am I missing something?

Thanks again for your help and patience.

 

Sorry, I figured it out.  I got the file saved, and now I am able to move on.  I'll keep you posted.

Fayyazuddin-Syeds-Mac-mini:~ fayyazuddinsyed$ source ~/.profile
Fayyazuddin-Syeds-Mac-mini:~ fayyazuddinsyed$ echo $PATH
/usr/local/bin:/usr/local/sbin:/usr/local/mysql/bin:/usr/bin:/bin:/usr/sbin:/sbin:/usr/local/bin:/usr/X11/bin


Thanks so much for your patience!

Ok, I have downloaded the latest version of MySQL, but the instructions on:

http://hivelogic.com/articles/compiling-mysql-on-snow-leopard

compile MySQL from source, and then install it.  Do I really need to recompile MySQL from source?  Can I not just use the binary file that I download for MySQL?

Just wondering.

Thanks again for your help, and patience.

Ok, I have downloaded MySQL:  mysql-5.5.0-m2-osx10.6-x86_64  (this is the name of the parent folder), which is now residing in the following directory:

Users/fayyazuddinsyed/downloads/mysql-5.5.0-m2-osx10.6-x86_64

The next steps that I am supposed to follow are:

Step 3: Compile and Install
Build and install MySQL like this:

tar xzvf mysql-5.1.37.tar.gz
cd mysql-5.1.37
./configure --prefix=/usr/local/mysql --with-extra-charsets=complex \
--enable-thread-safe-client --enable-local-infile --enable-shared \
--with-plugins=innobase

make
sudo make install

cd /usr/local/mysql
sudo ./bin/mysql_install_db --user=mysql
sudo chown -R mysql ./var
cd ..

Since I am not going to build from source, what am I supposed to do?  What directories do I create, and where?  Do I need to move the mysql folder that I have currently in the downloads folder, and move it some place else?  I am confused here at this point.  

Thanks again for your time and patience.

I downloaded the file: mysql-5.1.50-osx10.6-x86_64.dmg into my downloads directory, and after it finished downloading, a window popped up with the mysql-5.1.50-osx10.6-x86_64.pkg file, and the MySQLStartupItem.pkg file.  It also had the MySQL.prePane file and ReadMe.txt.  As per instructions on:

http://davidherron.com/book/357-setting-mysql-mac-os-x

I double-clicked on the mysql-5.1.50-osx10.6-x86_64.dmg first, and answered the questions and did the installation.  I then did the same thing to:  MySQLStartupItem.pkg .  The one thing I didn't do when I was installing the two files, was pick an alternate location.  Instead, I simply agreed to the default location it chose, and went ahead.  Now, on the site you gave me, it gives me the following instructions:

Verify an account named mysql exists on your system:

% grep mysql /etc/passwd
mysql:*:74:74:MySQL Server:/var/empty:/usr/bin/false

I did this, as you can see below, and get the message:

MySQL: command not found.



Last login: Sat Sep  4 23:35:32 on ttys000
Fayyazuddin-Syeds-Mac-mini:~ fayyazuddinsyed$ % grep mysql /etc/passwd
-bash: fg: %: no such job
Fayyazuddin-Syeds-Mac-mini:~ fayyazuddinsyed$ mysql:*:74:74:MySQL Server:/var/empty:/usr/bin/false
-bash: mysql:*:74:74:MySQL: command not found
Fayyazuddin-Syeds-Mac-mini:~ fayyazuddinsyed$ echo $PATH
/usr/local/bin:/usr/local/sbin:/usr/local/mysql/bin:/usr/bin:/bin:/usr/sbin:/sbin:/usr/local/bin:/usr/X11/bin
Fayyazuddin-Syeds-Mac-mini:~ fayyazuddinsyed$ mysql -uroot
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)
Fayyazuddin-Syeds-Mac-mini:~ fayyazuddinsyed$ ls
Desktop            Downloads      Movies            Pictures      Sites
Documents      Library            Music            Public
Fayyazuddin-Syeds-Mac-mini:~ fayyazuddinsyed$ cd /usr
Fayyazuddin-Syeds-Mac-mini:usr fayyazuddinsyed$ ls
X11            etc            libexec            sbin
X11R6            include            llvm-gcc-4.2      share
bin            lib            local            standalone
Fayyazuddin-Syeds-Mac-mini:usr fayyazuddinsyed$ cd /local
-bash: cd: /local: No such file or directory
Fayyazuddin-Syeds-Mac-mini:usr fayyazuddinsyed$ cd local
Fayyazuddin-Syeds-Mac-mini:local fayyazuddinsyed$ ls
mysql                        share
mysql-5.1.50-osx10.6-x86_64
Fayyazuddin-Syeds-Mac-mini:local fayyazuddinsyed$ cd mysql
Fayyazuddin-Syeds-Mac-mini:mysql fayyazuddinsyed$ ls
COPYING                  data                  mysql-test
EXCEPTIONS-CLIENT      docs                  scripts
INSTALL-BINARY            include                  share
README                  lib                  sql-bench
bin                  man                  support-files
Fayyazuddin-Syeds-Mac-mini:mysql fayyazuddinsyed$ % grep mysql /etc/passwd
-bash: fg: %: no such job
Fayyazuddin-Syeds-Mac-mini:mysql fayyazuddinsyed$ mysql:*:74:74:MySQL Server:/var/empty:/usr/bin/false
-bash: mysql:*:74:74:MySQL: command not found
Fayyazuddin-Syeds-Mac-mini:mysql fayyazuddinsyed$ mysql -uroot
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)
Fayyazuddin-Syeds-Mac-mini:mysql fayyazuddinsyed$


I am feeling optimistic that I am close to finishing, because I can see the directories:


Last login: Sun Sep  5 23:52:57 on ttys000
Fayyazuddin-Syeds-Mac-mini:~ fayyazuddinsyed$ cd /usr
Fayyazuddin-Syeds-Mac-mini:usr fayyazuddinsyed$ cd local
Fayyazuddin-Syeds-Mac-mini:local fayyazuddinsyed$ ls
mysql                        share
mysql-5.1.50-osx10.6-x86_64
Fayyazuddin-Syeds-Mac-mini:local fayyazuddinsyed$

as stated in the directions.  Where do I go from here?  With respect to the configure script to install, I went into the scripts subdirectory of mysql and found only: mysql_install_db

Am I to install this file?  If not, where do I find the configure script?

Thanks again for all of your help, and patience.

I think I'm almost done now.  Here is what I did:


Fayyazuddin-Syeds-Mac-mini:mysql fayyazuddinsyed$ sudo ./scripts/mysql_install_db --user=mysql

WARNING: Improper use of the sudo command could lead to data loss
or the deletion of important system files. Please double-check your
typing when using sudo. Type "man sudo" for more information.

To proceed, enter your password, or type Ctrl-C to abort.

Password:
Installing MySQL system tables...
OK
Filling help tables...
OK

To start mysqld at boot time you have to copy
support-files/mysql.server to the right place for your system

PLEASE REMEMBER TO SET A PASSWORD FOR THE MySQL root USER !
To do so, start the server, then issue the following commands:

./bin/mysqladmin -u root password 'new-password'
./bin/mysqladmin -u root -h Fayyazuddin-Syeds-Mac-mini.local password 'new-password'

Alternatively you can run:
./bin/mysql_secure_installation

which will also give you the option of removing the test
databases and anonymous user created by default.  This is
strongly recommended for production servers.

See the manual for more instructions.

You can start the MySQL daemon with:
cd . ; ./bin/mysqld_safe &

You can test the MySQL daemon with mysql-test-run.pl
cd ./mysql-test ; perl mysql-test-run.pl

Please report any problems with the ./bin/mysqlbug script!

Fayyazuddin-Syeds-Mac-mini:mysql fayyazuddinsyed$ sudo chown -R mysql ./var
chown: ./var: No such file or directory
Fayyazuddin-Syeds-Mac-mini:mysql fayyazuddinsyed$ ls
COPYING                  data                  mysql-test
EXCEPTIONS-CLIENT      docs                  scripts
INSTALL-BINARY            include                  share
README                  lib                  sql-bench
bin                  man                  support-files
Fayyazuddin-Syeds-Mac-mini:mysql fayyazuddinsyed$ mysql-test-run.pl
-bash: mysql-test-run.pl: command not found
Fayyazuddin-Syeds-Mac-mini:mysql fayyazuddinsyed$ mysql -uroot
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)
Fayyazuddin-Syeds-Mac-mini:mysql fayyazuddinsyed$

I'm trying to start mysql by typing mysql -uroot, but I'm getting the error message:

Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)

What am I doing wrong?

Thanks again for your time, and patience.

I have not started the MySQL daemon yet.  I tried as you suggested just now, to use mysqld_safe and I got the following:


Fayyazuddin-Syeds-Mac-mini:mysql fayyazuddinsyed$ mysqld_safe
100909 00:13:47 mysqld_safe Logging to '/usr/local/mysql/data/Fayyazuddin-Syeds-Mac-mini.local.err'.
touch: /usr/local/mysql/data/Fayyazuddin-Syeds-Mac-mini.local.err: Permission denied
chown: /usr/local/mysql/data/Fayyazuddin-Syeds-Mac-mini.local.err: Permission denied
100909 00:13:47 mysqld_safe Starting mysqld daemon with databases from /usr/local/mysql/data
/usr/local/mysql/bin/mysqld_safe: line 100: /usr/local/mysql/data/Fayyazuddin-Syeds-Mac-mini.local.err: Permission denied
rm: /usr/local/mysql/data/Fayyazuddin-Syeds-Mac-mini.local.pid: Permission denied
/usr/local/mysql/bin/mysqld_safe: line 137: /usr/local/mysql/data/Fayyazuddin-Syeds-Mac-mini.local.err: Permission denied
100909 00:13:47 mysqld_safe mysqld from pid file /usr/local/mysql/data/Fayyazuddin-Syeds-Mac-mini.local.pid ended
/usr/local/mysql/bin/mysqld_safe: line 100: /usr/local/mysql/data/Fayyazuddin-Syeds-Mac-mini.local.err: Permission denied

What am I doing wrong here?

Thanks again for your help, and patience.  I truly am sorry for being a total knob at this.

Thanks for you reply.  I went to the mysql directory, but couldn't find the configure file that is supposed to be there:


Fayyazuddin-Syeds-Mac-mini:local fayyazuddinsyed$ cd mysql
Fayyazuddin-Syeds-Mac-mini:mysql fayyazuddinsyed$ ls
COPYING                  data                  mysql-test
EXCEPTIONS-CLIENT      docs                  scripts
INSTALL-BINARY            include                  share
README                  lib                  sql-bench
bin                  man                  support-files
Fayyazuddin-Syeds-Mac-mini:mysql fayyazuddinsyed$ cd scripts
Fayyazuddin-Syeds-Mac-mini:scripts fayyazuddinsyed$ ls
mysql_install_db


The only file I found was mysql_install_db which I thought was equivalent to the configure file I was supposed to run.  Where can I find this file?

Thanks again for your patience.

Thanks very much for your reply.  I can't seem to find the my.cnf file.  I went into the support-files directory, and here is what I have below:

Fayyazuddin-Syeds-Mac-mini:~ fayyazuddinsyed$ cd /usr/local/mysql
Fayyazuddin-Syeds-Mac-mini:mysql fayyazuddinsyed$ ls
COPYING                  data                  mysql-test
EXCEPTIONS-CLIENT      docs                  scripts
INSTALL-BINARY            include                  share
README                  lib                  sql-bench
bin                  man                  support-files
Fayyazuddin-Syeds-Mac-mini:mysql fayyazuddinsyed$ cd support-files
Fayyazuddin-Syeds-Mac-mini:support-files fayyazuddinsyed$ ls
binary-configure      my-huge.cnf            mysql-log-rotate
config.huge.ini            my-innodb-heavy-4G.cnf      mysql.server
config.medium.ini      my-large.cnf            mysqld_multi.server
config.small.ini      my-medium.cnf            ndb-config-2-node.ini
magic                  my-small.cnf
Fayyazuddin-Syeds-Mac-mini:support-files fayyazuddinsyed$

That being said, I went online and found this post:

http://forums.mysql.com/read.php?11,366143,376017#msg-376017

in this post the author says:  

By default, the OS X installation does not use a my.cnf, and MySQL just uses the default values.

am I to still create a my.cnf file if it doesn't exist, or am I to simply edit one of the existing files that's already there?

Thanks again for your help, and patience.

Should I keep the my.cnf file in the same directory as the my-small.cnf file?

Yes, I am sorry.  That directory should be where MySQL is looking for that file.

I did as you asked, and I still get the following:


Fayyazuddin-Syeds-Mac-mini:~ fayyazuddinsyed$ cd /usr/local/mysql
Fayyazuddin-Syeds-Mac-mini:mysql fayyazuddinsyed$ mysqld_safe
100912 17:16:55 mysqld_safe Logging to '/usr/local/mysql/data/Fayyazuddin-Syeds-Mac-mini.local.err'.
touch: /usr/local/mysql/data/Fayyazuddin-Syeds-Mac-mini.local.err: Permission denied
chown: /usr/local/mysql/data/Fayyazuddin-Syeds-Mac-mini.local.err: Permission denied
100912 17:16:55 mysqld_safe Starting mysqld daemon with databases from /usr/local/mysql/data
/usr/local/mysql/bin/mysqld_safe: line 100: /usr/local/mysql/data/Fayyazuddin-Syeds-Mac-mini.local.err: Permission denied
rm: /usr/local/mysql/data/Fayyazuddin-Syeds-Mac-mini.local.pid: Permission denied
/usr/local/mysql/bin/mysqld_safe: line 137: /usr/local/mysql/data/Fayyazuddin-Syeds-Mac-mini.local.err: Permission denied
100912 17:16:55 mysqld_safe mysqld from pid file /usr/local/mysql/data/Fayyazuddin-Syeds-Mac-mini.local.pid ended
/usr/local/mysql/bin/mysqld_safe: line 100: /usr/local/mysql/data/Fayyazuddin-Syeds-Mac-mini.local.err: Permission denied
Fayyazuddin-Syeds-Mac-mini:mysql fayyazuddinsyed$



I have two copies of my.cnf.  One copy is in the root /etc folder, and I left an identical copy of the file in the "support-files" directory,  Here is what the contents of my.cnf looks like:


# Example MySQL config file for small systems.
#
# This is for a system with little memory (<= 64M) where MySQL is only used
# from time to time and it's important that the mysqld daemon
# doesn't use much resources.
#
# You can copy this file to
# /etc/my.cnf to set global options,
# mysql-data-dir/my.cnf to set server-specific options (in this
# installation this directory is /usr/local/mysql/data) or
# ~/.my.cnf to set user-specific options.
#
# In this file, you can use all long options that a program supports.
# If you want to know which options a program supports, run the program
# with the "--help" option.

# The following options will be passed to all MySQL clients
[client]
#password       = your_password

port            = 3306
socket          = /tmp/mysql.sock

# Here follows entries for some specific programs

# The MySQL server
[mysqld]
port            = 3306
socket          = /tmp/mysql.sock
skip-locking                  
key_buffer_size = 16K
max_allowed_packet = 1M
table_open_cache = 4
sort_buffer_size = 64K
read_buffer_size = 256K
read_rnd_buffer_size = 256K
net_buffer_length = 2K
thread_stack = 128K


# Don't listen on a TCP/IP port at all. This can be a security enhancement,
# if all processes that need to connect to mysqld run on the same host.
# All interaction with mysqld must be made via Unix sockets or named pipes.
# Note that using this option without enabling named pipes on Windows
# (using the "enable-named-pipe" option) will render mysqld useless!
#
#skip-networking
server-id       = 1

# Uncomment the following if you want to log updates
#log-bin=mysql-bin

# binary logging format - mixed recommended
#binlog_format=mixed

# Uncomment the following if you are using InnoDB tables
#innodb_data_home_dir = /usr/local/mysql/data/

#innodb_data_file_path = ibdata1:10M:autoextend
#innodb_log_group_home_dir = /usr/local/mysql/data/
# You can set .._buffer_pool_size up to 50 - 80 %
# of RAM but beware of setting memory usage too high
#innodb_buffer_pool_size = 16M
#innodb_additional_mem_pool_size = 2M
# Set .._log_file_size to 25 % of buffer pool size
#innodb_log_file_size = 5M
#innodb_log_buffer_size = 8M
#innodb_flush_log_at_trx_commit = 1
#innodb_lock_wait_timeout = 50

[mysqldump]
quick
max_allowed_packet = 16M

[mysql]
no-auto-rehash

# Remove the next comment character if you are not familiar with SQL
#safe-updates

[myisamchk]
key_buffer_size = 8M
sort_buffer_size = 8M

[mysqlhotcopy]
interactive-timeout


Does everything look correct?  Am I missing anything?

Thanks again for your time and patience.

Does this actually exist: /tmp/mysql.sock?

How do I find out?

I also noticed that when I tried to delete the file my.cnf from /etc directory, I got the following message:


Fayyazuddin-Syeds-Mac-mini:support-files fayyazuddinsyed$ cd /etc
Fayyazuddin-Syeds-Mac-mini:etc fayyazuddinsyed$ rm my.cnf
override rw-r--r--  root/wheel for my.cnf?

when I typed in "y", I got the following message:


override rw-r--r--  root/wheel for my.cnf? y
rm: my.cnf: Permission denied
Fayyazuddin-Syeds-Mac-mini:etc fayyazuddinsyed$

should I leave the file in /etc?  Am I supposed to enter "y" or "n" at the prompt?  Why is it not giving me permission to delete the file?

Just wondering.  Thanks again for your help.

Yes, it would appear your user doesn't have proper permissions to the files.  Is your id the administrator for the machine?

Yes it is.  There is no other user on this machine.

Thanks very much for your help.  You've helped me get MySQL installed my Mac.  I'll try to sort the issue with the permissions later.  I believe the hard part is done, and you've been very patient with me this whole time.  Points well deserved!