Solved

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

Posted on 2010-08-21
40
811 Views
Last Modified: 2013-11-08
Dear fellow developers:

I am very new to using a Mac, and just recently bought one.  I am a Java developer would like to develop on my new system.  I have already installed eclipse, and would now like to install and setup MySQL.  I have already downloaded MySQL Community Server 5.5.5 m3 32 bit version, but I am wondering if I need the 64 bit version?  I have used windows throughout my development career, and honestly, am truly a child when it comes to getting started on the mac, and need very basic instructions on what to do after downloading the right package.  What I need is:

1.  What is the correct package do I need for Mac OS X 10.6, 32 bit vs 64 bit?
2.  After downloading the package, how do I install it?
3.  I don't really want MySQL set up as a service.  I'd rather launch when I want to use it, and shut it down when I'm finished, so I'd like someone to show me, how to do this.
4.  Show me how to setup a front-end GUI for use with MySQL, like MySQL workbench.

Any help would be greatly appreciated.

Thanks in advance to all who reply.
0
Comment
Question by:fsyed
  • 22
  • 17
40 Comments
 
LVL 24

Accepted Solution

by:
-MAS earned 39 total points
ID: 33494384
0
 
LVL 59

Expert Comment

by:Kevin Cross
ID: 33494608
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
0
 

Author Comment

by:fsyed
ID: 33497100
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.


0
 
LVL 59

Expert Comment

by:Kevin Cross
ID: 33497149
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.
0
 

Author Comment

by:fsyed
ID: 33498429
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.
0
 
LVL 59

Assisted Solution

by:Kevin Cross
Kevin Cross earned 461 total points
ID: 33501909
Try the code snippet and see if you see the correct information for PATH.
echo $PATH

Open in new window

0
 

Author Comment

by:fsyed
ID: 33504282
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.
0
 

Author Comment

by:fsyed
ID: 33504564
Wait, did you mean to use that in the terminal window by itself?  Sorry, I'm new to unix also.
0
 
LVL 59

Assisted Solution

by:Kevin Cross
Kevin Cross earned 461 total points
ID: 33505274
Yes, just run that and it will test your file is working. You wouldn't run the .profile file from bash like that AFAIK.
0
 

Author Comment

by:fsyed
ID: 33507835
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.
0
 
LVL 59

Assisted Solution

by:Kevin Cross
Kevin Cross earned 461 total points
ID: 33509334
Don't think that worked as you can see MySQL portion is not in the PATH.
Now re-reading, may have to do with saving as RTF. Try recreating the .profile text file as explained in the tutorial and run this again "source ~/.profile".
0
 

Author Comment

by:fsyed
ID: 33514627
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.
0
 
LVL 59

Assisted Solution

by:Kevin Cross
Kevin Cross earned 461 total points
ID: 33515736
Try:

+Open Terminal
+If not in your directory, cd to it (think cd ~/ should work)
+Type: touch .profile (or open command line editor like nano and save)
+Open with TextEdit and simply save

See if that works with rest of instructions.
0
 

Author Comment

by:fsyed
ID: 33518224
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.
0
 
LVL 59

Assisted Solution

by:Kevin Cross
Kevin Cross earned 461 total points
ID: 33520313
The touch command will creating the file if it doesn't exist so you shouldn't see anything else in the command window. Echo of PATH only displays it there, it doesn't modify the file. Try using nano command and then enter all the contents of the file in the terminal window and save as .profile. Then follow remainder of instructions.
0
 

Author Comment

by:fsyed
ID: 33539050
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.

 
0
 

Author Comment

by:fsyed
ID: 33539075
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!
0
 
LVL 59

Assisted Solution

by:Kevin Cross
Kevin Cross earned 461 total points
ID: 33540625
Glad you got it. Yes I would have probably just opened with "nano" only and then typed in the information and then saved the file. We'll be here!
0
 

Author Comment

by:fsyed
ID: 33573480
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.
0
 
LVL 59

Assisted Solution

by:Kevin Cross
Kevin Cross earned 461 total points
ID: 33575043
If you have the DMG install, then you should be fine.  However, I am more of a MySQL guy, so was entrusting that part of the question to the previous Expert; however, I know when I install items on Macs at work, I go for what is easiest of the correct solutions... :) So more appropriate answer is as long as the DMG install works for you, you should be fine!!
0
Comprehensive Backup Solutions for Microsoft

Acronis protects the complete Microsoft technology stack: Windows Server, Windows PC, laptop and Surface data; Microsoft business applications; Microsoft Hyper-V; Azure VMs; Microsoft Windows Server 2016; Microsoft Exchange 2016 and SQL Server 2016.

 

