

Installing SID on Windows

From: MySQL Essential Training

Video: Installing SID on Windows

In this movie, I'll show you how to And that's where everything goes that can be seen by the web server.

Installing SID on Windows

In this movie, I'll show you how to install the SID application on a PC running Windows. First thing we're going to do is we're going to bring up php My Admin, we're going to import some databases. So I bring up Local Host and, I click on php MyAdmin. I'm going to come over here to Import. And choose File. So there is three databases we're going to import. I'm going to import each of these one at a time, so I start with album MySQL, want to make sure the character set is set to UTF-8 and if it's not you want to select that, and I'll scroll down here and press Go and that import it.

That first album database. And now we're going to do the same thing for the other two so, scratch, open, UTF-8, Go. And, world. Open. UTF-8, and this one takes just a little bit longer. And there we go. So now if we come over here to databases we see these databases that we just imported. There's the album database, and the scratch database, and the world database.

So I'l go ahead and close the browser for now, and now we're going to install SID and another application called CRUD. And we're going to install these in the xanp folder and under xanp. See a folder called htdocs. And that's where everything goes that can be seen by the web server. And so that's where our applications are going to get installed, so I'm going to come over here to our exercise files, I'm going to take these two folders, SID and CRUD. I'm holding down the Ctrl key as I select them so that I get both of those folders, and.

There into our HT docs folder I'm just going to drag those. I'm going to hold down the Ctrl key while I drag them so that they get copied, and not moved. So, now we have copies of them and you see that they still exist here in the exercise files. And that's important. Because if, for some reason you make a mistake while editing them or something, you've still got another copy of them. They're not very big. So we'll start in the SID folder. And we're going to edit this sid.php. I've got it configured here so that when I, open a php file it, opens it with, Notepad++.

Or you can right click on this and you can select Open with. And under more options you can find out how to open it with Notepad++ the application. So I'm just going to go ahead and open this with Notepad++ and there's our sid.php and as I scroll down here. Somewhere around line 50 you'll see something that says MySQL pass and you notice that the user's already set to SID but you want to make sure that the user is set to SID and then the password is going to be that password that you entered in the lesson on setting up the users.

And I'm going to enter the silly password that I entered there, press Ctrl+S to save, and again don't use this password, this is just for demonstration purposes. And so I'm going to go ahead and close SID, and I'm going to Open. See if this will give me the same directory. It does. So under htdocs I'm going to come over here to CRUD. And I'm going to open Crud.php and you notice that the user here is Web and the password is going to be whatever password you entered for Web. And I'm going to enter my silly password.

Ctrl+S to Save, close that, close this, close this, and bring up the web browser. Now here I can type in localhost, and I'm going to type a slash and SID in all caps and another slash and sid lowercase .php and that's the path to the SID application there. In the htdocs which is where web server reads all files from. And I press Enter and there we have SID, and SID is working and we can see it's bringing up the database.

I can bring up the album database here and just type in a query, SELECT asterisk FROM track and press Go and there's all the tracks. In our track table in the album database. And I can test each of these different databases here. From the scratch database, I can use the customer table. And I get results. And from the world database, I can use the City table. There's a very long list of over 4,000 cities. You'll notice we have a little status line here.

It tells us how many rows are returned and the elapsed time. And so the SID application's working. I can drag this out onto my toolbar. And now, every time I press that, I get this SID application. And I can go ahead and. Get to the CRUD application, which is all caps CRUD/crud.php press Enter up here, there we go. There's our CRUD application. CRUD of course stands for create, read, update, delete that's the. Four basic functions of any database system.

And here we have, this is authenticating with the web user, you remember. And it's using the album database. And so if I come over here to this album, you notice there's the tracks in the album. And this application is working as well. And I can bring this down here and I can put it in my toolbar. So I've got CRUD and I've got SID, and I can get to those. From my toolbar very easily. So now that SID is installed and working you have everything you need to follow along with the exercises in this course. So, let's get started

Show transcript

This video is part of

Image for MySQL Essential Training
MySQL Essential Training

60 video lessons · 10307 viewers

Bill Weinman

