Welcome back to Introduction to Drupal. This is the second part of the MOWES Portable install tutorial, getting our technology stack installed, up and running and then we're going to go ahead and set up a MySQL database for our Drupal website and then I'm going to show you how to install Drupal. In the last tutorial you will recall that we ran the MOWES Portable executable. That was on our C drive and we installed it, we extracted the MOWES Portable zip folder and that created a bunch of files including this MOWES executable file. We ran that and it installed the applications My SQL. PHP 5 and it created a folder for our websites; WWW. When I come back to my computer, my local Desktop environment and I have the MOWES Portable installed, I will have this smaller screen that will appear on my Desktop. This is the MOWES Portable status screen. If I click MOWES.exe to actually start that MOWES application, it will start Apache and start My SQL. If I stop the server at this point it will stop the Apache and MySQL servers from running and then I won't be able to get to them. But if I go ahead and start the server, it'll restart. So that's how I stop and start my local server environment. Now, I know that my server's running here and then what I can do is fire up my web browser and go to my local host, http://localhost. This is the web address of my local web server environment. It's just running on my computer. You notice that it fires up the MOWES Portable screen and MOWES Portable tells me that Apache's running PHP Works and MySQL is running and I also have a link here that will take me directly to my phpMyAdmin database screen. If I click on that link it will launch phpMyAdmin. Now, phpMyAdmin is a great tool, a visual interface for creating our database users and our databases, our MySQL databases that we need for our Drupal sites to run off of. So what we're going to do here is we're going to go ahead and create a database and a database user for our first Drupal site. So to do that we're going to go down here to the Privileges link and I'm going to go ahead and click on that and it's going to bring up a list of the users that I have running on MySQL database. I'm going to click on Add a New User and I'm going to go ahead here and type a user name in. So my user is going to be called Drupal 6 and I want to make sure that my host is the local host. So I just choose Local Host here and my password is going to be whatever I choose to put in there. So go ahead and type a password in and I'm going to confirm that password. Now, I'm going to scroll down and I'm going to have phpMyAdmin create the database with the same name as my user. So it's going to go ahead and create a database called Drupal 6 for this user and then I'm going to attach, I'm going to give this user permissions to do everything to this database. I'm going to grant all permissions. This is going to be the super user for this database. So I'm going to have my user name in there, the host, create database with the same name, check all for privileges and go ahead and create that DB. Successfully creates the database. You'll see over here and the user. It gives you some information here about actual queries it ran to create everything and then here's my database. If I click on my actual database, there's no tables in the database yet because we haven't installed Drupal yet. Now we have a fresh MySQL database ready to go, ready to be populated by our Drupal database tables. So in this tutorial I've show you how to easily create a MySQL database user and a MySQL database using the phpMyAdmin tool. In the next tutorial I'm going to go ahead and show you how to install Drupal 6.8 and make Drupal 6.8 talk to this database that we've created.
| Course: | Introduction to Drupal 6 |
| Author: | Trevor James |
| SKU: | 33992 |
| ISBN: | 1-935320-43-2 |
| Release Date: | 2009-05-01 |
| Duration: | 11.5 hrs / 114 lessons |
| Captions: | No |
| Compatibility: |
Vista/XP/2000, OS X, Linux QuickTime 7, Flash 8 |