Installing MySQL & PHP Packages

Linux    |    Beginner
  • 14 videos | 1h 10m 30s
  • Earns a Badge
Rating 4.5 of 60 users Rating 4.5 of 60 users (60)
LAMP (Linux, Apache, MySQL, and PHP) is a stack for creating dynamic web sites. Discover how to install and work with the MySQL database, and install PHP and learn the basics of this language.

WHAT YOU WILL LEARN

  • Store data in a table in rdbms
    Install mysql on linux
    Start and verify the mysql service on linux
    Set password for the root user in mysql
    Create a user and a database in mysql
    Create a table and add data in mysql
    Install php packages in linux
  • Use if...else statements and switch operators for controlling flow
    Use while and for loops in php
    Connect php with the mysql database server
    Select data from the mysql table and display the table
    Install and use phpmyadmin to add and view data
    Create users and assign permissions by using phpmyadmin
    Install lamp and then connect php with the mysql server

IN THIS COURSE

  • 3m 25s
    In this video, you will learn how to store data in a table in a relational database management system. FREE ACCESS
  • 2m 18s
    In this video, you will install MySQL on Linux. FREE ACCESS
  • Locked
    3.  Verifying the MySQL Database
    2m 31s
    In this video, you will learn how to start and verify the MySQL service on Linux. FREE ACCESS
  • Locked
    4.  Securing the MySQL Installation
    2m 45s
    Learn how to set a password for the root user in MySQL. FREE ACCESS
  • Locked
    5.  Configuring the MySQL Server
    5m 44s
    In this video, you will learn how to create a user and a database in MySQL. FREE ACCESS
  • Locked
    6.  Creating a Table and Adding Data
    3m 10s
    In this video, you will create a table and add data to it in MySQL. FREE ACCESS
  • Locked
    7.  Installing PHP Packages
    4m 58s
    Learn how to install PHP packages on Linux. FREE ACCESS
  • Locked
    8.  Using Decision-making Operators in PHP
    7m 27s
    In this video, you will learn how to use if...else statements and switch operators for controlling the flow. FREE ACCESS
  • Locked
    9.  Using Loops in PHP
    5m 16s
    Learn how to use while and for loops in PHP. FREE ACCESS
  • Locked
    10.  Connecting PHP with MySQL
    8m
    Learn how to connect PHP with the MySQL database server. FREE ACCESS
  • Locked
    11.  Selecting Data from MySQL Database
    7m 30s
    Find out how to select data from the MySQL table and display it. FREE ACCESS
  • Locked
    12.  Installing phpMyAdmin
    5m 13s
    In this video, you will install and use phpMyAdmin to add and view data. FREE ACCESS
  • Locked
    13.  Administering MySQL Database by Using phpMyAdmin
    3m 18s
    In this video, you will create users and assign permissions using phpMyAdmin. FREE ACCESS
  • Locked
    14.  Exercise: Create a LAMP Stack
    8m 57s
    In this video, learn how to install LAMP and then connect PHP with the MySQL server. FREE ACCESS

EARN A DIGITAL BADGE WHEN YOU COMPLETE THIS COURSE

Skillsoft is providing you the opportunity to earn a digital badge upon successful completion on some of our courses, which can be shared on any social network or business platform.

Digital badges are yours to keep, forever.

YOU MIGHT ALSO LIKE

Book The Absolute Beginner's Guide to HTML and CSS: A Step-by-Step Guide with Examples and Lab Exercises
Book Getting Started with SQL and Databases: Managing and Manipulating Data with SQL
Course New Developments in Python
Rating 4.5 of 122 users Rating 4.5 of 122 users (122)