Go Premium for a chance to win a PS4. Enter to Win

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 840
  • Last Modified:

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

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
fsyed
Asked:
fsyed
  • 22
  • 17
13 Solutions
 
MASTechnical Department HeadCommented:
0
 
Kevin CrossChief Technology OfficerCommented:
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
 
fsyedAuthor Commented:
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
Windows Server 2016: All you need to know

Learn about Hyper-V features that increase functionality and usability of Microsoft Windows Server 2016. Also, throughout this eBook, you’ll find some basic PowerShell examples that will help you leverage the scripts in your environments!

 
Kevin CrossChief Technology OfficerCommented:
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
 
fsyedAuthor Commented:
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
 
Kevin CrossChief Technology OfficerCommented:
Try the code snippet and see if you see the correct information for PATH.
echo $PATH

Open in new window

0
 
fsyedAuthor Commented:
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
 
fsyedAuthor Commented:
Wait, did you mean to use that in the terminal window by itself?  Sorry, I'm new to unix also.
0
 
Kevin CrossChief Technology OfficerCommented:
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
 
fsyedAuthor Commented:
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
 
Kevin CrossChief Technology OfficerCommented:
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
 
fsyedAuthor Commented:
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
 
Kevin CrossChief Technology OfficerCommented:
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
 
fsyedAuthor Commented:
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
 
Kevin CrossChief Technology OfficerCommented:
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
 
fsyedAuthor Commented:
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
 
fsyedAuthor Commented:
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
 
Kevin CrossChief Technology OfficerCommented:
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
 
fsyedAuthor Commented:
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
 
Kevin CrossChief Technology OfficerCommented:
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
 
fsyedAuthor Commented:
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
 
Kevin CrossChief Technology OfficerCommented:
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
 
fsyedAuthor Commented:
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
 
fsyedAuthor Commented:
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
 
Kevin CrossChief Technology OfficerCommented:
Have you used either of the methods (mysqld_safe is preferred I believe) to start MySQL daemon yet?
0
 
fsyedAuthor Commented:
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
 
Kevin CrossChief Technology OfficerCommented:
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
 
fsyedAuthor Commented:
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
 
Kevin CrossChief Technology OfficerCommented:
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
 
fsyedAuthor Commented:
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
 
Kevin CrossChief Technology OfficerCommented:
Try picking one like my-small.cnf and copy it to my.cnf then edit it.
0
 
fsyedAuthor Commented:
Should I keep the my.cnf file in the same directory as the my-small.cnf file?
0
 
Kevin CrossChief Technology OfficerCommented:
Yes, I am sorry.  That directory should be where MySQL is looking for that file.
0
 
fsyedAuthor Commented:
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
 
Kevin CrossChief Technology OfficerCommented:
Does this actually exist: /tmp/mysql.sock?
0
 
fsyedAuthor Commented:
How do I find out?
0
 
fsyedAuthor Commented:
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
 
Kevin CrossChief Technology OfficerCommented:
Yes, it would appear your user doesn't have proper permissions to the files.  Is your id the administrator for the machine?
0
 
fsyedAuthor Commented:
Yes it is.  There is no other user on this machine.
0
 
fsyedAuthor Commented:
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

Ask an Anonymous Question!

Don't feel intimidated by what you don't know. Ask your question anonymously. It's easy! Learn more and upgrade.

  • 22
  • 17
Tackle projects and never again get stuck behind a technical roadblock.
Join Now