Expand all | Collapse all
  1. 4m 22s
    1. Welcome
      1m 3s
    2. Using the exercise files
      1m 31s
    3. What is MySQL?
      1m 48s
  2. 45m 37s
    1. Installation overview
      3m 16s
    2. Installing XAMPP on Windows
      5m 55s
    3. Installing XAMPP on the Mac
      6m 38s
    4. Setting up MySQL users
      11m 31s
    5. Installing SID on Windows
      5m 43s
    6. Installing SID on the Mac
      6m 6s
    7. Installing time zone support in MySQL on Windows
      6m 28s
  3. 45m 43s
    1. The SELECT statement
      3m 57s
    2. Selecting rows
      4m 57s
    3. Selecting columns
      3m 8s
    4. Sorting results with ORDER BY
      2m 58s
    5. Filtering results with WHERE
      3m 52s
    6. Filtering results with LIKE and IN
      3m 41s
    7. Filtering results with regular expressions
      8m 21s
    8. Inserting rows
      4m 9s
    9. Updating rows
      2m 21s
    10. Deleting rows
      2m 25s
    11. Literal strings
      3m 12s
    12. Understanding NULL
      2m 42s
  4. 41m 47s
    1. Creating a database
      4m 30s
    2. Creating a table
      7m 18s
    3. Creating indexes
      6m 8s
    4. Controlling column behavior with constraints
      4m 46s
    5. Creating an ID column
      6m 58s
    6. Using foreign key constraints
      7m 58s
    7. Altering a table
      4m 9s
  5. 28m 56s
    1. What are data types?
      4m 1s
    2. Numeric types
      5m 21s
    3. String types
      2m 58s
    4. Date and time types
      7m 2s
    5. Bit type
      2m 26s
    6. Boolean values
      2m 15s
    7. Enumeration types
      4m 53s
  6. 32m 34s
    1. String functions
      6m 57s
    2. Numeric functions
      6m 2s
    3. Date and time functions
      4m 12s
    4. Time zones in MySQL
      3m 37s
    5. Formatting dates
      1m 51s
    6. Aggregate functions
      5m 45s
    7. Flow control with CASE
      4m 10s
  7. 7m 6s
    1. Maintaining database integrity with transactions
      4m 46s
    2. Using transactions for performance
      2m 20s
  8. 16m 49s
    1. Updating a table with a trigger
      5m 11s
    2. Preventing automatic updates with a trigger
      7m 29s
    3. Logging transactions with a trigger
      4m 9s
  9. 14m 11s
    1. Creating a simple subselect
      3m 23s
    2. Searching within a result set
      3m 53s
    3. Creating a view
      3m 32s
    4. Creating a joined view
      3m 23s
  10. 12m 26s
    1. Understanding MySQL stored routines
      2m 0s
    2. Creating a stored function
      4m 34s
    3. Creating a stored procedure
      5m 52s
  11. 14m 4s
    1. The multi-platform PDO interface
      3m 44s
    2. Executing the SQL
      4m 8s
    3. Implementing auto-increment IDs
      2m 3s
    4. Using a stored funciton
      4m 9s
  12. 1m 3s
    1. Goodbye
      1m 3s

Start learning today


Become a member
Share a link to this course

What are exercise files?


Can I take this course without the exercise files?


Become a member Download sample files See plans and pricing

Please wait... please wait ...
Upgrade to get access to exercise files.

Exercise files video

How to use exercise files.


Exercise files

Exercise files video

How to use exercise files.





Mark all as unwatched Cancel


You have completed MySQL Essential Training.


Become a member to add this course to a playlist


Get started

Already a member ?

Become a member to like this course.


Get started

Already a member?

Exercise files


Get started

Already a Premium member?

Exercise files video

How to use exercise files.

Ask a question

Thanks for contacting us.
You’ll hear from our Customer Service team within 24 hours.

Please enter the text shown below:

The classic layout automatically defaults to the latest Flash Player.


Continue to classic layout Stay on new layout
Exercise files

Access exercise files from a button right under the course name.

Mark videos as unwatched


Control your viewing experience


Interactive transcripts


Learn more, save more. Upgrade today!

Get our Annual Premium Membership at our best savings yet.



Thanks for signing up.

We’ll send you a confirmation email shortly.






submit Lightbox submit clicked
Terms and conditions of use

Review and accept our updated terms of service.