coolestguyplanet.net | Neil Gee

The 6 Step Plan Step 1 – Connecting to a MySQL database You need your MySQL username, password and server address (most likely localhost or 127.0.0.1). Create a .php file and open and close the php code with tags before the html, you can put regular html after it. Open the file in a browser [...]

The mcrypt extension is missing. Please check your PHP configuration. The above error appears after you successfully get phpMyAdmin up and running on OS X, generally you don’t have to worry about it, you only need to address the error if you are going to use a web application that requires it, for example Magento, the shopping [...]

Once you have installed MySQL onto OS X / OS X server, MySQL will basically run OK under a light load. If you want to change some variables in the database settings via the configuration file you will notice that there isn’t one there, filed normally in /etc.  This is the default behaviour as a [...]

If you have forgot, can’t remember or want to break in….. how to change the mysql root password from the command line in either Linux or OS X: Stop MySQL Start it in safe mode: This will be an ongoing command until the process is finished so open another shell/terminal window, log in without a [...]

On OS X to start/stop MySQL from the command line: On Linux start/stop from the command line: Some Linux flavours offer the service command too or Tweet

Use a different nameserver to look up dns information or check that your nameserver is acting OK  - use the public Google ones at: 8.8.8.8 8.8.4.4 For dig use it like so: For nslookup: For nslookup interactively: $ nslookup > server 8.8.8.8 Default server: 8.8.8.8 Address: 8.8.8.8#53 > bbc.com Server: 8.8.8.8 Address: 8.8.8.8#53 Non-authoritative answer: [...]

Some of the firewall scripts that come with various hosting companies can leave a lot to be desired, and tackling IP tables head on can be intimidating, here is how to disable the default firewall and use an industry standard one which provides bot a CLI and GUI through WHM. CSF is Config Server Firewall, [...]

This tutorial assumes a certain degree of comfort in the command line Terminal for installing WordPress on Mac OS X Lion or Snow Leopard but the commands below will get the job done. Before proceeding WordPress needs a couple of things to get going and those things are an AMP stack  - Apache, MySQL and [...]

Fastest Way to install the latest Drupal 7 version on Mac OS X Lion 10.7 Drupal is a quality CMS application and is as simple or complex as your needs vary, it runs on the same foundations that Mac OS X Lion or Snow Leopard provides. This tutorial assumes a certain degree of comfort in [...]

To get simplified administration done and command line free MySQL work, phpMyAdmin comes to the rescue, to get it running as part of your local development set up on OS X, a couple of steps need to be preconfigured. These steps will work on both OS X 10.7 Lion and 10.6 Snow Leopard. Download phpMyAdmin, [...]