Home / server / Questions / 211594
Accepted
John Berryman
Asked: 2010-12-12 10:28:23 +0800 CST

Setting up mysql on mac

  • 772

I have successfully installed mysql on my mac, and now on the command-line I can type which mysql and the mac replies back the expected path.

I would like to get started with the tutorial here. But according to that tutorial, I need to some additional set up before starting that tutorial. The document refers me to the server administration chapter, but this doesn't show my how to perform the remaining setup... it's more like a reference, so I don't know where to get started.

Is there any good document online to show me how to start administering my mysql database so that I can work through the tutorial?

update: If it's imporant, typing mysql -u root at the command line replies this error: ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)

In case anyone is interested, this is the best mysql tutorial that I've found on the web.

mysql installation database database-administration

2 Answers

  1. Best Answer

    I am not a mac person, but the error means that mysql isn't running. Have you tried to start it?

    Update: There is a document here that has simple instructions for installing mysql.

    http://doc.us.extensis.com/Installing-MySQL-on-OSX.pdf

    It said the command to start the server is sudo /Library/StartupItems/MySQLCOM/MySQLCOM start

    I also don't suggest the tutorial on the mysql site, because it can be unclear at times. I am sure there are good one specifically for a mac.

    Also, if you are running a web server with PHP, phpMyAdmin makes it easy to visually administer your database. I saw there is a mac version here: http://www.macupdate.com/app/mac/8179/phpmyadmin.

    • 2

  2. safe_mysqld & will start mysql from the directory where is installed. the first time you start it you will have to initialize the mysql tables - not sure if this applies to mac.

    as an alternative I use MAMP which is the same as LAMP but for mac - has a widget so you can control servers etc.

    • 1