17 comments

• 

  Yost

  8 months ago

  Oh my gosh... you have no idea how grateful I am right now, I've been working on this for several days now being a total unix noob and this just helped me to get it working. Thanks so much. 1% was all I needed.
  reply
• 

  Dave

  7 months ago

  Really clear and very helpful, thanks.
  
  Just one comment - when editing wp-config.php I found that setting DB_HOST to "localhost:/tmp/mysql.sock" didn't work, I had to just use "localhost".
  reply
• 

  tgp

  5 months ago

  Absolutely fantastic tutorial. One change though. In the newer version of WP,
  /usr/local/mysql/bin/safe_mysqld
  
  is now
  
  /usr/local/mysql/bin/mysqld_safe
  reply
• 

  Shams-143.priya

  5 months ago

  Amazing Site I like it. It Was Quite Interesting NiceWork I appreciate the information you provided Excellent post. Keep it up!
  Good day!
  reply
• 

  anonymous

  5 months ago

  Simply marevelous. I am a novice to PHP/MYSQL/APACHE, and was able to follow this tutorial without a hitch. Thank you so much, keep up the good work :D
  reply
• 

  Fábio Morbec

  5 months ago

  Hello ! Nice tutorial !!
  
  Instead of create a folder on /var/mysql you can:
  
  cp /etc
  sudo cp php.ini.default php.ini
  
  Then, edit the line that starts with mysql.default_socket to look like this
  
  mysql.default_socket = /tmp/mysql.sock
  reply
• 

  Fábio Morbec

  5 months ago

  ops, the third line is:
  
  cd /etc/
  
  and not cp /etc
  reply
• 

  sam

  4 months ago

  Got stuck on "Add this line to your profile:" 'cause I can't find .profile
  Get message from Terminal: The file /Users/xxx/.profile does not exist.
  
  Any help?
  reply
• 

  sam

  4 months ago

  well, i guess there's more than one way to skin that cat. I went to:
  /etc/profile and checked the username as such,
  
  if [[ $USER = "test" ]]
  then
  export PATH="$PATH:/usr/local/mysql/bin"
  fi
  reply
• 

  LANman

  4 months ago

  So far this site has been great but I am fairly new to mysql and DB's in general. When I got to the part where you have to complete the configuration from terminal I get command not found when I type in mysql -u root. Any ideas on what I am doing wrong or what I need to do to get this to work.
  
  Thanks
  reply
• 

  Todd Wheeler

  4 months ago

  Entering "set password for 'root'@'macmini.local' = password('password');" in the third "set password" instructions produces the following error:
  
  ERROR 1133 (42000): Can't find any matching row in the user table
  
  I have tried some variations of the set password line, but no luck. Should I stop and then start Mysql, or is setting a password for this user necessary?
  
  Thank you for this very helpful tutorial.
  reply
• 

  Phillip Gibb

  4 months ago

  Thanks for the recipe - I plan to do this over the weekend in order to migrate my blog from WP hosted to self hosted :-)
  
  Phill(synapticlight)
  reply
• 

  John Schuster

  3 months ago

  Thanks for this. I look forward to installing Wordpress locally this week :)
  reply
• 

  Bill Durbin

  1 month ago

  Hello,
  
  I got through the installation with no problem, but it won't let me login to wordpress. When I look at the table in mysql, there is only one user 'admin'. I can't login as my own user and I can't login as admin. Am I missing something? I used all the username and password settings exactly as in this tutorial. What am I doing wrong?
  
  Thanks,
  
  BD
  reply
• 

  Vadim

  3 weeks ago

  Thanks for a great tutorial! You saved me many hours of troubleshooting!
  reply
• 

  Tjerk Zweers

  1 week ago

  Thanks for this excellent instructions. I have now WP 2.8 running smoothly on my Mac Mini.
  
  When I downloaded the mysql-5.1.35-osx10.5-x86.dmg I noticed that it included a Startup app. Once installed, this app starts up automatic the MySQL server after a reboot and no manual action is needed anymore.
  reply
• 

  qdideas

  1 week ago

  No problem! Thanks for the startup hint.
  reply