Author Comment

by:fsyed
ID: 33605481
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.
0
 
LVL 59

Assisted Solution

by:Kevin Cross
Kevin Cross earned 461 total points
ID: 33606419
If you grabbed the DMG installation, it is pretty straight-forward.  Just double-click it and answer the questions.  Here is a reference on some details http://davidherron.com/book/357-setting-mysql-mac-os-x
0
 

Author Comment

by:fsyed
ID: 33608807
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.
0
 

Author Comment

by:fsyed
ID: 33624160
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.
0
 
LVL 59

Assisted Solution

by:Kevin Cross
Kevin Cross earned 461 total points
ID: 33627526
Have you used either of the methods (mysqld_safe is preferred I believe) to start MySQL daemon yet?
0
 

Author Comment

by:fsyed
ID: 33633567
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.
0
 
LVL 59

Assisted Solution

by:Kevin Cross
Kevin Cross earned 461 total points
ID: 33639148
It doesn't appear you have permissions to any of the directories specified.

Also, did you follow this instruction:

"After installation go to /usr/local/mysql and run the configure script therein. This script sets up initial database information, initial tables, and starts the MySQL server running."

I ask as it is strange for your account to not have permissions on your own machine, so thinking the configuration was not complete.
0
 

Author Comment

by:fsyed
ID: 33643346
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.
0
 
LVL 59

Assisted Solution

by:Kevin Cross
Kevin Cross earned 461 total points
ID: 33645755
Ah, I missed that earlier that you ran mysql_install_db.

Do you know where your my.cnf is located?  Edit that file and configure the following for [client] of my.cnf:

[mysqld]
datadir={path to your mysql data folder - e.g., /usr/local/mysql/data - however given your issues with permissions, I would double check that is the actual path}
socket={path to mysql.sock - e.g., /var/lib/mysql/mysql.sock}

[client]
socket={copy value found in mysqld section above}


Reference:
http://dev.mysql.com/doc/refman/5.1/en/can-not-connect-to-server.html
0
 

Author Comment

by:fsyed
ID: 33657617
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.
0
 
LVL 59

Assisted Solution

by:Kevin Cross
Kevin Cross earned 461 total points
ID: 33657657
Try picking one like my-small.cnf and copy it to my.cnf then edit it.
0
 

Author Comment

by:fsyed
ID: 33657699
Should I keep the my.cnf file in the same directory as the my-small.cnf file?
0
 
LVL 59

Expert Comment

by:Kevin Cross
ID: 33658009
Yes, I am sorry.  That directory should be where MySQL is looking for that file.
0
 

Author Comment

by:fsyed
ID: 33658273
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.
0
 
LVL 59

Expert Comment

by:Kevin Cross
ID: 33658299
Does this actually exist: /tmp/mysql.sock?
0
 

Author Comment

by:fsyed
ID: 33658308
How do I find out?
0
 

Author Comment

by:fsyed
ID: 33658331
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.
0
 
LVL 59

Expert Comment

by:Kevin Cross
ID: 33658451
Yes, it would appear your user doesn't have proper permissions to the files.  Is your id the administrator for the machine?
0
 

Author Comment

by:fsyed
ID: 33658474
Yes it is.  There is no other user on this machine.
0
 

Author Closing Comment

by:fsyed
ID: 33833544
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!
0

Featured Post

How your wiki can always stay up-to-date

Quip doubles as a “living” wiki and a project management tool that evolves with your organization. As you finish projects in Quip, the work remains, easily accessible to all team members, new and old.
- Increase transparency
- Onboard new hires faster
- Access from mobile/offline

Join & Write a Comment

Suggested Solutions

Foreword In the years since this article was written, numerous hacking attacks have targeted password-protected web sites.  The storage of client passwords has become a subject of much discussion, some of it useful and some of it misguided.  Of cou…
Deploystudio is a system which can be used to deploy OSX clients and servers within the small/medium or large business environments. The system is built ontop of the OSX Server NetBoot system and uses images & workflows as its core assets. Although …
Polish reports in Access so they look terrific. Take yourself to another level. Equations, Back Color, Alternate Back Color. Write easy VBA Code. Tighten space to use less pages. Launch report from a menu, considering criteria only when it is filled…
This video shows how to remove a single email address from the Outlook 2010 Auto Suggestion memory. NOTE: For Outlook 2016 and 2013 perform the exact same steps. Open a new email: Click the New email button in Outlook. Start typing the address: …

746 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

14 Experts available now in Live!

Get 1:1 Help Now