One Geek\’s View On…

August 22, 2006

Setting up a Drupal work enviornment on my laptop…Part 3

Filed under: cms, drupal, howTo, LAMP, MacOSX, WebDev — Robbie The Geek @ 9:44 pm

Importing Drupal to MySQLOk the next step is to import the tables and all the guts of Drupal into your newly created database, for MySql 4.1 or higher (MAMP has MySQL5) you will need to import a file called database.4.1.mysql located in the /drupal-4.7.X/database as shown in the picture to the left. It is that simple and you are almost there with your very our sandbox for development. You will have to edit a file in the /{drupal}/sites/default/settings.php and change one line.

$db_url = ‘mysql://username:password@localhost/databasename’;

to whatever the fields are in your environment this is what mine looks like

$db_url = ‘mysql://drupal:drupal@localhost/drupal’;Admin>Settings>File System Settings

This should be the final step to your new drupal install last step is to log in and create your primary (administrative) account for your site. On a side note I have had an issue a few times when you click on Administration>>Settings for the first time that there is an issue with the files folder


August 21, 2006

Setting up a Drupal work enviornment on my laptop…Part 2

Filed under: drupal, howTo, LAMP, MacOSX, WebDev — Robbie The Geek @ 10:25 am

phpMyAdmin create dbWelcome back I am now going to talk about the way that MAMP handles serving up files through Apache2. By default you install MAMP into the Applications directory on Mac OSX in a folder and the default path to the folder that is being served by Apache is /Applications/MAMP/htdocs/ . This is the folder that you will want to expand the Drupal folder after you have downloaded it directly from (if you are running MAMP which I will assume you are if you are reading through my little howto scenario here then you are running MySql 5) you need to create and populate phpMyAdmin Create drupal userthe database for Drupal. To do this you will need to pop over to phpMyAdmin (see screenshot to the right)and create a new database called whatever you like, and also create a new user for security reasons to assure that drupal can talk to your database without using the root account. Create a new user with a password you will need this to tell drupal what the default link connection information is to your new database.phpMyAdmin drupal user rights adn privilidges After this you will need to grants the user rights to your newly created database, this is very simple because the user you created can just be given all rights by clicking the check all link at the top of the database privileges window. I am off to my day job now I will try to work on the next installment in this howTo later today 🙂

August 20, 2006

Setting up a Drupal work enviornment on my laptop…Part 1

Filed under: drupal, howTo, LAMP, MacOSX, WebDev — Robbie The Geek @ 3:28 pm

A very useful way to setup a web development enviornment is an all-in-one solution that includes a web server, a database, server-side scripting support. I am running MacOSX and needed a solution like this and I have come across a great project called MAMPMAMP Screenshot. I haven’t previously mentioned my enviornment for web design on my laptop but I ahve been happily using this all-in-one testing solution for all my web development. I really like it one click of an icon starts a local webserver so you can have other machines on your network (specfically ones running the dreaded Internet Explorer) test your creations.MAMP Start page After you start MAMP you are faced with the screenshot you see on the right, and then poof your browser of choice will open up a MAMP Start page. This is a great all in one solution for us MacFolks, and it quickly and powerfully gets us setup with a true development enviornment using Apache2, MySQL 5 & PHP 4 or 5. Once you start MAMP your web browser will pop open and you will see the a MAMP start Page like the one I see on the left of this blog post. I will be back soon to take you through the some of the finer details of MAMP, and how to install Drupal into MAMP.

Blog at