This is the second part of the article series detailing how to set up and configure a complete WordPress Development Environment on a MacBook Pro.
This is a must for a development environment on your Mac, so go ahead register and download the free MySQL Community Server.
Although you do not have to fill in all the details on the downloads page, you should consider this as a small token of appreciation of the efforts by the team behind this fantastic database system.
Double click the MySQL package (rather than the startup packge), and install away. My installation completed without issues.
Double click on the mySQL.PrefPane and select "install" when prompted. This is the preference tool letting you start and stop the MySQL server.
>Type 'help;' or '\h' for help. Type '\c' to clear the buffer.
So we are in business. Remember to set up the mysql binary directory in your path, so you do not have to remember and retype the entire path every time.
Now, if you want to test this, use the source command to process it, like source .profile and you should be able to start the MySQL client by typing myslq on the command line.
mysql> grant all on brams.* to tbrams@localhost identified by "b117"
This problem has to do with the location of the mysql.sock file. Previously, before Leopard, the default location for this file was in the /tmp</samp> directory. That location has now moved to the /var/mysql</samp> directory. PHP will look for it there.
Unfortunately, by default MySQL will still place it in the old location. So, we have a problem.
We can fix this by creating a my.cnfconfiguration file in the /etc</span> directory.
Unless you already have a MySQL config file in /etc/my.cnf, then you need to copy a template out of the support files from MySQL. I copied the small memory configuration template to /etc/my.cnf and launched my favorite editor.
Now try the http://brams/ again in the browser and you should see the list with employee names in the browser.
Read about how to install and configure WordPress in the next part of this article series.